check_oracle NRPE

[Mike Clark]

The Oracle permissions have kicked my butt on Linux and Solaris for some time now.  I usually do the following:

http://bit.ly/rNKv96 (This is a mini “Let me Google that for you”).

to try and find answers.  It usually works even if I do have to read through several of the search results to see what might apply to me.

From: Dermot Duffy [mailto:dermot.duffy at brandtone.ie]
Sent: Monday, December 12, 2011 10:13 AM
To: Nagios Users List
Subject: Re: [Nagios-users] check_oracle NRPE

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

The NRPE configuration is correct and working for all other alerts so unless specifically relating to oracle checks reading the manual is pointless.

My issue is specifically with the oracle check. Since you have mentioned “RTFM” can you suggest any specific documents on this?


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


________________________________
From: "Dermot Duffy" <dermot.duffy at brandtone.ie<mailto:dermot.duffy at brandtone.ie>>
To: "Nagios Users List" <nagios-users at lists.sourceforge.net<mailto: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]<mailto:[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 01CCB8B7.9EF739B0]

Regards,
D.

____________________________________________________________________________________________________________________________________________________________________________________________
[cid:image002.jpg at 01CCB8B7.9EF739B0]
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


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