Idea ID 1684640
HP NA 10.x is not able to connect to more than one Oracle Dataguard node.
"JDBCDrivers.properties" file couldn't interpret a connection string with the following format :
oracle.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST= host1.oracledatguard.com) (PORT=1523))(ADDRESS=(PROTOCOL=TCP)(HOST= host2.oracledatguard.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=NAPRD_WEB)))
where : host1.oracledatguard.com is the primary Oracle Dataguard node (Primary site)
host2.oracledatguard.com is the standby Oracle Dataguard node (Secondary site)
It only accepts something like that :
Also, the tc_tools.sh utility is obsolete as it asks for node name (which is one and only one node) and database name (instead of asking for service name). Access to database should be done through service names and not through a direct Database instance connection anymore.
So, is it possible to add NA support for more than one Oracle Dataguard node so when losing a primary site, NA application continues to work with the new Dataguard node (previously the standby node) instead of configuring it manually at each site loss in the "JDBCDrivers.properties" ?
Thank you and best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.