Oracle plugin

[Janet Post]

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