zabbix agent2 and oracle

[hoanghien]

When using agent 2 with oracle template , there are errors:

1171:20201021:091315.881 discovery rule "Zabbix server: oracle.archive.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
1173:20201021:091316.888 discovery rule "Zabbix server: oracle.db.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
1171:20201021:091317.897 discovery rule "Zabbix server: oracle.diskgroups.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
1173:20201021:091318.905 discovery rule "Zabbix server: oracle.pdb.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.
1171:20201021:091319.912 discovery rule "Zabbix serverracle.ts.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORA CLE. PASSWORD}","{$ORACLE.SERVICE}"]" became not supported: Cannot fetch data: dpiStmt_execute: ORA-00907: missing right parenthesis.

Any idea what is the problem? Thank you

[Aviad]

hi,
have the same issue
if you manage to fix this be happy if you can share the steps.

[hoanghien]

Hi,
I am not familiar with Oracle, but the problem is very clear

ORA-00907: missing right parenthesis

. This should be missing a parenthesis somehwere in querry.

[[email protected]]

The errors are misleading. This exception happens on syntax like

SELECT
JSON_OBJECTAGG(v.METRIC VALUE v.VALUE)
FROM...

which is used heavily in the zabbix agent 2 oracle plugin. Oracle DB before 12.2 doesn't support function JSON_OBJECTAGG. So it doesn't understand what we want from it. Actually the plugin's author warned about compatibility. As far as I can see there is no way to install JSON_OBJECTAGG in Oracle below 12.2