IG Import failed under Oracle RAC with multi-hosts

Products

• CA Identity Governance

Issue/Introduction

Does IG support Oracle RAC with multi-hosts?  Import failed after configuring JDBC with the following 

/subsystem=datasources/data-source=WPDS/:write-attribute(name=connection-url,value="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=2570))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=2570)))(FAILOVER=ON)(LOAD_BALANCE=OFF)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))") 

 

Environment

Identity Governance 14.5  Oracle 19c

Cause

Incorrect configuration

Resolution

Identity Governance supports multi-hosts on Oracle RAC.  Configure JDBC URL with dual hostname as sample

jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=hostname1)(port=1521))(address=(protocol=tcp)(host=hostname2)(port=1521)))(connect_data=(service_name=orcl)(failover_mode=(type=select)(method=basic))))