Oracle plugin
Az
az at whoever.org
Fri May 19 12:41:46 CEST 2006
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&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
More information about the Users
mailing list