Oracle ODBC template is discovering the db but the items are empty

[mbuyukkarakas]

Dear all

Somehow I successfully installed the necessary components to monitor an Oracle DB with ODBC.
After importing template and setting the macros, zabbix has discovered the databases from my Oracle server as expected.
But when I check inside, the items are empty.

My findings are ;

- zabbix cant read floating numbers
- the only data which zabbix was able to read is numeric (unsigned) : Picture Oracle 3

I tried to put NLS_NUMERIC_CHARACTERS in variables but it didnt worked.

# cat /etc/sysconfig/zabbix-server

export ORACLE_HOME=/usr/lib/oracle/19.8/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:/usr/lib:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/lib/network/admin
export NLS_NUMERIC_CHARACTERS= '.,'


I dont have big experience about Oracle DB. So could you please help me to fix this ?

Thank you.

[mbuyukkarakas]

any idea about this ?

[MBrunner]

Just a hunch...
Get the selects from the Template und run them on the Database with the user you use for monitoring. Maybe the user don't have all privileges needed.

[mbuyukkarakas]

Thanks for your response. I will try and inform you.

[mbuyukkarakas]

I'm sorry but we checked multiple times and confirmed that the queries or privileges are not the essential problem. They are as expected.
Any other ideas ?

How about the Oracle variables ?