Issues connecting to SCAN address of an Oracle RAC Database for Advanced Authentication

Products

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

Issue/Introduction

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

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

(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