Oracle by ODBC template shows wrong tablespace utilization etc.

[intense]

Good morning

I have an Oracle database version 19.21 and zabbix proxy version 6.4.0.
I have set up database monitoring using the Oracle by ODBC template.
It incorrectly shows tablespace utilization (tablespace utilization etc.).
I've read that it may be related to the setting: "2. Make sure, that ODBC connects to Oracle with session parameter NLS_NUMERIC_CHARACTERS= '.,'"

How can I check if I have it set correctly and possibly where to change it and save it?

Please help.

[rousseau eric]

J'ai eu le problème avec mon serveur qui avec les locales en francais.

Ma solution a été de faire une config pour oracle.

/etc/systemd/system/zabbix-server.service.d/oracle.conf


Placer ces paramètres

[Service]
Environment="LC_NUMERIC=C"
Environment="LC_ALL=C"
Environment="LANG=C"
Environment="NLS_NUMERIC_CHARACTERS=.,"
Environment="NLS_LANG=AMERICAN_AMERICA.AL32UTF8"


Pour tester

sudo -u zabbix env NLS_LANG=AMERICAN_AMERICA.AL32UTF8 NLS_NUMERIC_CHARACTERS=., isql -v DSN_oracle login mot_de_passe

Saisir la commande

select round(92.59,2) from dual;