Oracle plugin check_oracle

[Hari Sekhon]

On 10/07/06, Jason Martin <jhmartin at toger.us> wrote:
> On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote:
> > "Cannot determine ORACLE_HOME for sid <dbname>" with status UNKNOWN
> > This happened to me before but since it was working earlier I don't
> > see how this could have broken...
> Soemthing must have changed...
>
>
> > For one, why do I need ORACLE_HOME,
> sql/plus requires this since it uses it to find the tnsnames.ora
> file as well as the location of the error messages translation
> file.
>
> > nagios user environment when I "su - nagios", and three sqlplus is in
> > the nagios user's path and I can do "sqlplus <user/password at dbname>"
> > and successfully get a login prompt on the database server.
> How does it get in the nagios users's path? Could Nagios have
> been restarted in such a way that the profile or whatever didn't
> get sourced?
>
> -Jason Martin
> --
> This message is PGP/MIME signed.
>
>
>

I would expect that to be it as well but it's strange to see this. I
rebooted nagios and it started working properly again.

It started happening just after making a completely unrelated change
to a mysql check and rebooting nagios.

This sounds suspicious but at that same time as soon as it started
giving me warning UNKNOWN for the status of the oracle machines, I
immediately tried

sqlplus "username/password at dbname"

from the nagios user and it worked normally and logged me in... and

echo $ORACLE_HOME

gave me the path to the oracle client installation...

so why did the check stop working?


-------------------------------------------------------------------------
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 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