[Fwd: check_oracle : Cannot determine ORACLE _HOME for sid 'test.world']]

[jmarquart at planalytics.com]

My recommendation is NOT to hardcode this value into the script.  (that
certainly is effective though)

YMMV - but I found it easiest to just configure my checks like:
     /usr/bin/env -i "ORACLE_HOME=/path/to/oracle" check_oracle ...

This enables me to make frequent updates to both the check scripts - as well as
the ORACLE_HOME dirs - with minimal reconfigurations.

-john







"Lonny Selinger" <lonny at bangtherockstogether.net> on 04/08/2003 12:44:09 PM




To:   nagios-users at lists.sourceforge.net
cc:    (bcc: John J. der Schalla Marquart/Planalytics)

Subject:  [Fwd: [Nagios-users] check_oracle : Cannot determine ORACLE_HOME
      for sid 'test.world']]




-=-=-=-==-=-=-=-=-=-=
from my Oracle GURU
-=-=-=-=-=-=-=-=-=-=-

Lonny, I have added the ORACLE_HOME right into the script:

export ORACLE_HOME=<path to Oracle product>

Cosidering the --tns switch just does a tnsping on the database, this only
tells
you that the listener for that server is listening, not that the  database is
up.

Lowell

Hi all,

I've got a little problem. When I execute the "check_oracle --tns
test.world" on my local server, it works fine but when I execute the same  check
by
nrpe (since my nagios server), I've got this message : "cannot determine
ORACLE_HOME
for sid test.world"

I checked that my ORACLE_HOME environment variable is set, ORACLE_HOME/bin  is
my
PATH, tnsname.ora file is properly configured and my oratab file contains  my
ORACLE_SID:ORACLE_HOME:Y


Can you help me?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20030408/95197150/attachment.htm>