Oracle RAC connection

Document ID : KB000005709
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

I am installing CA AA with an Oracle RAC database, this database has a balancer and the client provided us with a connection string for the database instance: 

Example of connection string: 

"name_service_description= 

(DESCRIPTION= 

(ADDRESS_LIST= 

(FAILOVER=on) 

(LOAD_BALANCE=yes) 

(ADDRESS= 

(PROTOCOL=TCP) 

(HOST=IPHOST) 

(PORT=1521) 

(CONNECT_DATA= 

(SERVER=dedicated) 

(SERVICE_NAME=name_service) 

Do I have to do the additional Risk and Strong Post Installation Configurations "Oracle RAC Configuration"?

Environment:
CA Strong Authentication 8.xCA Risk Authentication 8.xOracle 12 RAC
Resolution:

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.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) 

(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) 

(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) 

(CONNECT_DATA=SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))

3. Save and close the arcotcommon.ini file.