Re: [Nagios-users] Oracle plugin check_oracle

[Yang Xiao]

On 7/18/06, Hari Sekhon <[EMAIL PROTECTED]> wrote:

Ton Voon wrote:

On 18 Jul 2006, at 02:33, Yang Xiao wrote:

On 7/11/06, Ton Voon <[EMAIL PROTECTED] > wrote:

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

Just figured out the same problem by looking at another thread on this, the answer is permission, make sure the oracle install tree has the world execute bit on!
chmod 755 /app/oracle -R
btw, I'm doing this via nrpe...so it has nothing to do with ORACLE_HOME, oracle client, ...none of that.

Thanks Yang. I've forwarded this to nagios-users and to Hari.

Ton

http://www.altinity.com

T: +44 (0)870 787 9243

F: +44 (0)845 280 1725

Skype: tonvoon

My problem with this wasn't the x bit, since I could su - nagios and run the plug-in fine, and I had the $ORACLE_HOME var set. So I figured it must be the var problem that the script is falling down on and after adding the $ORACLE_HOME variable to the beginning of the script, I have had no further problems...

-h

Does it have the read bit on? my original oracle installation (app/oracle) had 751 permission, which is really weird, I just changed everything to 755 and that did it. Once again, I'm using NRPE to run the check_oracle script on the host machine, nonetheless, I don't think ORACLE_HOME and all that matters because the script is designed to read all that env variables from the oratab file, so just in case, check the oratab file and make sure it has world read bit on as well.

- Yang

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
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