Oracle DB Query check
Carroll, Jim P [Contractor]
jcarro10 at sprintspectrum.com
Mon Feb 10 21:21:42 CET 2003
Perhaps something which could be added to the contrib directory...?
jc
> -----Original Message-----
> From: Russell Scibetti [mailto:russell at quadrix.com]
> Sent: Monday, February 10, 2003 1:11 PM
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] Oracle DB Query check
>
>
> I have created a "plugin" to check connecting and querying an
> Oracle DB.
> However, instead of needing the Oracle client installed on your
> monitoring machine, I use java (JDK1.3.1 and up) and a
> Jar/Zip file of
> the Oracle JDBC libraries (classes12.zip for those that know
> it). It is
> a small java class that connects, runs a query and exits, and you can
> wrap it with any number of different shell scripts for
> running different
> queries and processing the results.
>
> The class takes a connection string, user, password, and
> query to run.
> It returns OK if the query executes and returns any
> resultset, which is
> printed to the OUTPUT string. It returns a Critical if a
> SQLException
> occurs or the resultset of the query is empty. The
> SQLException message
> is printed as the OUTPUT if one occurs.
>
> Is anyone interested in this code? If so, I will email it out to the
> list. I was just trying to avoid installing the Oracle
> client where I
> didn't need it, and take advantage of an already existing
> Java installation.
>
> Russell Scibetti
>
> --
> Russell Scibetti
> Quadrix Solutions, Inc.
> http://www.quadrix.com
> (732) 235-2335, ext. 7038
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
>
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
More information about the Users
mailing list