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

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

book

Article ID: 6866

calendar_today

Updated On:

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