<div dir="ltr">hi, you need to export the following on your db server check_oracle file, vi /usr/local/nagios/libexec/check_oracle export ORACLE_HOME=<set the oracle home path here> export ORACLE_SID=<oracle sid> export PATH=$ORACLE_HOME/bin:$PATH then save and exit. try running again, if this helps -Shankar <div class="gmail_quote">On Mon, Oct 6, 2008 at 2:24 PM, <<a href="mailto:Sascha.Runschke@gfkl.com">Sascha.Runschke@gfkl.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <tt>"Araripe Moreira" <<a href="mailto:subover@gmail.com" target="_blank">subover@gmail.com</a>> schrieb am 02.10.2008 19:44:02:<div class="Ih2E3d"> > 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@srvh410k:/opt/nagios/libexec> ./check_nrpe -H <a href="http://127.0.0.1" target="_blank">127.0.0.1</a> -c check_jcma > No TNS Listener on JCMA > > when I execute this command on the machine where nagios plug in is running > > nagios@srvh410k:/opt/nagios/libexec> ./check_oracle --tns JCMA --db > prod --login oracle > OK - reply time 890 msec from JCMA </div></tt> <tt>What does 'set | grep ORA' give? Do you have the ORACLE_HOME set as nagios</tt> <tt>user? If not - does /etc/oratab contain the path to the orahome of the JCMA?</tt> <tt>One of those needs to be true at least, I only use the oratab entry for</tt> <tt>example.</tt> <tt>Does your tnsnames.ora contain a valid connector for JCMA?</tt> <tt>Since it works from the commandline - it seems so, but you'll never know...</tt> S -- Sascha Runschke IT-Infrastruktur fon : +49 (201) / 102-1879 fax : +49 (201) / 102-1102105 mobil : +49 (173) / 5419665 GFKL Financial Services AG Vorstand: Dr. Peter Jänsch (Vors.), Jürgen Baltes, Dr. Till Ergenzinger, Dr. Tom Haverkamp Vorsitzender des Aufsichtsrats: Dr. Georg F. Thoma Sitz: Limbecker Platz 1, 45127 Essen, Amtsgericht Essen, HRB 13522 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world <a href="http://moblin-contest.org/redirect.php?banner_id=100&url=/" target="_blank">http://moblin-contest.org/redirect.php?banner_id=100&url=/</a> _______________________________________________ Nagiosplug-help mailing list <a href="mailto:Nagiosplug-help@lists.sourceforge.net">Nagiosplug-help@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</a> ::: Please include plugins version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </blockquote></div> -- Shankar Asam </div>