how to monitor databases on windows through nagios`

[asam30 at gmail.com]

Hi All,

Thank you for your time.

I'm still confused as to how we can monitor oracle database on windows box
from Nagios Server?

.check_nt does not seem to be much help with regards to the oracle database
as there are no oracle parameters defined in check_nt plugin (./check_nt -h)

using check_nt i did the following and they are working fine,

./check_nt -H 172.16.17.142  -p 12489 -v USEDDISKSPACE -l E -w 80 -c 90
E:\ - total: 117.20 Gb - used: 107.59 Gb (92%) - free 9.61 Gb (8%) | 'E:\
Used Space'=107.59Gb;93.76;105.48;0.00;117.20


./check_nt -H 172.16.17.142  -p 12489 -v MEMUSE -w 80 -c 90
Memory usage: total:5340.21 Mb - used: 1915.78 Mb (36%) - free: 3424.44 Mb
(64%) | 'Memory usage'=1915.78Mb;4272.17;4806.19;0.00;5340.21


 ./check_nt -H 172.16.17.142  -p 12489 -v UPTIME
System Uptime - 7 day(s) 1 hour(s) 36 minute(s)

The only plug-in check_oracle will work for oracle database monitoring and
this is working cool on unix boxes not on win box.

on the win box, nsc.ini file, I did commented for this,
;NRPEClient.dll

should I uncomment this for check_oracle to work properly? (this is a
production win box)

Do you want me to install oracle client on nagios server to fix this
problem?

can someone please help on this?

Thanks
-Shankar



On Sun, Sep 21, 2008 at 1:19 AM, moshe sharon <moshesharon at gmail.com> wrote:

> Hello
>  .
> The oracle services you should monitor using the NSCilent for example using
> the NSclient interface
> ./check_nt -H 192.168.1.1 -p 1248 -v SERVICESTATE -d SHOWALL -l Oracle
> Server
>
> or what ever method you are using
>
> as for the check_oracle. I suggest to install Oracle instant client and
> configure tnsnames.ora to connect to the windows database then from the
> command line test the oracle connection sqlplus user/pass at db if all is
> working you should be able to use check_oracle not
> **
> Oracle instant client can be found here:
> *
> http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
> *
> there are few other nice plugins for oracle checks in nagiosexchange
>
> --
> Moshe Sharon
> http://www.centerity.com
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> 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
>



-- 
Shankar Asam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080925/ba9416d3/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
-------------- 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