search cancel

Oracle RAC connection for Advanced Authentication

book

Article ID: 5709

calendar_today

Updated On:

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=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 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=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.