CA Strong Authentication Windows Installation Guide › CA Strong Authentication Configuration for Oracle RAC › Update the odbc.ini File

Update the odbc.ini File

The odbc.ini file contains connection parameters. For Oracle RAC, you must specify values pertaining to the Oracle RAC installation in the odbc.ini file.

Follow these steps:

1. Create a *.ora file on the system on which you have installed CA Strong Authentication. For example, /var/opt/tns.ora.
2. Enter the following lines in the 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. Open the ARCOT_HOME/odbc32v60wf/odbc.ini file in a text editor.
5. For the required DSN sections, comment out the lines containing the following parameters:
   • HostName
   • PortNumber
   • SID

   For example:

   #HostName=172.30.251.251
   #PortNumber=1521
   #SID=an
   

6. Add the following parameters:

   TNSNamesFile=ARCOT_HOME/ora_file_name
   ServerName=section_name
   

   For example:

   TNSNamesFile=/var/opt/tns.ora
   ServerName=fwdincrac
   

7. Save and close the file.