Previous Topic: Updating the arcot-db-config-for-common-2.0.sql ScriptNext Topic: Updating the odbc.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/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/<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.