Oracle plugin check_oracle

[Hari Sekhon]

Hari Sekhon wrote:
> On 10/07/06, Jason Martin <jhmartin at toger.us> wrote:
>> On Mon, Jul 10, 2006 at 05:57:08PM +0100, Hari Sekhon wrote:
>> > "Cannot determine ORACLE_HOME for sid <dbname>" with status UNKNOWN
>> > This happened to me before but since it was working earlier I don't
>> > see how this could have broken...
>> Soemthing must have changed...
>>
>>
>> > For one, why do I need ORACLE_HOME,
>> sql/plus requires this since it uses it to find the tnsnames.ora
>> file as well as the location of the error messages translation
>> file.
>>
>> > nagios user environment when I "su - nagios", and three sqlplus is in
>> > the nagios user's path and I can do "sqlplus <user/password at dbname>"
>> > and successfully get a login prompt on the database server.
>> How does it get in the nagios users's path? Could Nagios have
>> been restarted in such a way that the profile or whatever didn't
>> get sourced?
>>
>> -Jason Martin
>> -- 
>> This message is PGP/MIME signed.
>>
>>
>>
>
> I would expect that to be it as well but it's strange to see this. I
> rebooted nagios and it started working properly again.
>
> It started happening just after making a completely unrelated change
> to a mysql check and rebooting nagios.
>
> This sounds suspicious but at that same time as soon as it started
> giving me warning UNKNOWN for the status of the oracle machines, I
> immediately tried
>
> sqlplus "username/password at dbname"
>
> from the nagios user and it worked normally and logged me in... and
>
> echo $ORACLE_HOME
>
> gave me the path to the oracle client installation...
>
> so why did the check stop working?
>
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...

-h




-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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