[Nagiosplug-help] check_oracle - No TNS Listener

Araripe Moreira subover at gmail.com
Thu Oct 2 19:44:02 CEST 2008


I hope one of you will be able to help!

I am using check_oracle plug in to monitor some of the oracle database
service in my network. But this is reporting the following error:

nagios at srvh410k:/opt/nagios/libexec> ./check_nrpe -H  -c check_jcma
No TNS Listener on JCMA

when I execute this command on the machine where nagios plug in  is running

nagios at srvh410k:/opt/nagios/libexec> ./check_oracle --tns JCMA --db
prod --login oracle
OK - reply time 890 msec from JCMA

The commands works if I execute following from srvh410k as shown above

In srvh410k machine nrpe.cfg has following

command[check_jcma]=/opt/nagios/libexec/check_oracle --tns JCMA --db
prod --login oracle


command[check_c0d0p1]=/opt/nagios/libexec/check_disk -w 20% -c 10% -p

when I run another command:

nagios at srvh410k:/opt/nagios/libexec> ./check_nrpe -H  -c check_c0d0p1
DISK OK - free space: / 14103 MB (73% inode=98%);| /=5030MB;

I did set the ORACLE_HOME path to where oracle client installed on
srvh410k machine:

nagios at srvh410k:/opt/nagios/libexec> set | grep $PATH


The nagios user has all permissions to execute sqlplus and tsnping commands.

nagios at srvh410k:/opt/nagios/libexec> id nagios
uid=1002(nagios) gid=100(users) grupos=100(users), 104(dba),
16(dialout), 103(oinstall), 33(video)

nagios at srvh410k:/oracle/product/10.2/bin> ls -la | more

-rwxr-x--x  1 oracle oinstall      9467 2008-06-25 20:25 sqlplus
-rwxr-x--x  1 oracle oinstall     15879 2008-06-25 20:24 tnsping

Please help me how to fix this


More information about the Help mailing list