Problems with check_oracle

Voon, Ton Ton.Voon at egg.com
Wed Jun 18 18:14:39 CEST 2003


I haven't come across the env -i trick before. According to the man page, -i
ignores all environment variables - do you need to set PATH as well?

If you only want the ORACLE_HOME variable, check_oracle will query the
oratab file (as long as it is in /etc/oratab or /var/opt/oracle/oratab) to
find out the Oracle home based on the SID specified. There is a patch in
version 1.4.2.1 where if you use a * in the oratab, it will pick that as the
default ORACLE_HOME.

Other tricks people have used is to set the ORACLE_HOME in the nagios
startup script.

> -----Original Message-----
> From:	Ricardo Perez [SMTP:perez at buenos-aires.oilfield.slb.com]
> Sent:	Wednesday, June 18, 2003 4:36 PM
> To:	nagios-users at lists.sourceforge.net
> Subject:	[Nagios-users] Problems with check_oracle
> 
> I am a new user of nagios and I have some problems to check my oracle
> databases with check_oracle . If I run check_oracle from a command line
> (/usr/local/nagios/libexec/check_oracle -tns oraxxx) it is works OK, but
> from the Nagios web page I get the following error (Return code of 141 is
> out of bounds)
> 
> This are the definition I add to the checkcommands.cfg and services.cfg
> 
> # 'check_oracle' command definition
> define command{
>         command_name    check_oracle
>         command_line    /usr/bin/env -i "ORACLE_HOME=/usr/local/oracle8i"
> $USER1$/check_oracle -tns $ARG1$
>         }
> 
> 
> # Service definition
> define service{
>         use                                    generic-service  
>         host_name                         Xserver
>         service_description             ORAXXX
>         is_volatile                           0
>         check_period                      24x7
>         max_check_attempts          3
>         normal_check_interval         3
>         retry_check_interval            1
>         contact_groups                   nagios-admins
>         notification_interval              120
>         notification_period               24x7
>         notification_options              w,u,c,r
>         check_command                 check_oracle!oraxxx
>         }
> 
> Any help will be appreciated.


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.



-------------------------------------------------------
This SF.Net email is sponsored by: INetU
Attention Web Developers & Consultants: Become An INetU Hosting Partner.
Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
_______________________________________________
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





More information about the Users mailing list