Oracle plugin check_oracle

[Yang Xiao]

On 7/18/06, Hari Sekhon <harisekhon at gmail.com> wrote:
>
>  Ton Voon wrote:
>
>
>  On 18 Jul 2006, at 02:33, Yang Xiao wrote:
>
>
>
> On 7/11/06, Ton Voon <ton.voon at altinity.com> wrote:
> >
> >
> >  On 11 Jul 2006, at 11:21, Hari Sekhon wrote:
> >
> >  It's happened again, I changed a non-related service name and then
> > restarted nagios and now again it doesn't find $ORACLE_HOME for the
> > sids
> > of the databases apparently. This is ridiculous since I can
> >
> >  su - nagios
> > echo $ORACLE_HOME
> > /usr/lib/oracle/10.2.0.2/client
> >
> >  which gives me the path to the oracle client installation and I can
> > also
> >
> >  sqlplus "user/password at dbname " successfully and get a login.
> >
> >  /usr/nagios/libexec/check_oracle --login dbname
> > OK - dummy login connected
> >
> >  Does anybody understand why this check has stopped working again when
> > I
> > haven't
> >  done anything to it, I have to get this working in a stable fashion, I
> > can't have it doing this every time I restart nagios...
> >
> >
> >   How do you restart Nagios? Or do you mean reload?
> >
> >  If the former, check that the startup scripts correctly source the
> > environment variables. If the latter, it could be a bug in Nagios, though
> > I'm not sure why.
> >
> >  Alternatively, check_oracle will parse /var/opt/oracle/oratab (and
> > other locations) for the ORACLE_HOME variable. Some installations of Oracle
> > use this to know what SIDs are installed on a server. You could amend that
> > instead.
> >
> >  Ton
> >
> >
> >
> >   Just figured out the same problem by looking at another thread on
> this, the answer is permission, make sure the oracle install tree has the
> world execute bit on!
> chmod 755 /app/oracle -R
> btw, I'm doing this via nrpe...so it has nothing to do with ORACLE_HOME,
> oracle client, ...none of that.
>
>  Thanks Yang. I've forwarded this to nagios-users and to Hari.
>
>  Ton
>
>  http://www.altinity.com
> T: +44 (0)870 787 9243
> F: +44 (0)845 280 1725
> Skype: tonvoon
>
>
>  My problem with this wasn't the x bit, since I could su - nagios and run
> the plug-in fine, and I had the $ORACLE_HOME var set. So I figured it must
> be the var problem that the script is falling down on and after adding the
> $ORACLE_HOME variable to the beginning of the script, I have had no further
> problems...
>
> -h
>
>
>
> Does it have the read bit on? my original oracle installation (app/oracle)
> had 751 permission, which is really weird, I just changed everything to 755
> and that did it. Once again, I'm using NRPE to run the check_oracle script
> on the host machine, nonetheless, I don't think ORACLE_HOME and all that
> matters because the script is designed to read all that env variables from
> the oratab file, so just in case, check the oratab file and make sure it has
> world read bit on as well.



- Yang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20060718/3afb4109/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
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