how to monitor databases on windows through nagios`

[Michael Medin]

check_nt has very limited functionality (mainly see if the service is
"sort of running"), I would suggest using something more flexible.
Such as for instance NRPE or similar which allows you to run "scripts" on
the remote (windows) host. With most "modern" windows agents (NSClient++,
NC_NET, NRPE_NT, OpMonAgent(?)) you can use scripts and thus either use
one of the various check_oracle scripts or get your DBA to write up a
quick database check script in his or hers favorite language.

// Michael Medin


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



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