Skip to Content
avatar image
Former Member

Is oracle cloud supported as cms database reposiroty?

Hello

We are moving our Oracle database to Oracle cloud. So, we made and import/expor of the schemas of the CMS Database Repository of the Information Platform Services (IPS). We just change the IP address in the tnsnames to point to the new cloud server, but when trying to start SIA then the CMS can not start and crash with the error "CentralManagementServer stopped with exit code = 139 (0x8b)."

So we decided to copy the CMS datasource to the cloud using the cmsdbsetup.sh util, but it doesn't work.The copy was succesfull but when starting the servers we got the same error with the CMS and servers can not start.

I also review the PAM but I can not find anything that support if Oracle cloud is supported or not, Is there any procedure we must follow to change the database?

Thank you very much

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 03 at 04:05 PM

    Oracle cloud is not a DB, its a place - what DB is that cloud and is it actually supported ? (also what is your BI Platform version ?)
    If CMS can't connect to it - review the CMS trace logs to see if there is a better error message there.
    Could it be that the connectivity to this cloud DB is not fully functional ? (tho is smcdbsetup.sh was able to connect to copy DB - it should work).

    Add comment
    10|10000 characters needed characters exceeded

    • you need to enable high level trace for the CMS server to see more details.
      enabling trace on the SIA can help as well.
      I'll go as far as to enable trace on oracle client, to see what's happening when CMS is starting from oracle side.

      I suspect there is something between your server and Oracle DB in the "cloud" that is preventing correct connection.