Oracle plugin check_oracle

[Hari Sekhon]

On 04/07/06, Hari Sekhon <harisekhon at gmail.com> wrote:
>
>  Ton Voon wrote:
>
>
>
> On 4 Jul 2006, at 18:41, Morris, Patrick wrote:
>
>
>
>
> Don't know about a binary plugin doing this.
>
> The Oracle Instantclient (sqlplus) is available here:
>
>
>
>
> http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/
>
> linuxsoft.html
>
>
>
> [snip]
>
>
>
>
> The check_oracle client won't work with just the Instant Client, because
>
> it doesn't include tnsping.
>
>
> When I've used check_oracle, I use the --login option instead of --tnsping.
> This simulates a login, and returns OK if it gets a "invalid login,
> incorrect username/password". This is a better check because it goes down
> the entire stack and grabs whatever errors are returned by Oracle (for
> instance, "shutdown in progress").
>
>
> I assume the Instantclient will still work with check_oracle (as it just
> needs sqlplus).
>
>
> Ton
>
>
> http://www.altinity.com
> T: +44 (0)870 787 9243
> F: +44 (0)845 280 1725
> Skype: tonvoon
>
>
> ________________________________
>
>  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
>  yes this is probably what i'll do as well
>
>  -h
>


I took Ton Voon's advice and ran check_oracle --login which worked
after installing sqlplus. I got this to start checking earlier today
which was easier than I expected. I just ran

./check_oracle --login <dbname>

and it gave me a successfull dummy login ok feedback. This has been
working all afternoon, but now all of a sudden it's saying:

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

For one, why do I need ORACLE_HOME, two ORACLE_HOME is set in the
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.

What is going on?

-h


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