Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20202 templates for Oracle monitoring need updates to support v 12.2.0.1
  3. ZBX-22385

Oracle by Zabbix agent 2 plugin changes to support tablespace discovery and monitoring across CDB and PDBs

XMLWordPrintable

    • 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)
    • 0.1

      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.

            knaglis Kristaps Naglis
            knaglis Kristaps Naglis
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: