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