CA Risk Authentication UNIX Installation Guide › CA Risk Authentication Configuration for Oracle RAC › Update the arcotcommon.ini File

Update the arcotcommon.ini File

The arcotcommon.ini file contains the parameters for database and instance settings. To use Oracle RAC you 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 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 CA Strong Authentication installer is different from the database user in Oracle RAC, then change the database user credentials in the arcotcommon.ini file.
4. Use the DBUtil utility to change the database user credentials in the securestore.enc file. DBUtil is available in the ARCOT_HOME\tools\win directory.
5. Save and close the arcotcommon.ini file.

Update the Database Connection Details

To establish a connection between CA Risk Authentication 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 CA Strong Authentication. 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.