CA RiskMinder Windows Installation Guide › Upgrading to Release 3.1.01 › Configuring CA RiskMinder for Oracle RAC › Updating the Database Connection Details

Updating the Database Connection Details

To establish a connection between RiskMinder 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.