Duncan, I will be logging into the linux box where nagios servier is installed (also oracle 10g client installed) and executing the following command as nagios user, [nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239">10.192.2.239</a> -p 5666 -c check_tns No TNS Listener on playdb1 nrpe.cfg file on oracle server has this, command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns playdb1 [nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239">10.192.2.239</a> -p 5666 -c check_login CRITICAL - nrpe.cfg has, command[check_login]=/usr/local/nagios/libexec/check_oracle --login playdb1 [nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239">10.192.2.239</a> -p 5666 -c check_sid playdb1 OK - 1 PMON process(es) running nrpe.cfg has, command[check_sid]=/usr/local/nagios/libexec/check_oracle --db playdb1 [nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239">10.192.2.239</a> -p 5666 -c check_cache playdb1 OK - Cache Hit Rates: % Lib -- % Buff|lib=%;90;80;0;100 buffer=%;90;80;0;100 this isn't showing the correct values or better say it won't show any value, but same command on 239 machine where oracle server is running shows, [nagios@oradb-lnx libexec]$ /usr/local/nagios/libexec/check_oracle --cache playdb1 monitor monitor 80 90 playdb1 OK - Cache Hit Rates: 97.92% Lib -- 99.35% Buff|lib=97.92%;90;80;0;100 buffer=99.35%;90;80;0;100 and same with the tablespace command [nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239">10.192.2.239</a> -p 5666 -c check_tablespace playdb1 : USERS OK - % used [ / MB available ]|USERS=%;80;90;0;100 but this works, [nagios@oradb-lnx libexec]$ /usr/local/nagios/libexec/check_oracle --tablespace playdb1 monitor monitor USERS 90 80 playdb1 : USERS OK - 10.00% used [ 4 / 5 MB available ]|USERS=10.00%;80;90;0;100 I don't know how to fix this, I've tried all possible steps given by many people and I last came here.. Please some one help me thanks <div class="gmail_quote"> On Wed, May 14, 2008 at 4:29 PM, Duncan Berriman <<a href="mailto:duncan@dcl.co.uk">duncan@dcl.co.uk</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div> <div> <div>The command should now be correct. </div> <div> </div> <div>When you run it locally are you logged in as the nagios user that NRPE uses or as say root? If not su to the account and try running it again.</div> <div> </div> <div>I would guess its either a privilege problem which you can fix with visudo to allow NRPE access to the appropriate program or as you mention an environment issue.</div> <div> </div> <div>I am guessing the account you are using for the command line test is set up for oracle and the nagios user that nrpe uses isn't.</div> <div> </div> <div>Duncan</div></div> <div align="left"> </div> <blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"> <div></div> <div dir="ltr" align="left" lang="en-us">-----Original Message----- From: <a href="mailto:asam30@gmail.com" target="_blank">asam30@gmail.com</a> [mailto:<a href="mailto:asam30@gmail.com" target="_blank">asam30@gmail.com</a>] Sent: 14 May 2008 10:03 To: Duncan Berriman Subject: {Disarmed} Re: {Disarmed} RE: {Disarmed} [Nagiosplug-help] check_oracle plug in help </div>Duncan, Thanks for the quick reply, On the oradb-lnx box where oracle db is running, I tried, [nagios@oradb-lnx libexec]$ /usr/local/nagios/libexec/check_oracle --tns oradb-lnx OK - reply time 10 msec from oradb-lnx [nagios@oradb-lnx libexec]$ /usr/local/nagios/libexec/check_oracle --tns playdb1 OK - reply time 10 msec from playdb1 [nagios@oradb-lnx libexec]$ both seems to be working. As per your suggestion, I have changed to command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns playdb1 in nrpe.cfg. But it still shows the same error. [nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank">MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be MailScanner warning: numerical links are often malicious: 10.192.2.239</a> -p 5666 -c check_tns No TNS Listener on playdb1 Do you think I should change something in the check_oracle script (like adding ORACLE_HOME path there)? Any suggestions, Thanks <div class="gmail_quote">On Wed, May 14, 2008 at 1:58 PM, Duncan Berriman <<a href="mailto:duncan@dcl.co.uk" target="_blank">duncan@dcl.co.uk</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div> <div> <div>You appear to be running different commands....</div> <div> </div> <div>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns oradb-lnx command[check_login]=/usr/local/nagios/libexec/check_oracle --login playdb1 but all commands works if I execute following from 239 machine (oradb-lnx) [nagios@oradb-lnx libexec]$ ./check_oracle --tns playdb1 OK - reply time 10 msec from playdb1 [nagios@oradb-lnx libexec]$ ./check_oracle --login playdb1 OK - dummy login connected</div> <div> </div> <div>Surely it should be....</div> <div> </div> <div>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns playdb1 </div> <div> </div> <div>not</div> <div> </div> <div>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns oradb-lnx</div></div> <div> </div> <div>Duncan</div> <div align="left"> </div> <blockquote style="border-left: 2px solid rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"> <div></div> <div dir="ltr" align="left" lang="en-us">-----Original Message----- From: <a href="mailto:nagiosplug-help-bounces@lists.sourceforge.net" target="_blank">nagiosplug-help-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagiosplug-help-bounces@lists.sourceforge.net" target="_blank">nagiosplug-help-bounces@lists.sourceforge.net</a>] On Behalf Of <a href="mailto:asam30@gmail.com" target="_blank">asam30@gmail.com</a> Sent: 14 May 2008 08:39 To: <a href="mailto:nagiosplug-help@lists.sourceforge.net" target="_blank">nagiosplug-help@lists.sourceforge.net</a> Subject: {Disarmed} [Nagiosplug-help] check_oracle plug in help </div>Hi, I am using check_oracle plug in to monitor some of the oracle database parameters. But this is reporting the following error. [nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank">MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be MailScanner warning: numerical links are often malicious: 10.192.2.239</a> -p 5666 -c check_tns No TNS Listener on playdb1 Let me explain, lnxtestsrv1 is a box where nagios server is running and this is monitoring checks(check_http, check_ftp, check_disk, check_swap etc) of other machines just fine. I now need to monitor oracle db on <a href="http://10.192.2.239" target="_blank">MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be MailScanner warning: numerical links are often malicious: 10.192.2.239</a> machine where oracle server is running and sid is playdb1. i installed oracle client on this lnxtestsrv1 machine and user nagios has access to sqlplus and tnsping commands I also add nagios to the oracle group (dba, oinstall). tnsping from nagios user works fine. telnet to 239 on port 1521 works ok when I execute this command on the machine where nagios server is running, [nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank">MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be MailScanner warning: numerical links are often malicious: 10.192.2.239</a> -p 5666 -c check_tns No TNS Listener on playdb1 and [nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank">MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be MailScanner warning: numerical links are often malicious: 10.192.2.239</a> -p 5666 -c check_login CRITICAL - in my 239 machine nrpe.cfg has following, command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns oradb-lnx command[check_login]=/usr/local/nagios/libexec/check_oracle --login playdb1 but all commands works if I execute following from 239 machine (oradb-lnx) [nagios@oradb-lnx libexec]$ ./check_oracle --tns playdb1 OK - reply time 10 msec from playdb1 [nagios@oradb-lnx libexec]$ ./check_oracle --login playdb1 OK - dummy login connected I did set the ORACLE_HOME path to where oracle client installed on lnxtestsrv1 machine. Please help me how to fix this. Thanks -Shankar -- Shankar Asam -- This message has been scanned for viruses and dangerous content by <a href="http://www.mailscanner.info/" target="_blank">MailScanner</a>, and is believed to be clean. </blockquote></div> -- This message has been scanned for viruses and dangerous content by <a href="http://www.mailscanner.info/" target="_blank">MailScanner</a>, and is believed to be clean. </blockquote></div> -- Shankar Asam -- This message has been scanned for viruses and dangerous content by <a href="http://www.mailscanner.info/" target="_blank">MailScanner</a>, and is believed to be clean. </blockquote></div> -- This message has been scanned for viruses and dangerous content by <a href="http://www.mailscanner.info/" target="_blank">MailScanner</a>, and is believed to be clean. </blockquote></div> -- Shankar Asam