check_oracle plugin and $ORACLE_HOME

[Petrucci, Joseph]

First What version of Oracle are you runnning? I wrote my own plugins since I really could not find any I liked. I use a few methods to check if Oracle is up. First I have a plugin that uses ssh to logon (RSA no password) and simply look for the pmon process is running. Then I have one that logs onto the Oracle instance and does a select from the v$instance view to read the name of the instance to make sure it matches. I also use check_http and have a page on my web-server that connects to the instance and pulls the instance name from it. There are many other things you can do such as listener status, and pulling performance information. They are not ready to be published but I can send you the plugins I have, maybe between the two of us we can get them up to speed and publish them. 

>-----Original Message-----
>From: nagios-users-admin at lists.sourceforge.net
>[mailto:nagios-users-admin at lists.sourceforge.net]On Behalf Of Cam
>Sent: Thursday, July 14, 2005 4:10 PM
>To: nagios-users at lists.sourceforge.net
>Subject: [Nagios-users] check_oracle plugin and $ORACLE_HOME
>
>
>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
>
>
>-------------------------------------------------------
>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_idt77&alloc_id492&op=ick
>_______________________________________________
>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
>
>



-------------------------------------------------------
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_idt77&alloc_id492&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