check_oracle

[Phil Costelloe]

kumar s k wrote:
> hi,
> 
> i mentioned ORACLE_HOME and ORACLE_SID in nagios profile on remote
> server (ORACLE SERVER). But when run the command from Nagios server i
> got the error messeage.  
> 
> command: ./check_nrpe -H ORACLE SERVER -p 5666 -c check_oracle
> 
> error : cannot determine ORACLE_HOME for sid DATABASE SID

You can also specify the environment variables as part of the NRPE
command definition and I've found that to be the most reliable way of
doing it.

command[check_oralogin=ORACLE_HOME=/apps/oracle/product/8.1.7; export
ORACLE_HOME; PATH=$PATH:/apps/oracle/product/8.1.7/bin; export PATH;
TNS_ADMIN=/apps/oracle/admin/network; export TNS_ADMIN;
/opt/nagios/libexec/check_oracle --login YOUR_SID_NAME

You can obviously add and subtract environment variables to suit your
situation and get the command to run successfully.

Phil


-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_idU88&alloc_id065&op=click
_______________________________________________
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