Is oracle cloud supported as cms database reposiroty?

[gabriela_urqua]

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

[denis_konovalov]

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).

[gabriela_urqua]

Hello Denis

The DB that is in the cloud is Oracle 11gR2, the same version of the database we have inhouse. So it is supported. I am using an IPS 4.2 SP3 Patch 4. I also review the CMS trace logs located in logging dir, but they don't give me any better information. Is there another log that I can review? I also think that could be a connectivity issue, but as I told you the cmsdbsetup.sh copied succesfull the information to the cloud. So I am not sure it could be connectivity.

If you have any another idea it would be great!

Thanks in advance

[denis_konovalov]

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.