Oracle plugin

[Greg Cope]

Can you post this either here or add it to nagios exchange (probably
better!)

Thanks.

Greg


On Fri, 2006-05-19 at 14:28 -0400, Janet Post wrote:
> Az,
> 
> Yes!  I am very interested in this plug in!!
> 
> Thank you.
> Janet.
> 
> -----Original Message-----
> From: Az [mailto:az at whoever.org] 
> Sent: May 19, 2006 6:42 AM
> To: Janet Post
> Cc: nagios-users at lists.sourceforge.net
> Subject: Re: [Nagios-users] Oracle plugin
> 
> Hi Janet,
> 
> >I am looking for a plug-in that will run a query against an oracle
> >database and return the results.
> >
> >I have found plugins that search for specific things -- like
> tablespace,
> >and archives, but nothing that will run a sql statement.
> >
> >Surely this plugin exists somewhere?!?!
> >  
> >
> I never found anything like this either so I rolled my own stored 
> procedure type plugin for both Oracle and MSSQL. The guts of it was one 
> of the parameters you passed it was a valid command for that RDBMS (so 
> it could be a select or a stored proc, the latter is what we did). It 
> expects 1 row, 2 columns back. A result code (OK, WARN, etc), and a 
> message. I havent bothered with perf stats at this point.
> 
> Our DBAs wrote some standard stored procs they deployed as they saw fit 
> to spit out the results. Thus, I could manage Nagios and they could 
> write whatever queries on their DB they wanted without having to fiddle 
> with scripts on the Nagios server.
> 
> I've not put them on Nagios Exchange, but if you're interested in seeing
> 
> them, let me know.
> 
> Cheers.
> 
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
> _______________________________________________
> 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



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
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