On 11 Jul 2006, at 11:21, Hari Sekhon wrote:

It's happened again, I changed a non-related service name and then 
restarted nagios and now again it doesn't find $ORACLE_HOME for the sids 
of the databases apparently. This is ridiculous since I can

su - nagios
echo $ORACLE_HOME
/usr/lib/oracle/10.2.0.2/client

which gives me the path to the oracle client installation and I can also

sqlplus "user/[EMAIL PROTECTED]" successfully and get a login.

/usr/nagios/libexec/check_oracle --login dbname
OK - dummy login connected

Does anybody understand why this check has stopped working again when I 
haven't
done anything to it, I have to get this working in a stable fashion, I 
can't have it doing this every time I restart nagios...

How do you restart Nagios? Or do you mean reload?

If the former, check that the startup scripts correctly source the environment variables. If the latter, it could be a bug in Nagios, though I'm not sure why.

Alternatively, check_oracle will parse /var/opt/oracle/oratab (and other locations) for the ORACLE_HOME variable. Some installations of Oracle use this to know what SIDs are installed on a server. You could amend that instead.

Ton





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
[email protected]
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

Reply via email to