Oracle RAC connection for Advanced Authentication

Products

• CA Advanced Authentication
• CA Strong Authentication
• CA Risk Authentication

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

) 

) 

(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.x

CA Risk Authentication 8.x

Oracle 12 RAC

Resolution

Follow these steps to configure CA Advanced Authentication for Oracle RAC database for Java components like ArcotAdmin.ArcotUDS,State Manager

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=<DBHost>)(PORT=<DBPort>)) 

(ADDRESS=(PROTOCOL=TCP)(HOST=<DBHost>)(PORT=<DBPort>))) 

(CONNECT_DATA=SERVICE_NAME=<Service_Name>)(SERVER=DEDICATED)))

3. Save and close the arcotcommon.ini file.