Our database is setup in a RAC configuration with a SCAN configuration and has multiple IP addresses.
How can we get RM/AM to connect to a highly available Oracle instance?
Follow these steps to configure CA Advanced Authentication for Oracle RAC database:
1. Open the arcotcommon.ini file from the location <ARCOT_HOME>\conf.
2. Use below jdbc string to specify the URL parameter in the [arcot/db/primarydb] section and, if necessary, [arcot/db/backupdb] section as well.
Below string is only for JDBC connection:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=<NODE1>)(PORT=<DBPort>))
(ADDRESS=(PROTOCOL=TCP)(HOST=<NODE2>)(PORT=<DBPort>)))
(CONNECT_DATA=SERVICE_NAME=<SERVICENAME>)(SERVER=DEDICATED)))
3. Save and close the arcotcommon.ini file.
4. For ODBC just use
HostName=<Just scan name> (we should not use jdbc string here)
ServiceName=(not the SID.. the ServiceName)
ConnectionRetryCount=10
ConnectionRetryDelay=10
LoadBalancing=1