[Nagiosplug-help] check_oracle - No TNS Listener

[Araripe Moreira]

Hi

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 127.0.0.1  -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

and

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

when I run another command:

nagios at srvh410k:/opt/nagios/libexec> ./check_nrpe -H 127.0.0.1  -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
PATH=/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/oracle/product/10.2/bin

and

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

Thanks
Araripe