Monitoring Oracle Servers

[Martin, Stanley G [GMG]]

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