Oracle plugin check_oracle

[Ton Voon]

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

>
>
> On 7/11/06, Ton Voon <ton.voon at altinity.com> 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/password at dbname " 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20060718/fda457c9/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
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
-------------- next part --------------
_______________________________________________
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