Ad Widget

Collapse

Zabbix_agent2 Oracle plugin

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gspoli
    Junior Member
    • Dec 2021
    • 4

    #1

    Zabbix_agent2 Oracle plugin

    I've installed Zabbix 5.4 with zabbix_agent2.
    Configured the connection to database, it discovered the pdbs and tablespaces, but just tablespaces form the CDB.
    Do you know how is it intent to work? Just CBD tablespaces? How to colect data from PDB's tablespace.

    SQL> conn /as sysdba
    Connected.
    SQL> show pdbs

    CON_ID CON_NAME OPEN MODE RESTRICTED
    ---------- ------------------------------ ---------- ----------
    2 PDB$SEED READ ONLY NO
    3 ORCL3DBPDB READ WRITE NO
    4 PDB2 READ WRITE NO
    5 PDB3 READ WRITE NO

    Tablesapces from CDB - witch where discovered

    SQL> select tablespace_name from dba_tablespaces;

    TABLESPACE_NAME
    ------------------------------
    SYSTEM
    SYSAUX
    UNDOTBS1
    TEMP
    USERS

    Click image for larger version

Name:	tbs_discovered.png
Views:	284
Size:	38.7 KB
ID:	436260

    Tablespaces from PDB2, not discovered

    SQL> alter session set container=PDB2;

    Session altered.

    SQL> select tablespace_name from dba_tablespaces;

    TABLESPACE_NAME
    ------------------------------
    SYSTEM
    SYSAUX
    UNDOTBS1
    TEMP
    USERS
    NOASM




    Thanks.



Working...