[Nagios-devel] plugin to check oracle query result

[Anders Karlsson]

Hello!

Can't you just make a small shell script ie

snip
#!/bin/sh
oracle=<command to launch oracle query>
query="SELECT proc() FROM dual;"

val=$(`echo $query | $oracle`)

if [ $val -eq 0 ]; then
 return 0;
else
 return 1;
fi
exit;
snip


Rgrds
Anders Karlsson

fredagen den 20 september 2002 22.27 skrev Richard Wu:
> Hi,
>
> Want to have a plugin to check oracle query result, i.e. "select proc()
> from dual" and then OK if return 0 ,Warning if return 1, etc. Does anyone
> already have such a plugin  ?
>
> Thanks,
> Richard Wu
> Email:richard.wu at fusepoint.com
> Web : www.fusepoint.com
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-devel

-- 
Arrowhead AB
anders.karlsson at arrowhead.se
Have you hugged your firewall today? No spam, thanks.
--------------------------------------------------------
Are you the police? . . . . No ma'am, we're sysadmins



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf