[Nagiosplug-devel] Nagios SQLPlus query monitor?

[Litwin, Matthew]

On Jan 12, 2010, at 9:37 PM, Joerg Linge wrote:

> Am 12.01.10 22:07, schrieb Litwin, Matthew:
>> Hello,
>> 
>> Similar to the check_oracle plugin I need a nagios plugin that will SQL from say a secondary text file and then report on the lines that it results. Ideally it would return the number of lines as output where WARN and CRITICAL conditions could be checked against, but also the actual rows would be listed as perfdata. Does any plugin like this exist?
>> 
>> I wrote a plugin that will use sqlplus to return a line count and report on those values in Perl, but honestly my scripting capabilities are pretty weak. If you are a Perl guy and see an elegant way of doing this, any guidance on this would be very helpful.
> 
> check_oracle_health can do this.
> 
> http://labs.consol.de/lang/de/nagios/check_oracle_health/
> 
> nagios$ check_oracle_health --mode sql \
>  --name 'select 200,300,1000 from dual' \
>  --name2 'kaspar melchior balthasar' \
>  --warning 180 --critical 500
> 
> WARNING - kaspar melchior balthasar: 200 300 1000 |
> 'kaspar'=200;180;500 'melchior'=300;; 'balthasar'=1000;;

Thank you, I will keep looking for how I can use the SQL mode for check_oracle_health to see how I can do this. Unfortunately the developers website doesn't have an english version. :-(

Thanks,
Matthew Litwin
mlitwin at stubhub.com
415.222.8475