CA AuthMinder Windows Installation Guide › Configuring CA AuthMinder 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 7.1.01.
4. Save and close the arcotcommon.ini file.

Updating the Database Connection Details

To establish a connection between AuthMinder and Oracle RAC, you must create an ORA file and define the address for connecting to the RAC.

Follow these steps:

1. Create a *.ora file on the system on which you have installed AuthMinder. For example, C:\Program Files (x86)\tns.ora.
2. Add the following lines in the new file:

   section_name =
     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = host_name_or_IP_address)(PORT = 1521))
       )
       (CONNECT_DATA =
         (SERVICE_NAME = service_name)
       )
     )
   

   For example:

   fwdincrac =
     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.250.18)(PORT = 1521))
       )
       (CONNECT_DATA =
         (SERVICE_NAME = forwardinc)
       )
     )
   

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

3. Save the file.
4. Modify the DSN that you created during the installation.
5. For the required DSN, clear all the parameters in the Standard Connection section.

   This makes the TNSNames Connection section editable.

6. Add the following parameters to this section:

   TNSNamesFile=ARCOT_HOME\ora_file_name
   ServerName=section_name
   
   

   For example:

   TNSNamesFile= C:\Program Files (x86)\tns.ora
   ServerName=fwdincrac
   
   

7. Save and close the file.