<br><font size face"sans-serif">Lonny, I have added the ORACLE_HOME right into the script:</font>
<br>
<br><font size face"sans-serif">export ORACLE_HOME<path to Oracle product></font>
<br>
<br><font size face"sans-serif">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. </font>
<br>
<br><font size face"sans-serif">Lowell</font>
<br>
<br>
<br>
<br>
<br>
<table width0%>
<tr valigntop>
<td>
<td><font size face"sans-serif"><b>"Lonny Selinger" <lonny@bangtherockstogether.net></b></font>
<p><font size face"sans-serif">2003-04-08 10:34 AM</font>
<br>
<td><font size face"Arial"> </font>
<br><font size face"sans-serif"> To: lfafard@saskpower.com</font>
<br><font size face"sans-serif"> cc: </font>
<br><font size face"sans-serif"> Subject: [Fwd: [Nagios-users] check_oracle : Cannot determine ORACLE_HOME for sid 'test.world']</font></table>
<br>
<br>
<br><font size face"Courier New">--------------------------------- Original Message ---------------------------------<br>
Subject: [Nagios-users] check_oracle : Cannot determine ORACLE_HOME for sid<br>
'test.world' From: "Pascal RENAUT/GROUPE-ES"<br>
<pascal.renaut@electricite-strasbourg.fr> Date: Tue, April 8, 2003 7:47 am<br>
To: nagios-users@lists.sourceforge.net<br>
------------------------------------------------------------------------------------<br>
<br>
Hi all,<br>
<br>
I've got a little problem. When I execute the "check_oracle --tns<br>
test.world" on my local server, it works fine but when I execute the same check by<br>
nrpe (since my nagios server), I've got this message : "cannot determine ORACLE_HOME<br>
for sid test.world"<br>
<br>
I checked that my ORACLE_HOME environment variable is set, ORACLE_HOME/bin is my<br>
PATH, tnsname.ora file is properly configured and my oratab file contains my<br>
ORACLE_SID:ORACLE_HOME:Y<br>
<br>
<br>
Can you help me?<br>
....................................................................................................<br>
Pascal RENAUT / Département Ingénierie Réseaux (I.R.) / Groupe Electricité de<br>
Strasbourg / 67953 Strasbourg Cedex 9<br>
Tél : 33 (0) 369 20 6138 / Fax : 33 (0) 369 20 6045 / Email :<br>
pascal.renaut@electricite-strasbourg.fr<br>
<br>
<br>
<br>
-------------------------------------------------------<br>
This SF.net email is sponsored by: ValueWeb:<br>
Dedicated Hosting for just $79/mo with 500 GB of bandwidth!<br>
No other company gives more support or power for your dedicated server<br>
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/<br>
_______________________________________________<br>
Nagios-users mailing list<br>
Nagios-users@lists.sourceforge.net<br>
https://lists.sourceforge.net/lists/listinfo/nagios-users<br>
::: Please include Nagios version, plugin version (-v) and OS when reporting any<br>
issue. ::: Messages without supporting info will risk being sent to /dev/null<br>
<br>
<br>
</font>
<br>
<br>