Ad Widget

Collapse

Oracle Get tablespaces stats : failed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • studero
    Member
    • Aug 2023
    • 84

    #1

    Oracle Get tablespaces stats : failed

    Hi,

    Zabbix Server : 6.4.8
    Oracle version : 19

    Items :
    Tablespace discovery: Oracle TBS 'SYSAUX': Get tablespaces stats: Oracle TBS 'SYSAUX': Tablespace usage from MAX, percent

    And also TBS SYSTEM, TBS TEMP, TBS UNDOTBS

    I have this following error message:​

    Info error : Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes": 527 4337280,"max_bytes":34359721984,"free_bytes":6...
    1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path​

    And the log file contains :
    1171125:20231116:132505.188 enabling Zabbix agent checks on host "svx-ora-11e - co11911e": interface became available
    1171059:20231116:132544.037 item "svx-ora-11e - co11911eracle.tbs_used_from_max_pct["USERS"]" became not supported: Preprocessing failed for: [{"USERS":{"contents":"PERMANENT","file_bytes":5242 880,"max_bytes":34359721984,"free_bytes":24248...
    1. Failed: cannot extract value from json by path "$..['USERS'].used_from_max_pct.first()": no data matches the specified path
    1171060:20231116:132608.075 item "svx-ora-11e - co11911eracle.tbs_used_from_max_pct["SYSTEM"]" became not supported: Preprocessing failed for: [{"SYSTEM":{"contents":"PERMANENT","file_bytes":100 6632960,"max_bytes":34359721984,"free_bytes":1...
    1. Failed: cannot extract value from json by path "$..['SYSTEM'].used_from_max_pct.first()": no data matches the specified path
    1171072:20231116:132618.102 item "svx-ora-11e - co11911eracle.tbs_used_from_max_pct["SYSAUX"]" became not supported: Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes":527 4337280,"max_bytes":34359721984,"free_bytes":6...
    1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path
    1171059:20231116:132626.117 item "svx-ora-11e - co11911eracle.tbs_used_from_max_pct["UNDOTBS1"]" became not supported: Preprocessing failed for: [{"UNDOTBS1":{"contents":"UNDO","file_bytes":403701 760,"max_bytes":34359721984,"free_bytes":34072...
    1. Failed: cannot extract value from json by path "$..['UNDOTBS1'].used_from_max_pct.first()": no data matches the specified path
    1171071:20231116:132635.133 item "svx-ora-11e - co11911eracle.tbs_free_bytes["TEMP"]" became not supported: Value of type "string" is not suitable for value type "Numeric (unsigned)". Value "-528482304"
    1171071:20231116:132635.133 item "svx-ora-11e - co11911eracle.tbs_used_from_max_pct["TEMP"]" became not supported: Preprocessing failed for: [{"TEMP":{"contents":"TEMPORARY","file_bytes":15099 4944,"max_bytes":34359721984,"free_bytes":-528...
    1. Failed: cannot extract value from json by path "$..['TEMP'].used_from_max_pct.first()": no data matches the specified path
    zz0.bfslhxzce4nzz

    I need help to resolve this error.

    Regards
    Olivier
Working...