Oracle plugin check_oracle

[Hari Sekhon]

Ton Voon wrote:
>
> On 18 Jul 2006, at 02:33, Yang Xiao wrote:
>
>>
>>
>> On 7/11/06, *Ton Voon* <ton.voon at altinity.com 
>> <mailto: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
>
>
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


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