check_oracle tip

[Jason Martens]

I use check_by_ssh for my oracle monitoring, and I wrote a short script
to actually run the check_oracle plugin.

#!/bin/sh
export ORACLE_SID=$1
. /etc/OracleEnvironment
/usr/lib/nagios/plugins/check_oracle --login $1


That way the environment gets set and the proper oracle_home is set.

Jason

On Wed, 2003-07-30 at 02:43, Voon, Ton wrote:
> check_oracle tries to get the oracle home from the oratab (/etc/oratab or
> /var/opt/oracle/oratab), based on the SID specified. You can also add a *
> entry into the oratab and it will then use the ORACLE_HOME specified there.
> 
> Some people amend the check_oracle script to include the oracle environment
> stuff. I wouldn't recommend that because an upgrade of check_oracle will
> overwrite this and it seems that Oracle want you to use . oratab to source
> your site specific stuff anyway.
> 
> Ton
> 
> > -----Original Message-----
> > From: Lonny Selinger [mailto:lonny at bangtherockstogether.net] 
> > Sent: Tuesday, July 29, 2003 10:02 PM
> > To: Lonny Selinger
> > Cc: Rivanor P. Soares; nagios-users at lists.sourceforge.net
> > Subject: Re: [Nagios-users] check_oracle tip
> > 
> > 
> > Another thing to note, when an app runs as a user it doesn't inherit
> > its path and environment (no shell, no inheritance). You may also have
> > to include the export somewhere else (like in the script prior to
> > running it)
> > 
> > --
> > Lonny
> > 
> > > One thing you might try is verify that nagios actually is doing the
> > > export properly. Just su to nagios and echo $ORACLE_HOME and $PATH.
> > > Also make sure that tnsping is executable by nagios ... just try a
> > > manual tnsping from the command line as nagios.
> > >
> > > Let me know if any of this helps,
> > >
> > > --
> > > Lonny
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> > Data Reports, E-commerce, Portals, and Forums are available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet
> > _072303_01/01
> > _______________________________________________
> > 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
> > 
> 
> 
> 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 sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> 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


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
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