templates for Oracle monitoring need updates to support v 12.2.0.1 (ZBX-20202)

[ZBX-22385] Oracle by Zabbix agent 2 plugin changes to support tablespace discovery and monitoring across CDB and PDBs Created: 2023 Feb 21  Updated: 2023 Jul 08  Resolved: 2023 Jul 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent2 plugin (G)
Affects Version/s: 5.0.31, 6.0.13, 6.2.7, 6.4.0rc1
Fix Version/s: 7.0.0alpha2, 7.0 (plan)

Type: Sub-task Priority: Trivial
Reporter: Kristaps Naglis Assignee: Kristaps Naglis
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Team: Team INT
Sprint: Sprint 82 (Nov 2021), Sprint 83 (Dec 2021), Sprint 84 (Jan 2022), Sprint 85 (Feb 2022), Sprint 86 (Mar 2022), Sprint 87 (Apr 2022), Sprint 88 (May 2022), Sprint 89 (Jun 2022), Sprint 90 (Jul 2022), Sprint 91 (Aug 2022), Sprint 92 (Sep 2022), Sprint 93 (Oct 2022), Sprint 94 (Nov 2022), Sprint 98 (Mar 2023), Sprint 99 (Apr 2023), Sprint 100 (May 2023), Sprint 101 (Jun 2023)
Story Points: 0.1

 Description   

Agent 2 plugin for Oracle DB currently cannot discover and monitor tablespaces across CDB and all PDBs.

Some changes needs to be introduced:

  • Tablespaces discovery:
    • data needs to be queried from CDB_TABLESPACES instead of current DBA_TABLESPACES. See ODBC template implementation query from parent task
    • needs to return column "CON_NAME" like in the ODBC template query
  • Tablespaces stats:
    • introduce new agent 2 parameter "CON_NAME" in oracle.ts.stats, which should look like this: 
      oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{#CON_NAME}","{#TABLESPACE}","{#CONTENTS}"]
    • query should be adjusted to use CDB_* views and filter results by CON_NAME in addition to existing TABLESPACE and CONTENTS. A working query is in the parent task ODBC template.

 Comments   
Comment by Kristaps Naglis [ 2023 Apr 27 ]

Resolved as a part of https://support.zabbix.com/browse/ZBX-20202

Comment by Marina Generalova [ 2023 Jun 28 ]

Documentation updated:

Generated at Sun Apr 06 06:06:15 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.