Hi, actually if you look inside the check_oracle script you will see that it is trying to determiing the oracle home based on whats in /etc/oratab or /opt/var/etcoratab (not sure about the last one, have to work from memory here). Failure to get a valid oracle_home from that it falls back to a default and hardcoded (in the check_oracle shell script) setting. I just cannot remember if it uses the oratab method even with an ORACLE_HOME already being defined. Also you might want to check permissions on the tnsping binary and for that matter most of the other stuff installed by the oracle client setup. Possibly the nagios user (the one running the nagios process) does not have the right to execute the tnsping binary which, again if memory serves, leads to the, in this case misleading, no tns listener output. Much of all this depends on which client version you have installed. Everytime I install a new one I spend a lot of time figuring out silly little quirks and changes. Cheers, Hans <div>On 6/21/06, Mohan, Ajit (CFSA) <<a href="mailto:Ajit.Mohan@dc.gov">Ajit.Mohan@dc.gov</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 link="blue" vlink="purple" lang="EN-US"> <div> Hi, I am trying to monitor the oracle database using the "check_oracle" plugin. I have installed Oracle client on the machine and configured the TNSNAMES.ORA file to point to the oracle server. However when I try to test the connection using "check_oracle" I get the below error message. I have verified the ORA_HOME and the TNSNAMES use the IP address of the Oracle server "No TNS Listener on XXX" The database is up and running Any ideas? Thank you </div> </div> </div> All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642" target="_blank">http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 </a> _______________________________________________ Nagios-users mailing list <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net </a> <a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </blockquote></div>