yes, I have installed oracle client for user oracle only. but the nagios user has all permissions to execute sqlplus and tsnping commands.<br><br><br>thanks<br><br><br><div class="gmail_quote">On Wed, May 14, 2008 at 5:48 PM, <<a href="mailto:asam30@gmail.com">asam30@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Duncan,<br><br>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,<br>
<br>[nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239" target="_blank">10.192.2.239</a> -p 5666 -c check_tns<div class="Ih2E3d"><br>
No TNS Listener on playdb1<br><br></div>nrpe.cfg file on oracle server has this,<div class="Ih2E3d"><br><br>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns playdb1<br><br><br></div>[nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239" target="_blank">10.192.2.239</a> -p 5666 -c check_login<br>
CRITICAL -<br><br>nrpe.cfg has,<div class="Ih2E3d"><br><br>command[check_login]=/usr/local/nagios/libexec/check_oracle --login playdb1<br><br></div>[nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239" target="_blank">10.192.2.239</a> -p 5666 -c check_sid<br>
playdb1 OK - 1 PMON process(es) running<br><br>nrpe.cfg has,<br><br>command[check_sid]=/usr/local/nagios/libexec/check_oracle --db playdb1<br><br>[nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239" target="_blank">10.192.2.239</a> -p 5666 -c check_cache<br>
playdb1 OK - Cache Hit Rates: % Lib -- % Buff|lib=%;90;80;0;100 buffer=%;90;80;0;100<br><br>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,<br>
<br>[nagios@<span>oradb-lnx</span> libexec]$ /usr/local/nagios/libexec/check_oracle --cache playdb1 monitor monitor 80 90<br>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<br>
<br>and same with the tablespace command<br><br>[nagios@lnxtestsrv1 libexec]$ /home/nagios/nagios/libexec/check_nrpe -H <a href="http://10.192.2.239" target="_blank">10.192.2.239</a> -p 5666 -c check_tablespace<br>playdb1 : USERS OK - % used [ / MB available ]|USERS=%;80;90;0;100<br>
<br>but this works,<br><br>[nagios@<span>oradb-lnx</span> libexec]$ /usr/local/nagios/libexec/check_oracle --tablespace playdb1 monitor monitor USERS 90 80<br>playdb1 : USERS OK - 10.00% used [ 4 / 5 MB available ]|USERS=10.00%;80;90;0;100<br>
<br>I don't know how to fix this, I've tried all possible steps given by many people and I last came here..<br><br>Please some one help me <br><br><br>thanks<div><div></div><div class="Wj3C7c"><br><br><br><br><br>
<br><br><br><div class="gmail_quote">
On Wed, May 14, 2008 at 4:29 PM, Duncan Berriman <<a href="mailto:duncan@dcl.co.uk" target="_blank">duncan@dcl.co.uk</a>> wrote:<br><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><span><font face="Arial" size="2"><font color="#0000ff">The command should now be correct<span>.
</span></font></font></span></div>
<div><span><font face="Arial" size="2"><font color="#0000ff"><span></span></font></font></span> </div>
<div><span><font><span></span><font color="#0000ff">When you run it locally are
you logged in as the nagios user that NRPE uses<span>
or as say root</span>? If not su to the account and try running it
again.</font></font></span></div>
<div><span><font color="#0000ff"></font></span> </div>
<div><span><font color="#0000ff">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 envir<span>o</span>nment issue.</font></span></div>
<div><span><font color="#0000ff"></font></span> </div>
<div><span><font color="#0000ff">I am guessing the
account you are using for the command line test is set up for oracle and the
nagios user <span>that nrpe uses
</span>isn't.</font></span></div>
<div><span><font color="#0000ff"></font></span> </div>
<div><span><font color="#0000ff">Duncan</font></span></div></div>
<div align="left"><font face="Arial" size="2"></font> </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"><font face="Tahoma" size="2">-----Original Message-----<br><b>From:</b> <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>] <br><b>Sent:</b> 14 May 2008 10:03<br><b>To:</b>
Duncan Berriman<br><b>Subject:</b> {Disarmed} Re: {Disarmed} RE: {Disarmed}
[Nagiosplug-help] check_oracle plug in help<br><br></font></div><span><font color="#0000ff" face="Arial" size="2">Duncan,<br><br>Thanks for the quick
reply,<br><br>On </font></span><span>the <b>oradb-lnx</b> box where oracle db
is running, I tried,<br><br>[nagios@</span><span>oradb-lnx</span><span>
libexec]$ /usr/local/nagios/libexec/check_oracle --tns
</span><span>oradb-lnx</span><br><span>OK - reply time 10 msec from
</span><span>oradb-lnx</span><br><span>[nagios@</span><span>oradb-lnx</span><span>
libexec]$ /usr/local/nagios/libexec/check_oracle --tns playdb1<br>OK - reply
time 10 msec from playdb1<br>[nagios@</span><span>oradb-lnx</span><span>
libexec]$<br><br>both seems to be working. As per your suggestion, I have
changed to <br><br>command[check_tns]=/usr/local/nagios/libexec/check_oracle
--tns playdb1<br><br>in nrpe.cfg.<br><br>But it still shows the same
error.<br><br>[nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank"><font color="red"><b>MailScanner has detected a possible fraud attempt from "10.192.2.239" claiming to be</b></font> <font color="red"><b>MailScanner warning: numerical
links are often malicious:</b></font> 10.192.2.239</a> -p 5666 -c
check_tns<br>No TNS Listener on playdb1<br><br>Do you think I should change
something in the check_oracle script (like adding ORACLE_HOME path
there)?<br><br>Any suggestions,<br><br>Thanks<br><br><br></span><span><font color="#0000ff" face="Arial" size="2"><br></font></span><br>
<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:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span>
<div><span><font color="#0000ff" face="Arial" size="2">You appear to be running
different commands....</font></span></div>
<div><font color="#0000ff" face="Arial" size="2"></font> </div>
<div>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns
oradb-lnx<br>command[check_login]=/usr/local/nagios/libexec/check_oracle
--login playdb1<br><br>but all commands works if I execute following from
239 machine (oradb-lnx)<br><br>[nagios@oradb-lnx libexec]$ ./check_oracle
--tns playdb1<br>OK - reply time 10 msec from playdb1<br>[nagios@oradb-lnx
libexec]$ ./check_oracle --login playdb1<br>OK - dummy login connected</div>
<div> </div>
<div><span><font color="#0000ff" face="Arial" size="2">Surely it should
be....</font></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns
playdb1<br></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span><font color="#0000ff" face="Arial" size="2">not</font></span></div>
<div><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div><span>command[check_tns]=/usr/local/nagios/libexec/check_oracle --tns
oradb-lnx</span></div></span></div>
<div> </div>
<div><span><font color="#0000ff" face="Arial" size="2">Duncan</font></span></div>
<div align="left"><font face="Arial" size="2"></font> </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"><font face="Tahoma" size="2">-----Original
Message-----<br><b>From:</b> <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>] <b>On
Behalf Of </b><a href="mailto:asam30@gmail.com" target="_blank">asam30@gmail.com</a><br><b>Sent:</b> 14 May 2008
08:39<br><b>To:</b> <a href="mailto:nagiosplug-help@lists.sourceforge.net" target="_blank">nagiosplug-help@lists.sourceforge.net</a><br><b>Subject:</b>
{Disarmed} [Nagiosplug-help] check_oracle plug in
help<br><br></font></div>Hi,<br><br>I am using check_oracle plug in to
monitor some of the oracle database parameters. But this is reporting the
following error.<br><br>[nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank"><font color="red"><b>MailScanner
has detected a possible fraud attempt from "10.192.2.239" claiming to
be</b></font> <font color="red"><b>MailScanner warning: numerical links are
often malicious:</b></font> 10.192.2.239</a> -p 5666 -c check_tns<br>No
TNS Listener on playdb1<br><br>Let me explain,<br><br>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"><font color="red"><b>MailScanner has detected a possible fraud
attempt from "10.192.2.239" claiming to be</b></font> <font color="red"><b>MailScanner warning: numerical links are often
malicious:</b></font> 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<br><br>when I execute this
command on the machine where nagios server is
running,<br><br>[nagios@lnxtestsrv1 libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank"><font color="red"><b>MailScanner
has detected a possible fraud attempt from "10.192.2.239" claiming to
be</b></font> <font color="red"><b>MailScanner warning: numerical links are
often malicious:</b></font> 10.192.2.239</a> -p 5666 -c check_tns<br>No
TNS Listener on playdb1<br><br><br>and<br><br>[nagios@lnxtestsrv1
libexec]$ ./check_nrpe -H <a href="http://10.192.2.239" target="_blank"><font color="red"><b>MailScanner has detected a possible fraud
attempt from "10.192.2.239" claiming to be</b></font> <font color="red"><b>MailScanner warning: numerical links are often
malicious:</b></font> 10.192.2.239</a> -p 5666 -c check_login<br>CRITICAL
-<br><br>in my 239 machine nrpe.cfg has
following,<br><br>command[check_tns]=/usr/local/nagios/libexec/check_oracle
--tns
oradb-lnx<br>command[check_login]=/usr/local/nagios/libexec/check_oracle
--login playdb1<br><br>but all commands works if I execute following from
239 machine (oradb-lnx)<br><br>[nagios@oradb-lnx libexec]$ ./check_oracle
--tns playdb1<br>OK - reply time 10 msec from playdb1<br>[nagios@oradb-lnx
libexec]$ ./check_oracle --login playdb1<br>OK - dummy login
connected<br><br><br>I did set the ORACLE_HOME path to where oracle client
installed on lnxtestsrv1 machine. Please help me how to fix
this.<br><br>Thanks<br>-Shankar<br><br><br><br clear="all"><br>--
<br>Shankar Asam <br>-- <br>This message has been scanned for viruses and
<br>dangerous content by <a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>, and is <br>believed to be clean.
</blockquote></div><br><font color="#888888">-- <br>This message has been
scanned for viruses and <br>dangerous content by <a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>,
and is <br>believed to be clean. </font></blockquote></div><br><br clear="all"><br>-- <br>Shankar Asam <br>-- <br>This message has been scanned for
viruses and <br>dangerous content by <a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>, and is
<br>believed to be clean. </blockquote></div><br><font color="#888888">--
<br>This message has been scanned for viruses and
<br>dangerous content by
<a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>, and is
<br>believed to be clean.
</font></blockquote></div><br><br clear="all"><br></div></div><font color="#888888">-- <br>Shankar Asam
</font></blockquote></div><br><br clear="all"><br>-- <br>Shankar Asam