Infrastructure Monitoring

Hi All,
I have been trying to find a documentation for implementing a check of an Oracle query on Nagios environment.

The requirement is very simple.

This is the Oracle query

select count(*) from IM_BC_JOB;

If count_number >= 10 then RED alert
if count_number < 10 then GREEN alert

Any help or suggestion to customize Nagios step by step will be well appreciated.

Thanks in advance for your kind support.

Regards,

Giovanni

hi

if u need execute a query in oracle u can do it this way

Code:

echo "SELECT COUNT(*) FROM TABLE;"  | sqlplus -s user/pass@IP:port/SID

with that code u can create your own oracle monitoring scritps

Regards,