This check pings an oracle listener via 'tnsping tns-name' whether to see if alive or not
ORATNSPING is the enclosing tag for all tnsnames2ping tags
0 or 1. If you don't define ORATNSPING, no oratnsping check will run.
<ORATNSPING>
<TNSNAME2PING>
<TNSNAME>osmartdb1</TNSNAME>
<ERRORLEVEL>ERROR</ERRORLEVEL>
</TNSNAME2PING>
<TNSNAME2PING>
<TNSNAME>osmartdb2</TNSNAME>
<ERRORLEVEL>WARNING</ERRORLEVEL>
</TNSNAME2PING>
</ORATNSPING>
If no ORACLE_HOME shell variable is set, you have to define the ORACLE_HOME tag to find the tnsping utility
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
0 or 1.
<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>
for every tns-name you want to oratnsping you have to define the TNSNAME2PING-pair
The common XML tags as described in Section 9.8, “Tags Common to All Checks and/or Checkpoints”
As many as you like.
Look at ORATNSPING
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.
tns-name (string) / can be found in tnsnames.ora
1. Have to be set to know what I should ping
<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>