[Nagiosplug-help] usage: check_oracle

[Voon, Ton]

Walbert,

To use --login, the nagios user needs access to the Oracle client.
check_oracle then reads the oratab file to work out the ORACLE_HOME. If it
works on the command line, but not from Nagios, then the environment
variables are probably set for ORACLE_HOME.

If you change line 126 of check_oracle from:
if [ "$SID" = "$2" ] ; then
to
if [ "$SID" = "$2" -o "$SID" = "*" ] ; then
and then update your oratab file to contain a line like:
*:/opt/app/oracle/product/7.3.4:N
then running from Nagios should be okay.

Thanks for reporting the problem - will update CVS later tonight.

Ton

> -----Original Message-----
> From:	Walbert Oberngruber [SMTP:walbert.oberngruber at liwest.at]
> Sent:	Friday, March 14, 2003 9:01 PM
> To:	nagiosplug-help at lists.sourceforge.net
> Subject:	[Nagiosplug-help] usage: check_oracle
> 
> Hallo!
> 
> Using Nagios on SuSE Linux 8.1
> Plugin: check_oracle failed
> 
> Service configuration:
> define service{
>         use                             generic-service
>         host_name                       twyn2
>         service_description             Oracle SID - POWERWL
>         is_volatile                     0
>         check_period                    24x7
>         max_check_attempts              3
>         normal_check_interval           5
>         retry_check_interval            2
>         contact_groups                  pw-admins
>         notification_interval           240
>         notification_period             24x7
>         notification_options            w,u,c,r
>         check_command                   check_oracle_sid!POWERWL at twyn2
>         }
> 
> checkcommand configuration:
> define command{
>         command_name    check_oracle_sid
>         command_line    $USER1$/check_oracle --login $ARG1$
>         }
> 
> Oracle 8.1.7 is running on Sun Solaris 8 and on SuSE Linux 7.3.
> 
> Service output:
> Oracle SID - POWERWL    UNKNOWN   03-14-2003   21:54:53   1d 6h 25m 39s
> 3/3
> Cannot determine ORACLE_HOME for sid POWERWL at twyn2
> 
> Any idea what's the reason?
> 
> Thx in advance
> 
> Walbert
> 


This private and confidential e-mail has been sent to you by Egg.
The Egg group of companies includes Egg Banking plc
(registered no. 2999842), Egg Financial Products Ltd (registered
no. 3319027) and Egg Investments Ltd (registered no. 3403963) which
carries out investment business on behalf of Egg and is regulated
by the Financial Services Authority.  
Registered in England and Wales. Registered offices: 1 Waterhouse Square,
138-142 Holborn, London EC1N 2NA.
If you are not the intended recipient of this e-mail and have
received it in error, please notify the sender by replying with
'received in error' as the subject and then delete it from your
mailbox.