Creating the tnsnames.ora file

The tnsnames.ora file maintains the relationships between logical node names and physical locations of Oracle servers in the network.

1. FTP the following file from your Oracle server:

   /opt/oracle/admin/skeleton/bin/template.example_tnpm.tnsnames.ora 

2. Add the following lines:

     # tnsnames.ora network configuration file in 
     # /opt/oracle/product/12.1.0/network/admin
    #
     # For Oracle client installations, tnsnames.ora
     # only needs the PV.WORLD entry.
    PV.WORLD =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS =
            (PROTOCOL = TCP)
             (HOST = yourhost)
            (PORT = 1521)
          )
        )
        (CONNECT_DATA =
           (SERVICE_NAME = PV.WORLD)
          (INSTANCE_NAME = PV)
        )
      )
    

   Note: Indents in this file must be preserved.
3. Replace the string yourhost in the line (HOST = yourhost) with the name of your Oracle server.

   Note the following:

   • You can use the value in the INSTANCE_NAME field as the TNS entry when installing DataMart.
   • If you reconfigure the Oracle client to connect to a different Oracle database in another Tivoli® Netcool® Performance Manager installation, be sure that you update the HOST entry in the tnsnames.ora file, then restart the Oracle client.
   • Specify the host by using the hostname only, do not use the IP address.
4. (optional) Replace the default port number 1521 in the line (PORT = 1521) with your required port number.
5. Write and quit the file.

Tivoli Netcool Performance Manager non-default installation

6. For a non-default Tivoli Netcool Performance Manager installation, where oracle is installed with a non-default parameter, add the following lines.

   For example, ORACLE_SID is set to PVR during oracle installation. The tnsnames.ora file must have the following entries.

     # tnsnames.ora network configuration file in 
     # /opt/oracle/product/12.1.0/network/admin
   
   PV.WORLD =
   (DESCRIPTION =
   (ENABLE=BROKEN)
   (ADDRESS_LIST =
   (ADDRESS =
   (PROTOCOL = TCP)
   (HOST = yourhost)
   (PORT = 1521)
   )
   )
   (CONNECT_DATA =
   (SERVICE_NAME = PVR.WORLD)
   (INSTANCE_NAME = PVR)
   )
   )
   
   PVR.WORLD =
     (DESCRIPTION =
     (ENABLE=BROKEN)
     (ADDRESS_LIST =
       (ADDRESS =
       (PROTOCOL = TCP)
       (HOST = yourhost)
       (PORT = 1521)
       )
     )
     (CONNECT_DATA =
       (SERVICE_NAME = PVR.WORLD)
       (INSTANCE_NAME = PVR)
     )
     )
   

7. Write and quit the file.