help required- oracle monitoring using nagios

Steve Shipway s.shipway at auckland.ac.nz
Thu Apr 10 07:54:14 CEST 2008


Your service definition should instead say:

 

check_command
check_oracle_generic!test2!system!manage!18!12!select count(*) from
v$session where username in not null

 

and your command definition should have 

 

command_line    /usr/local/nagios/libexec/check_oracle_generic -SID
'$ARG1$' -dbuser '$ARG2$' -dbpassword '$ARG3$' -w "$ARG4$" -c "$ARG5$"
-q '$ARG6$'

 

Re-read the documentation on how to define and use check commands.

 

Steve

 

 

________________________________

From: nagios-users-bounces at lists.sourceforge.net
[mailto:nagios-users-bounces at lists.sourceforge.net] On Behalf Of
Neha.Sinha at iflexsolutions.com
Sent: Thursday, 10 April 2008 16:28
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] help required- oracle monitoring using nagios

 

Hi,

 

I am trying to monitor an oracle server using nagios and am using a Perl
script check_oracle_generic.

 

I am new to nagios and hence have a very limited knowledge of it 

 

In my commands.cfg file I have defined a commnad as follows:

 

 

define command{

        command_name    check_oracle_generic

        command_line    /usr/local/nagios/libexec/check_oracle_generic
-SID $ARG1$ -dbuser $ARG2$ -dbpassword $ARG3$ -w $ARG4$ -c $ARG5$ -q
$ARG6$

        }

 

 

Also in the service definition its defined as 

 

 

define service{

        use                             local-service

        host_name                   IRIMS_Linux

        service_description        oracle session

        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\"

        contact_groups             linuxadmin

        }

 

 

However when I m checking my nagios configuration I am getting the
following error

 

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!

 

 

Also the file in the location   /usr/local/nagios/libexec  is an
executable file.

 

Also is there any alternate method to monitor an oracle server using
nagios.

 

 

 

Warm Regards,

Neha Sinha

i-RIMS | i-flex Remote Infrastructure Management Services | i-flex TDMS

Tel: +91 80 6659 6000 | Extn:  6441 | Mobile: +91 9986760182

Fax: +91 80 6666 4005 

Website: 
http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=
p3s4
<http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu
=p3s4> 

 

 

 

 

 

Warm Regards,

 

Neha Sinha

 

i-RIMS | i-flex Remote Infrastructure Management Services | i-flex TDMS

 

Tel: +91 80 6659 6000 | Extn:  6441 | Mobile: +91 9986760182

 

Fax: +91 80 6666 4005 

 

Website:
http://www.iflexsolutions.com/iflex/solutions/itinfrastructure.aspx?mnu=
p3s4

 

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080410/cd943f1d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 73 bytes
Desc: image001.gif
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080410/cd943f1d/attachment.gif>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
-------------- 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


More information about the Users mailing list