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"?
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.