Oracle db.odbc.selec item works/not works randomly after update to zabbix 7

[Palyk]

After upgrading from 6.4 to 7.0.4 - oracle oitem sometimes works, sometimes not, isql command connect, but item sometimes give this error:-
Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][-1][[unixODBC][Oracle][ODBC][Ora]ORA--0001: Message -1 not found; product=RDBMS; facility=ORA
postgres odbc items works normaly..
Idont know if its some update -configuration issiu, or it is new version problem
Thank you

[notorious]

Dear All

It has been proven that oracle client version higher than 12.2 must be installed to be able to monitor. In my case, I installed oracle client version 21.16 and can use it normally.


# ===== Version 21.16.0.0.0 (Requires glibc 2.14) =====

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

[Palyk]

Yes this solve my problem - version 21.16, I used 12.2 - it was not working with zabbix 7.0. Thank you very much

[Palyk]

My configuraton - docker postgres image - alpine linux.

[notorious]

I encountered the same problem in docker-compose stack.

ENV.
Ubuntu 24.04
ZBX 7.0.4

ORACLE Client .zip
-basic
-odbc
-sqlplus

** Hoping for an answer from an expert.

[notorious]

Dear All

It has been proven that oracle client version higher than 12.2 must be installed to be able to monitor. In my case, I installed oracle client version 21.16 and can use it normally.


# ===== Version 21.16.0.0.0 (Requires glibc 2.14) =====

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

[Palyk]

Yes this solve my problem - version 21.16, I used 12.2 - it was not working with zabbix 7.0. Thank you very much