Oracle RAC connection

Article Id: 5709

Status: Published

Updated On: 14-02-2018 08:09

Legacy Id: TEC1530997

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.