<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: #000000'><br><br><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Dermot Duffy" <dermot.duffy@brandtone.ie><br><b>To: </b>"Nagios Users List" <nagios-users@lists.sourceforge.net><br><b>Sent: </b>Monday, 12 December, 2011 3:30:05 PM<br><b>Subject: </b>Re: [Nagios-users] check_oracle NRPE<br><br>
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">On Nagios Server:</span></p><p class="MsoNormal"><span style="color: rgb(31, 73, 125);">[nagios@nagios-server]$ ./check_oracle --login PCMDB</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Cannot determine ORACLE_HOME for sid PCMDB</span></p><p class="MsoNormal"><br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal">unless you have the Oracle server on this host - this test is useless , read the NRPE documents on how to do the testing properly !!!<br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><br></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">On db Server:</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">[nagios@db1]$ ./check_oracle --login PCMDB</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">CRITICAL –</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal">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,</p><p class="MsoNormal"><br></p><p class="MsoNormal">Again - RTFM for NRPE and then you'll have a better understanding of the task you wish to complete.<br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><br></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Regards,</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">D.</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p><p class="MsoNormal"><br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal"><br><span style="color: rgb(31, 73, 125);"></span></p><p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Assaf<br></span></p>
<div>
<div style="border-right: medium none; border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US"> Assaf
Flatto [mailto:nagios@flatto.net] <br>
<b>Sent:</b> 12 December 2011 14:42<br>
<b>To:</b> Nagios Users List<br>
<b>Subject:</b> Re: [Nagios-users] check_oracle NRPE</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><span style="font-family: "Arial","sans-serif"; color: black;">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.<br>
<br>
This will give you some idea what is wrong.</span></p>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-family: "Arial","sans-serif"; color: black;">
<hr id="zwchr" size="2" width="100%" align="center">
</span></div>
<div>
<p class="MsoNormal"><b><span style="font-family: "Helvetica","sans-serif"; color: black;">From:
</span></b><span style="font-family: "Helvetica","sans-serif"; color: black;">"Dermot Duffy" <<a href="mailto:dermot.duffy@brandtone.ie" target="_blank">dermot.duffy@brandtone.ie</a>><br>
<b>To: </b><a href="mailto:nagios-users@lists.sourceforge.net" target="_blank">nagios-users@lists.sourceforge.net</a><br>
<b>Sent: </b>Monday, 12 December, 2011 2:29:40 PM<br>
<b>Subject: </b>[Nagios-users] check_oracle NRPE<br>
<br>
<br>
</span><span style="font-size: 12pt; font-family: "Helvetica","sans-serif"; color: black;"></span></p>
<p class="MsoNormal"><span style="color: black;">I have configured the following plugin on my oracle db server</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">Db1:/usr/local/nagios/etc/nrpe.cfg</span></p>
<p class="MsoNormal"><span style="color: black;"># Oracle Checks</span></p>
<p class="MsoNormal"><span style="color: black;">command[check_oracle]=/usr/local/nagios/libexec/check_oracle --login PCMDB</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">From the command line this works locally.</span></p>
<p class="MsoNormal"><span style="color: black;">[root@db1etc]# /usr/local/nagios/libexec/check_oracle --login PCMDB</span></p>
<p class="MsoNormal"><span style="color: black;">OK - dummy login connected</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">However I am unable to get it to work from my nagios server.</span></p>
<p class="MsoNormal"><span style="color: black;">I have defined the check_oracle script at the following location in the nagios server:</span></p>
<p class="MsoNormal"><span style="color: black;">Nagios_server:/usr/local/nagios/etc/objects/db1.cfg</span></p>
<p class="MsoNormal"><span style="color: black;">define service{</span></p>
<p class="MsoNormal"><span style="color: black;"> use generic-service</span></p>
<p class="MsoNormal"><span style="color: black;"> host_name mvdbs1</span></p>
<p class="MsoNormal"><span style="color: black;"> service_description Check Oracle</span></p>
<p class="MsoNormal"><span style="color: black;"> check_command check_nrpe!check_oracle</span></p>
<p class="MsoNormal"><span style="color: black;"> }</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">The NRPE connection between db server and nagios server is fine:</span></p>
<p class="MsoNormal"><span style="color: black;">[root@Nagios_Server]# ./check_nrpe -H db-server</span></p>
<p class="MsoNormal"><span style="color: black;">NRPE v2.12</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">But when I run this from the nagios server (GUI) I get the following:</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;"><img src="cid:image001.jpg@01CCB8DF.24C21A20" id="Picture_x0020_2" width="602" height="413" border="0"></span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">Regards,</span></p>
<p class="MsoNormal"><span style="color: black;">D.</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<table class="MsoNormalTable" align="left" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style="line-height: 10.5pt;">
<b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(192, 0, 0);">____________________________________________________________________________________________________________________________________________________________________________________________</span></b></p>
<p class="MsoNormal" style="">
<span style="color: rgb(31, 73, 125);"><img src="cid:image002.jpg@01CCB8DF.24C21A20" id="Picture_x0020_1" alt="Description: Description: Description: Description: Brandtone Side Bar logo cropped" width="318" height="61" border="0"></span></p>
<p class="MsoNormal" style="line-height: 10.5pt;">
<b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: black;">Dermot Duffy</span></b></p>
<p class="MsoNormal" style="line-height: 10.5pt;">
<b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: black;">IT Infrastructure Technical Lead</span></b></p>
<p class="MsoNormal" style="line-height: 10.5pt;">
<b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(192, 0, 0);"><a href="http://www.brandtone.ie/" target="_blank"><span style="color: rgb(192, 0, 0);">www.brandtone.ie</span></a> |
<a href="mailto:Dermot.Duffy@brandtone.ie" target="_blank">Dermot.Duffy@brandtone.ie</a></span></b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(41, 40, 39);"><br>
M: +353 85 711 7530</span></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="MsoNormal" style="margin-bottom: 4.5pt; line-height: 10.5pt;">
<b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(38, 38, 38);">Disclaimer</span></b><span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(38, 38, 38);">
</span></p>
<p class="MsoNormal" style="margin-bottom: 4.5pt; line-height: 10.5pt;">
<span style="font-size: 9pt; font-family: "Helvetica","sans-serif"; color: rgb(38, 38, 38);">The information contained in this message (including any attachments) is
<b>confidential</b> 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.
<br>
<br>
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.
</span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Helvetica","sans-serif"; color: black;"><br>
------------------------------------------------------------------------------<br>
Learn Windows Azure Live! Tuesday, Dec 13, 2011<br>
Microsoft is holding a special Learn Windows Azure training event for <br>
developers. It will provide a great way to learn Windows Azure and what it <br>
provides. You can attend the event by watching it streamed LIVE online. <br>
Learn more at <a href="http://p.sf.net/sfu/ms-windowsazure" target="_blank">http://p.sf.net/sfu/ms-windowsazure</a><br>
_______________________________________________<br>
Nagios-users mailing list<br>
<a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
<br>
::: Messages without supporting info will risk being sent to /dev/null</span></p>
</div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Arial","sans-serif"; color: black;"> </span></p>
</div>
</div>
<br>------------------------------------------------------------------------------<br>Learn Windows Azure Live! Tuesday, Dec 13, 2011<br>Microsoft is holding a special Learn Windows Azure training event for <br>developers. It will provide a great way to learn Windows Azure and what it <br>provides. You can attend the event by watching it streamed LIVE online. <br>Learn more at http://p.sf.net/sfu/ms-windowsazure<br>_______________________________________________<br>Nagios-users mailing list<br>Nagios-users@lists.sourceforge.net<br>https://lists.sourceforge.net/lists/listinfo/nagios-users<br>::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. <br>::: Messages without supporting info will risk being sent to /dev/null</div><br></div></body></html>