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