Issues connecting to SCAN address of an Oracle RAC Database

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

Our database is setup in a RAC configuration with a SCAN configuration and has multiple IP addresses.

How can we get RM/AM to connect to a highly available Oracle instance?

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:

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.

Below string is only for JDBC connection: 

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

(ADDRESS=(PROTOCOL=TCP)(HOST=<NODE1>)(PORT=1521)) 

(ADDRESS=(PROTOCOL=TCP)(HOST=<NODE2>)(PORT=1521))) 

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

3. Save and close the arcotcommon.ini file.

4. For ODBC just use 

HostName=<Just scan name> (we should not use jdbc string here) 

ServiceName=(not the SID.. the ServiceName) 

ConnectionRetryCount=10 

ConnectionRetryDelay=10 

LoadBalancing=1