Testing the Oracle client 32-bit net configuration

The steps required to test the Oracle Net configuration on all hosts with Tivoli® Netcool® Performance Manager components.

About this task

To test the Oracle Net configuration:

Procedure

  1. Log in as root.
  2. Set the ORACLE_HOME VARIABLES. 
    # export ORACLE_HOME=/opt/oracle/product/12.1.0-client32
# export TNS_ADMIN=$ORACLE_HOME/network/admin
# export PATH=$ORACLE_HOME/bin:$PATH
  3. Enter a command with the following syntax: 
    tnsping Net_service_name 10

    For example: tnsping PV.WORLD 10

    Note: Ensure that you test all the connection of the Net_service_name that you have configured for your deployement in your tnsnames.ora file.
  4. Test again, using the same Net instance name without the domain suffix: 
     tnsping PV 10

    Look for successful completion messages (OK).