UnixODBC Database Monitoring

[thiagomz]

Hi Guys,

I am monitoring my Oracle databases using UnixODBC ... All works here when the database is OPEN, but ...

If I shutdown a database or the status is MOUNT, unixODBC receive erros from Oracle and all Itens get Grey.

In zabbix_proxy I receive ...

[root@azmonprx ~]# isql -v ORCL  zabbix mypassword
[08004][unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

[ISQL]ERROR: Could not SQLConnect

And all my triggers get unknown status ...



So .. If my database processes ORA_PMON is running, if my LISTENER is running ... but ... after a restart of the server, because a power failure and my database start in MOUNT state ...

No one trigger alert me ..

Any Idea how to monitor if I stop to receive data from database over unixodbc or how to monitor if my trigger get UNKNOWN status ?

[Colttt]

ehm i thing a good solution for this is the trigger nodata

https://www.zabbix.com/documentation/2.2/manual/appendix/triggers/functions