Skip to Content
avatar image
Former Member

BO database with New Oracle ODA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 22 at 03:11 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 22 at 03:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 22 at 05:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22 at 03:19 PM

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

    Add comment
    10|10000 characters needed characters exceeded