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
On 6/21/06, Mohan, Ajit (CFSA) <[EMAIL PROTECTED]> wrote:
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
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
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
