check_oracle NRPE

[Assaf Flatto]

----- Original Message -----

From: "Dermot Duffy" <dermot.duffy at brandtone.ie> 
To: "Nagios Users List" <nagios-users at lists.sourceforge.net> 
Sent: Monday, 12 December, 2011 3:30:05 PM 
Subject: Re: [Nagios-users] check_oracle NRPE 



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


unless you have the Oracle server on this host - this test is useless , read the NRPE documents on how to do the testing properly !!! 




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 – 



This might indicate that you have issues with an object - if the test is working as root , look at sudo to get this to work, 


Again - RTFM for NRPE and then you'll have a better understanding of the task you wish to complete. 



Regards, 
D. 





Assaf 



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. 
----- Original Message -----


From: "Dermot Duffy" < dermot.duffy at brandtone.ie > 
To: 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: 



Regards, 
D. 

	
____________________________________________________________________________________________________________________________________________________________________________________________ 
Description: Description: Description: Description: Brandtone Side Bar logo cropped
Dermot Duffy 
IT Infrastructure Technical Lead 
www.brandtone.ie | 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 
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 

------------------------------------------------------------------------------ 
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 
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/d11cf7c7/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/d11cf7c7/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/d11cf7c7/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