Installation Guide › Installing CA GovernanceMinder and Oracle RAC › Verify Oracle TNS Identifies Database Cluster

Verify Oracle TNS Identifies Database Cluster

You verify that the Oracle TNS entries in the tnsnames.ora file identify your Oracle RAC database structure. Oracle Transparent Network Substrate (TNS) provides a network platform of different protocols to function as a homogeneous network. The tnsnames.ora file is a configuration file that defines database addresses by establishing connections to them.

Follow these steps:

1. Locate the tnsnames.ora file on the computer hosting the CA GovernanceMinder Discovery and Audit tool.

   The tnsnames.ora file is located in the following folder:

   Oracle_home/NETWORK/ADMIN
   

2. Open the tnsnames.ora file and verify that the existence of TNS entries identifies your database cluster.

   Example:

   RCMDB1 =
   

     (DESCRIPTION =
   

       (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
   

       (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
   

       (LOAD_BALANCE = yes)
   

       (CONNECT_DATA =
   

         (SERVER = DEDICATED)
   

         (SERVICE_NAME = RCMDB1)
   

       )
   

     )
   

3. Save and close the file.

   You have verified that the Oracle TNS entries in the tnsnames.ora file identify your Oracle RAC database structure. You now install and configure CA GovernanceMinder Discovery and Audit tools to work with Oracle RAC databases.