Oracle by Zabbix agent 2 monitoring - no tablespace data

[mintamanta]

Hi all,

I've just configured Oracle by Zabbix agent 2 on 2 different hosts. Both of them are Linux, one with Oracle Version 19.3.0.0.0, other one with 12.2.0.1.0 (test env).
Nearly all data is collected, but tablespace datas are empty on both nodes (for all TBS)

Following item (and some other items too): Oracle: Get tablespaces stats says: "Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist,

I have these lines is /var/log/zabbix/zabbix_agent2.log
2021/09/06 15:05:16.738253 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:05:17.740494 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:06:06.714186 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-01031: insufficient privileges.
2021/09/06 15:06:08.752613 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:06:16.831911 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:06:18.386379 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:07:06.049038 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-01031: insufficient privileges.
2021/09/06 15:07:08.313080 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.
2021/09/06 15:07:16.402662 [Oracle] Cannot fetch data: dpiStmt_execute: ORA-00942: table or view does not exist.

All privileges were given to the user mentioned here: https://www.zabbix.com/documentation.../zabbix_agent2
For testing reasons zabbix database user had sysdba privileges for a short time. The error was the same.

I tried different Oracle Instant Clients up to version 21.3. Instant Clients were unzipped to specified directories under /tmp and LD_LIBRARY_PATH was modified also in /etc/sysconfig/zabbix-agent2
Zabbix Server and Zabbix Agent 2 are on verison 5.4.4.

Could maybe someone help me pls?!

Ragards, mintamanta

[mintamanta]

Hi all,

I leave this post here, but I finally found solution for my problem. Documentation is incomplete. You should also give this privilege: grant SELECT_CATALOG_ROLE to zabbix_mon;

Regards, mintamanta

[adoang]

Hi, can you share me the step by step to monitor oracle database ?
for now I use zabora.

[mintamanta]

Hello, adoang . Is this question still open for you? Regards, Mintamanta.

[irwan13th]

Hello, adoang . Is this question still open for you? Regards, Mintamanta.

hi. if you have the time to post this here, might be helpful to others. i might need it in the near future to setup DB monitoring.