<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 11 (filtered medium)"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>  <style>  </style> </head> <body lang=EN-GB link=blue vlink=purple> <div class=Section1> Your service definition should instead say:<o:p></o:p> <o:p> </o:p> check_command check_oracle_generic!test2!system!manage!18!12!select count(*) from v$session where username in not null<o:p></o:p> <o:p> </o:p> and your command definition should have <o:p></o:p> <o:p> </o:p> command_line /usr/local/nagios/libexec/check_oracle_generic -SID ‘$ARG1$’ -dbuser ‘$ARG2$’ -dbpassword ‘$ARG3$’ -w “$ARG4$” -c “$ARG5$” -q ‘$ARG6$’<o:p></o:p> <o:p> </o:p> Re-read the documentation on how to define and use check commands.<o:p></o:p> <o:p> </o:p> Steve<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> From: nagios-users-bounces@lists.sourceforge.net [mailto:nagios-users-bounces@lists.sourceforge.net] On Behalf Of Neha.Sinha@iflexsolutions.com Sent: Thursday, 10 April 2008 16:28 To: nagios-users@lists.sourceforge.net Subject: [Nagios-users] help required- oracle monitoring using nagios<o:p></o:p> </div> <o:p> </o:p> Hi,<o:p></o:p> <o:p> </o:p> I am trying to monitor an oracle server using nagios and am using a Perl script check_oracle_generic.<o:p></o:p> <o:p> </o:p> I am new to nagios and hence have a very limited knowledge of it <o:p></o:p> <o:p> </o:p> In my commands.cfg file I have defined a commnad as follows:<o:p></o:p> <o:p> </o:p> <o:p> </o:p> define command{<o:p></o:p> command_name check_oracle_generic<o:p></o:p> command_line /usr/local/nagios/libexec/check_oracle_generic -SID $ARG1$ -dbuser $ARG2$ -dbpassword $ARG3$ -w $ARG4$ -c $ARG5$ -q $ARG6$<o:p></o:p> }<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Also in the service definition its defined as <o:p></o:p> <o:p> </o:p> <o:p> </o:p> define service{<o:p></o:p> use local-service<o:p></o:p> host_name IRIMS_Linux<o:p></o:p> service_description oracle session<o:p></o:p> check_command check_oracle_generic -SID test2 -dbuser system -dbpassword manager -c 12 -w 18 -q \"select count(*) from v$session where username in not null\"<o:p></o:p> contact_groups linuxadmin<o:p></o:p> }<o:p></o:p> <o:p></o:p> <o:p> </o:p> However when I m checking my nagios configuration I am getting the following error<o:p></o:p> <o:p> </o:p> Error: Service check command 'check_oracle_generic -SID test2 -dbuser system -dbpassword manager -c 12 -w 18 -q \"select count(*) from v$session where username in not null\"' specified in service 'oracle session' for host 'IRIMS_Linux' not defined anywhere!<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Also the file in the location /usr/local/nagios/libexec is an executable file.<o:p></o:p> <o:p> </o:p> Also is there any alternate method to monitor an oracle server using nagios.<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> Warm Regards,<o:p></o:p> Neha Sinha<o:p></o:p> <st1:PersonName w:st="on">i-RIMS</st1:PersonName> | i-flex Remote Infrastructure Management Services | i-flex TDMS<o:p></o:p> Tel: +91 80 6659 6000 | Extn: 6441 | Mobile: +91 9986760182<o:p></o:p> Fax: +91 80 6666 4005 <o:p></o:p> Website: <a href="http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=p3s4" title="blocked::http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=p3s4 http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=p3s4">http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=p3s4</a><o:p></o:p> <img border=0 width=385 height=94 id="_x0000_i1025" src="cid:image001.gif@01C89B33.E3505830"><o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> Warm Regards,<o:p></o:p> <o:p> </o:p> Neha Sinha<o:p></o:p> <o:p> </o:p> <st1:PersonName w:st="on">i-RIMS</st1:PersonName> | i-flex Remote Infrastructure Management Services | i-flex TDMS<o:p></o:p> <o:p> </o:p> Tel: +91 80 6659 6000 | Extn: 6441 | Mobile: +91 9986760182<o:p></o:p> <o:p> </o:p> Fax: +91 80 6666 4005 <o:p></o:p> <o:p> </o:p> Website: http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=p3s4<o:p></o:p> <o:p> </o:p> DISCLAIMER: This message contains privileged and confidential information and is intended only for an individual named. If you are not the intended recipient, you should not disseminate, distribute, store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version.<o:p></o:p> </div> </div> </body> </html>