On 10/07/06, Jason Martin <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]>" > > 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/[EMAIL PROTECTED]" 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@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
