On 04/07/06, Hari Sekhon <[EMAIL PROTECTED]> 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@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/[EMAIL PROTECTED]>" 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@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
