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 <[EMAIL PROTECTED]> > 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/[EMAIL PROTECTED] 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@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@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@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
