check_oracle plugin and $ORACLE_HOME

[Demetri Mouratis]

On Thu, 14 Jul 2005, Cam wrote:

> Hi,
>
> I'm using nagios to monitor some of my systems.  It seems like a
> pretty slick system.  Anyway, i'm trying to check if the oracle
> database is up on one of my boxes, but i really know nothing about
> oracle at all (i'm just monitoring the box, i have nothing to do w/
> anything other than that).  Anyway, i was happy to see the
> check_oracle plugin, but i'm having a little bit of difficulty.  The
> error i get when i try './check_oracle --tns aspdb' i get the error:
>
> Cannot determine ORACLE_HOME for sid aspapp2
>
> i did a search on the mailing list archives, but the only thing i
> could come up w/ some problems that people had w/ the plugin and nrpe
> (i don't want to use nrpe).  I tried setting ORACLE_HOME here on my
> nagios server, but that didn't do me any good.  Am i doing something
> wrong?  Is this not the right plugin for me?  I was thinking about how
> i could check it other than through the plugin... maybe check if the
> process is running through SNMP?  Any hints would be greatly
> appreciated.
>
> Thanks,
> Cameron Matheson

Take a look at the file called /etc/oratab or alternatively 
/var/opt/oracle/oratab.  That file defines the home environment based on 
the sid.  You can optionally add a "*" entry in the oratab for a default 
ORACLE_HOME for undefined sids.
---------------------------------------------------------------------
Demetri Mouratis
dmourati at linfactory.com


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
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