BO database with New Oracle ODA

[Former Member]

Hi All,

We are currently on BO 4.2 SP4 on Oracle 12 c. Now our database team moving to new Oracle ODA, with this Oracle HOST name changes from "A" to "B".

From BO end, I need to updated Oracle client_32 and 64 TNSname file with new ODA name (\Oracle\product\11.2.0\client_1\network\admin\T<TNSfile>) or there any other updates/taks i need to perform?

Please share your inputs

Thanks

Geetha

[denis_konovalov]

I would start with verifying that the new Oracle ODA is compatible with your version of BOE.
Everything else is secondary.

[former_member185603]

As Denis mentioned above, can you check if Oracle ODA is supported DB for BO.

Regarding the changes to TNS , it looks like you are planning to change the name of TNS, in that case, you need to change all the connections and CMS/Audit DB connection, if they exists in the same DB.

[Former Member]

This is our scenario.

Present:

AAAAA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <database servername-1>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PRODDB) ) )

Future:

BBBBB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <database servername-2>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PRODDB) ) )

[denis_konovalov]

then all connections that you have to that oracle will need to be updated with new service name.

[former_member185603]

As long as TNS name of the DB stays the same, you don't need to do anything. if not, you need to update the relational connections to the DB and also CMS DB/Audit DB connections.