Previous Topic: Updating the arcot-db-config-for-common-2.0.sql ScriptNext Topic: Updating the Database Connection Details

CA RiskMinder Windows Installation Guide › Upgrading to Release 3.1.01 › Configuring CA RiskMinder for Oracle RAC › Updating the arcotcommon.ini File

Updating the arcotcommon.ini File

The arcotcommon.ini file contains the parameters for database and instance settings. When you run the installer, database configuration data items that you enter on the installer screens are stored in this file. The JDBC URL of the database is one such data item. If you are using Oracle RAC, specify the JDBC URL in the format supported by Oracle RAC.

Follow these steps:

  1. Open the arcotcommon.ini file in a text editor. This file is in the install_location\Arcot Systems\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 AuthMinder 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\win directory. Instructions on using DBUtil are given in Preparing for the Upgrade to Release 3.1.01.
  4. Save and close the arcotcommon.ini file.