<br><div><span class="gmail_quote">On 7/18/06, <b class="gmail_sendername">Hari Sekhon</b> <<a href="mailto:harisekhon@gmail.com">harisekhon@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div bgcolor="#ffffff" text="#000000"></div><div><span class="e" id="q_10c80ec5168a47e9_1">
Ton Voon wrote:
<blockquote cite="http://mid081A773F-CED5-440D-8A68-AFC113DE929F@altinity.com" type="cite"><br>
<div>
<div>On 18 Jul 2006, at 02:33, Yang Xiao wrote:</div>
<br>
<blockquote type="cite"><br>
<br>
<div>On 7/11/06, <b class="gmail_sendername">Ton Voon</b> <<a href="mailto:ton.voon@altinity.com" title="mailto:ton.voon@altinity.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ton.voon@altinity.com
</a>>
wrote:
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><br>
<div>
<div>On 11 Jul 2006, at 11:21, Hari Sekhon wrote:</div>
<br>
<blockquote type="cite">
<div style="margin: 0px;">It's happened again, I
changed a non-related service name and then </div>
<div style="margin: 0px;">restarted nagios and now
again it doesn't find $ORACLE_HOME for the sids </div>
<div style="margin: 0px;">of the databases
apparently. This is ridiculous since I can </div>
<div style="margin: 0px; min-height: 14px;"><br>
</div>
<div style="margin: 0px;">su - nagios</div>
<div style="margin: 0px;">echo $ORACLE_HOME</div>
<div style="margin: 0px;">/usr/lib/oracle/10.2.0.2/client</div>
<div style="margin: 0px; min-height: 14px;"> <br>
</div>
<div style="margin: 0px;">which gives me the path to
the oracle client installation and I can also</div>
<div style="margin: 0px; min-height: 14px;"><br>
</div>
<div style="margin: 0px;">sqlplus
"user/password@dbname " successfully and get a login.</div>
<div style="margin: 0px; min-height: 14px;"><br>
</div>
<div style="margin: 0px;">/usr/nagios/libexec/check_oracle
--login dbname</div>
<div style="margin: 0px;">OK - dummy login connected
</div>
<div style="margin: 0px; min-height: 14px;"><br>
</div>
<div style="margin: 0px;">Does anybody understand
why this check has stopped working again when I </div>
<div style="margin: 0px;">haven't</div>
<div style="margin: 0px;"> done anything to it, I
have to get this working in a stable fashion, I </div>
<div style="margin: 0px;">can't have it doing this
every time I restart nagios...</div>
</blockquote>
</div>
<br>
</div>
<div>
<div> How do you restart Nagios? Or do you mean reload?</div>
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>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. </div>
</div>
<div>
<div><br>
</div>
<div>Ton</div>
<div><br>
</div>
<br>
<br>
</div>
</div>
</blockquote>
</div>
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! <br>
chmod 755 /app/oracle -R<br>
btw, I'm doing this via nrpe...so it has nothing to do with
ORACLE_HOME, oracle client, ...none of that.<br>
<br>
</blockquote>
Thanks Yang. I've forwarded this to nagios-users and to Hari.</div>
<div><br>
</div>
<div>Ton</div>
<div><span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<span style="border-collapse: separate; border-spacing: 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">
<div><br>
</div>
<div><a href="http://www.altinity.com" title="http://www.altinity.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.altinity.com</a></div>
<div>T: +44 (0)870 787 9243</div>
<div>F: +44 (0)845 280 1725</div>
<div>Skype: tonvoon</div>
</span></span></span></span></span><br>
</span> </div>
<br>
</blockquote></span></div><div>
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...<br>
<br>
-h<br>
<br>
<br>
</div>
</div><br>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.
</blockquote><div><br><br>- Yang <br></div><br></div><br>