Zabbix external check with Oracle (doesn't) fail?

[DiedX]

Hi there,

We try to implement Zabbix for general monitoring. One of the most important points in monitoring is the monitoring of Oracle.

Zaraba is an nice implementation for monitoring of Oracle with Zabbix. We did an try:

zabbix_agentd:
UserParameter=oracle.checkactive,/zabora/zabora checkactive | tail -n2 | head -n1
UserParameter=oracle.deadlocks,/zabora/zabora deadlocks | tail -n2 | head -n1
UserParameter=oracle.dsksortratio,/zabora/zabora dsksortratio | tail -n2 | head -n1
UserParameter=oracle.hparsratio,/zabora/zabora hparsratio| tail -n2 | head -n1
UserParameter=oracle.indexffs,/zabora/zabora indexffs| tail -n2 | head -n1
UserParameter=oracle.checkactive,/zabora/zabora checkactive| tail -n2 | head -n1
UserParameter=oracle.rcachehit,/zabora/zabora rcachehit| tail -n2 | head -n1
UserParameter=oracle.redowrites,/zabora/zabora redowrites| tail -n2 | head -n1
UserParameter=oracle.dbfilesize,/zabora/zabora dbfilesize| tail -n2 | head -n1
UserParameter=oracle.dbsize,/zabora/zabora dbsize| tail -n2 | head -n1
UserParameter=oracle.tblrowsscans,/zabora/zabora tblrowsscans| tail -n2 | head -n1
UserParameter=oracle.tblscans,/zabora/zabora tblscans| tail -n2 | head -n1
UserParameter=oracle.uptime,/zabora/zabora uptime| tail -n2 | head -n1
UserParameter=oracle.commits,/zabora/zabora commits| tail -n2 | head -n1
UserParameter=oracle.rollbacks,/zabora/zabora rollbacks| tail -n2 | head -n1
UserParameter=oracle.usercount,/zabora/zabora usercount| tail -n2 | head -n1

===

Uptime does work (although it fails sometimes...)

Next part:

[root@supermario1 zabbix]# /zabora/zabora dbsize| tail -n2 | head -n1
25851068416
[root@supermario1 zabbix]#

==

The check does work. If we check zabbix_agentd:

[root@supermario1 zabbix]# !1038
/usr/local/bin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t oracle.dbsize
oracle.dbsize [t|25851068416]
[root@supermario1 zabbix]#

k. Seems to be working. If I use the zabbix_frontend, the frontend barfs:

030974:20070309:164821 Parameter [oracle.dbfile] is not supported by agent on host [Supermario1] Old status [0]
030974:20070309:165258 Parameter [oracle.checkactive] is not supported by agent on host [Supermario1] Old status [0]

No errors in the logfile of the agent though.

[root@supermario1 zabbix]# zabbix_agentd -v
ZABBIX Agent (daemon) v1.1.6 (06 February 2007)
Compilation time: Mar 2 2007 10:31:48
[root@supermario1 zabbix]#

===

Any idea's?

[DiedX]

Not too subtle kick?

[DiedX]

Would this issue be fixed by upgrading to Zabbix 1.3?

[Alexei]

Wait! Upgrading to 1.3.x is not a good way of fixing things. There must be something else. By the way, you may replace all your user parameters with a single line:

UserParameter=oracle[*],/zabora/zabora $1 | tail -n2 | head -n1

[DiedX]

UserParameter=oracle[*],/zabora/zabora $1 | tail -n2 | head -n1

Alexei,

Thanks for answering. At first, we changed our previous setup to this oneliner. We deleted the previous items, and inserted some.

Then the issue came up causing the problem: Zabora had problems loading shared library's! I guess something strange happened with the logging.

In any way: things are running smooth again. Thanks!

[tronite]

Alexei,

Thanks for answering. At first, we changed our previous setup to this oneliner. We deleted the previous items, and inserted some.

Then the issue came up causing the problem: Zabora had problems loading shared library's! I guess something strange happened with the logging.

In any way: things are running smooth again. Thanks!

Sorry to go off-topic but seeing as you are a new senior member as well and all I am just wondering if at all you are as thrilled as I am?