It's turned out that for Oracle version 18.104.22.168 these changes should be performed:
The PDB discovery issue can be solved by giving more permissions to the user. The monitoring user can’t see all the containers that is why the PDB discovery was empty for version 22.214.171.124.
This is the executed command:
This should be included in documentation, as now is not described as a requirement (https://www.zabbix.com/documentation/5.0/manual/config/templates_out_of_the_box/zabbix_agent2).
For the PDB tablespaces, existing query for the "Template DB Oracle by Zabbix Agent 2" is not getting this information.
We “solved” this by creating a Template to get this information by ODBC. The queries are:
PDB tablespace discovery:
PDB tablespace stats:
This should be considered to improve templates:
“Template DB Oracle by Zabbix Agent 2”
“Template DB Oracle by ODBC”