Oracle RAC connection

Products

• CA Rapid App Security
• CA Advanced Authentication
• CA API Gateway

Issue/Introduction

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.