Previous Topic: Modify the Database ScriptNext Topic: Update the odbc.ini File


Configure the JDBC URL

Specify the JDBC URL in the format supported by Oracle RAC in the arcotcommon.ini file.

Follow these steps:

  1. Open the arcotcommon.ini file in a text editor. This file is in the install_location/arcot/conf/ directory.
  2. Specify a value for the URL parameter in the [arcot/db/primarydb] section and, if required, in the [arcot/db/backupdb] section of the INI file. Enter the URL in the following format:
    URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))
    

    For example:

    URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.30.250.18)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=forwardinc)(SERVER=DEDICATED)))
    

    Note: If Oracle RAC is client configured, then include all the nodes in this format.

  3. If the database user that you specified while running the CA Strong Authentication installer is different from the database user in Oracle RAC, then:
    1. Change the database user credentials in the arcotcommon.ini file.
    2. Use DBUtil to change the database user credentials in the securestore.enc file. DBUtil is available in the ARCOT_HOME/tools/<platform_name> directory. Instructions on using DBUtil are given in Updating the securestore.enc File and Setting the TrustStore Password.
  4. Save and close the arcotcommon.ini file.