zabbix_agebt2 Oracle Monitor

[Anton S]

Hi all,
I'm trying to set up oracle monitoring with zabbix_agent2 based on https://www.zabbix.com/ru/integratio...#oracle_agent2. All data from database comes fine, but I get errors on items and triggers related to tablespace usage:

Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes":241 89599744,"max_bytes":34359721984,"free_bytes":...
1. Failed: cannot extract value from json by path "$..INDEXES.used_pct.first()": no data matches the specified path

I have no idea what to do. Please help to resolve the issue.
Thanks in advance!

[Anton S]

So, problem now solved.

Issue was in template "Oracle by Zabbix Agent 2" in Item Prototypes => Oracle: Get tablespaces stats: Oracle TBS '{#TABLESPACE}': Tablespace usage percent => Preprocessing:
In Spet 1 Parameters is $..{#TABLESPACE}.used_pct.first(), but from database comes used_file_pct like this

"SYSAUX": {
"contents": "PERMANENT",
"file_bytes": 39602601984,
"max_bytes": 68719443968,
"free_bytes": 1949761536,
"used_bytes": 37652840448,
"used_pct_max": 57.63,
"used_file_pct": 95.08,
"status": 1
}

Preprocessing Parameters was changed to $..{#TABLESPACE}.used_file_pct.first(), template unlinked and linked again and all things now OKAY :-)