Check_oracle

[Hans Engelen]

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

On 6/21/06, Mohan, Ajit (CFSA) <Ajit.Mohan at dc.gov> 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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20060623/2988ec9b/attachment.html>
-------------- next part --------------
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
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at 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