9.36. Configuration for the oratnsping check

This check pings an oracle listener via 'tnsping tns-name' whether to see if alive or not

ORATNSPING

Explanation

ORATNSPING is the enclosing tag for all tnsnames2ping tags

Parent

OSAGENT

allowed values

Count

0 or 1. If you don't define ORATNSPING, no oratnsping check will run.

Example
<ORATNSPING>
  <TNSNAME2PING>
    <TNSNAME>osmartdb1</TNSNAME>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TNSNAME2PING>
  <TNSNAME2PING>
    <TNSNAME>osmartdb2</TNSNAME>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TNSNAME2PING>
</ORATNSPING>
        

ORACLE_HOME

Explanation

If no ORACLE_HOME shell variable is set, you have to define the ORACLE_HOME tag to find the tnsping utility

Parent

ORATNSPING

allowed values

define your ORACLE_HOME here like you did it at the installation of the Oracle Server/Client. Note: The tnsping binary sould be located under ORACLE_HOME/bin/tnsping

Count

0 or 1.

Example
<ORATNSPING>
  <ORACLE_HOME>/usr/local/oracle/product/10.1.0</ORACLE_HOME>
  <TNSNAME2PING>
    <TNSNAME>osmartdb1</TNSNAME>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TNSNAME2PING>
  <TNSNAME2PING>
    <TNSNAME>osmartdb2</TNSNAME>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TNSNAME2PING>
</ORATNSPING>
        

TNSNAME2PING

Explanation

for every tns-name you want to oratnsping you have to define the TNSNAME2PING-pair

Parent

ORATNSPING

allowed values

Count

As many as you like.

Example

Look at ORATNSPING

TNSNAME

Explanation

Here you have to specify which tns-name you want to ping. Your tnsnames are configured in a file called tnsnames.ors located in $TNS_ADMIN (if set) or in $ORACLE_HOME/network/admin.

Parent

TNSNAME2PING

allowed values

tns-name (string) / can be found in tnsnames.ora

Count

1. Have to be set to know what I should ping

Example
<ORATNSPING>
  <ORACLE_HOME>/usr/local/oracle/product/10.1.0</ORACLE_HOME>
  <TNSNAME2PING>
    <TNSNAME>osmartdb1</TNSNAME>
    <ERRORLEVEL>ERROR</ERRORLEVEL>
  </TNSNAME2PING>
  <TNSNAME2PING>
    <TNSNAME>osmartdb2</TNSNAME>
    <ERRORLEVEL>WARNING</ERRORLEVEL>
  </TNSNAME2PING>
</ORATNSPING>