Monitoring oracle with zabbix agent2

[Mugugnu]

Hello community!
I am trying to figure out why zabbix agent 2 (6.4) cannot retrieve metrics for any permanent tablespace except temp (which is temporary).
I am getting this error "Cannot fetch data: Next: ORA-01013: user requested cancel of current operation." and already tried to raise agent timeout to its 30 sec max with no success.
is there a way to know what queries are actually being performed by Oracle by Zabbix agent 2 templates ? I would like to manually execute them with user zabbix_mon and see wether they work or not. In alternative how can i debug this problem ?

Any support appreciated !!

Thanks and regards!

[claudio.gajardo]

Mismo Problema por acá después de actualizar a zabbix 7, tuve que pasar de Oracle by ODBC a este template y tengo exactamente el mismo problema... la base de datos que estoy monitoreando es versión 18.14

[claudio.gajardo]

ok, tengo la solución:

En el servidor que se esta monitoreando se debe cambiar un parámetro del agente.

En el directorio: /etc/zabbix/zabbix_agent2.d/plugins.d

se debe editar el archivo oracle.conf:

y al inicio, en la seccion de CallTimeout se debe configurar Plugins.Oracle.CallTimeout=30

### Option: Plugins.Oracle.CallTimeout
# The maximum time in seconds for waiting when a request has to be done.
#
# Mandatory: no
# Range: 1-30
# Default:
# Plugins.Oracle.CallTimeout=<Global timeout>

Plugins.Oracle.CallTimeout=30

luego se debe reiniciar el agente:

systemctl stop zabbix-agent2.service; systemctl start zabbix-agent2.service; tail -f /var/log/zabbix/zabbix_agent2.log