check_oracle NRPE

[Dermot Duffy]

On Nagios Server:
[nagios at nagios-server]$ ./check_oracle --login PCMDB
Cannot determine ORACLE_HOME for sid PCMDB

On db Server:
[nagios at db1]$ ./check_oracle --login PCMDB
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
CRITICAL –

Regards,
D.

From: Assaf Flatto [mailto:nagios at flatto.net]
Sent: 12 December 2011 14:42
To: Nagios Users List
Subject: Re: [Nagios-users] check_oracle NRPE

On your nagios server from the command line try running the command as the nagios user , and also on the remote machine as the nagios user.

This will give you some idea what is wrong.
________________________________
From: "Dermot Duffy" <dermot.duffy at brandtone.ie<mailto:dermot.duffy at brandtone.ie>>
To: nagios-users at lists.sourceforge.net<mailto:nagios-users at lists.sourceforge.net>
Sent: Monday, 12 December, 2011 2:29:40 PM
Subject: [Nagios-users] check_oracle NRPE


I have configured the following plugin on my oracle db server

Db1:/usr/local/nagios/etc/nrpe.cfg
# Oracle Checks
command[check_oracle]=/usr/local/nagios/libexec/check_oracle --login PCMDB

From the command line this works locally.
[root at db1etc]# /usr/local/nagios/libexec/check_oracle --login PCMDB
OK - dummy login connected

However I am unable to get it to work from my nagios server.
I have defined the check_oracle script at the following location in the nagios server:
Nagios_server:/usr/local/nagios/etc/objects/db1.cfg
define service{
          use                 generic-service
          host_name           mvdbs1
          service_description Check Oracle
          check_command       check_nrpe!check_oracle
          }

The NRPE connection between db server and nagios server is fine:
[root at Nagios_Server]# ./check_nrpe -H db-server
NRPE v2.12

But when I run this from the nagios server (GUI) I get the following:

[cid:image001.jpg at 01CCB8DF.24C21A20]

Regards,
D.

____________________________________________________________________________________________________________________________________________________________________________________________
[Description: Description: Description: Description: Brandtone Side Bar logo cropped]
Dermot Duffy
IT Infrastructure Technical Lead
www.brandtone.ie<http://www.brandtone.ie/> | Dermot.Duffy at brandtone.ie<mailto:Dermot.Duffy at brandtone.ie>
M: +353 85 711 7530

Disclaimer
The information contained in this message (including any attachments) is confidential and intended solely for the  attention and use of the named addressee(s).  It must not be disclosed to any person without our authority.  If you are not the intended recipient, please delete it from your system immediately - any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful.

BrandTone Limited makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the transmission, reception, storage or use of such information in any way whatsoever.  Any opinions expressed in this message are those of the author and do not necessarily reflect the opinions of BrandTone Limited.




------------------------------------------------------------------------------
Learn Windows Azure Live!  Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net<mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111212/5606ca58/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 42555 bytes
Desc: image001.jpg
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111212/5606ca58/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 4052 bytes
Desc: image002.jpg
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111212/5606ca58/attachment-0001.jpg>
-------------- next part --------------
------------------------------------------------------------------------------
Learn Windows Azure Live!  Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for 
developers. It will provide a great way to learn Windows Azure and what it 
provides. You can attend the event by watching it streamed LIVE online.  
Learn more at http://p.sf.net/sfu/ms-windowsazure
-------------- next part --------------
_______________________________________________
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