Ton Voon wrote:
On 18 Jul 2006, at 02:33, Yang Xiao wrote:
On 7/11/06, Ton Voon <[EMAIL PROTECTED]>
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/[EMAIL PROTECTED] " 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.
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
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
|
-------------------------------------------------------------------------
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
_______________________________________________
Nagios-users mailing list
Nagios-users@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