Monitoring Oracle Servers

[jmarquart at planalytics.com]

Umm there is a reasonably fantastic check_oracle script that is included in the
nagios-plugins distribution (see sourceforge)


It has the ability to perform tnspings / fake logins / and a variety of other
options.

The CVS version is likely to have additional features - such as teblspace checks
/ cache checks / etc


-j





"Martin, Stanley G [GMG]" <Stanley.G.Martin at mail.sprint.com> on 08/06/2003
09:50:57 AM




To:   "David Lowe" <dblowe at comcast.net>, nagios-users at lists.sourceforge.net
cc:    (bcc: John J. der Schalla Marquart/Planalytics)

Subject:  RE: [Nagios-users] Monitoring Oracle Servers




We monitor quite a few Oracle instances with Nagios.  I wrote a Perl
script that attempts to log into the instance using an ID that only
requires the Session privilege.  Oracle is pretty good about telling you
why it couldn't log in, so I capture the ORA error that is returned
if/when the attempt fails.  I store all the login information in a MySQL
table for each instance and just retrieve it based on the instance name
I pass to the Perl script.  You'd need some Perl & MySQL experience to
make it work for you.  I didn't really write it to pass around (meaning
it's not well documented), but you're welcome to it if needed.

Stanley G. Martin
System Administrator
Sprint - EIS3 Customer Care
Stanley.G.Martin at mail.sprint.com



-----Original Message-----
From: David Lowe [mailto:dblowe at comcast.net]
Sent: Tuesday, August 05, 2003 9:12 PM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] Monitoring Oracle Servers

I have a need to use Nagios to monitor some Oracle servers. I know
exactly zip about servers or oracle. Can someone give me some leads on
information that will allow me check tnspings on Oracle servers?

Thanks,



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01
/01
_______________________________________________
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 sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
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 sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
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