After Upgrade from 5.2.7 to 5.4 Oracle Monitoring via ODBC no more working

[baramann]

Hi@all,

i upgraded from 5.2.7 to 5.4 and now the Oracle monitoring via ODBC is no more working :-(

Error: 193179:20210517:164908.080 discovery rule "Oracle XXX Prod:db.odbc.discovery[tbsname,"{$ORACLE.DSN}"]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[08004][12154][[unixODBC][Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

Configuration:

Host Macro: {$ORACLE.DSN} = XXX.TEST

odbc.ini:
[XXX.TEST]
ServerName = XXX.TEST
Driver = Oracle 21 ODBC driver
DSN = XXX.TEST

tnsnames.ora:
XXX.TEST =
(DESCRIPTION =
(ADDRESS_LIST =
...
))



Thanks for Ideas!
bjoern

[baramann]

So, I found the reason - the update (Ubuntu 20.04) had overwritten the zabbix-server.service and so the environment variables which were configured in this file like tnsadmin, was lost.