Zabbix Oracle template 7.4-1 – Tablespace query RC contention issue on Multitenant DB

[razimhuseynov]

Hello,
We are using the Zabbix Oracle template 7.4-1 for monitoring Oracle CDB databases.
The query used for the tablespace macro {$ORACLE.TBS.USED.PCT.FROM.MAX.HIGH} is executed simultaneously on every PDB.
The problematic part of the query is:
(SELECT TRUNC(SUM(BYTES)) AS FREE,...

[diegoalexander59]

Failure with template "Oracle by Zabbix agent 2".
Hello everyone. I have Zabbix 7.0 installed and am monitoring an Oracle database. The template is working partially, since it is collecting all the data except those related to the discovery rule called "Tablespace discovery."...

[JollyJumper]

hello,
I have problem with zabbix agfent2 and Oracle databse monitoring.
Zabbix aggent2 won't start, i get below info:
zabbix_agent2 [40290]: ERROR: Cannot assign configuration: invalid parameter ORACLE_HOME at line 510: unknown parameter

I check oracle_home location via...

[dynax60]

Hi all,

Is there a way to do discovery rule by oracle.custom.query[]? For example, I have sql script jobs_discovery.sql (for discovery dba_jobs which will be in Discovery rule):

SELECT job FROM dba_jobs

And I have another sql script job.sql, which will be in Item Prototypes...

[aburbello]

Hi,

I have been monitoring Oracle via Zabbix Agent 2, but one thing that I havent found is how to skip the monitoring of tablespaces UNDOTBS and TEMP.
I have set the value for the macro {$ORACLE.TABLESPACE.NAME.NOT_MATCHES}, but it does not work.

Any one could advise...

[osalmon]

Hi, we used "Oracle by Zabbix agent 2" template. Everything works well except oracle.pdb.discovery key!
Results from this item is empty!

Actually, i can modify {$ORACLE.SERVICE} macro to monitor my CDB or PDB instead...but i wish to monitor all of them...

Do...