Extended Oracle agent to monitor Oracle 12c Multi-tenant database

Answer

ITCAM Extended Agent for Oracle Database latest release 6.31.02.07 is designed based on non-container databases structure only and does not provide enhanced support for Oracle multi-tenant container databases. However, you can choose to connect agent to multi-tenant container database.  In such a case, agent will monitor each database connection as non-container database and there is no special information for CDB or PDB will be provided.  Moreover, there are function limitations due to the design change of Oracle database (see the details mentioned in IF7 readme https://www.ibm.com/support/pages/node/6394564).

Following database object/views do not contain related information at PDB level
DBA_HIST_SYSMETRIC_SUMMARY, GV$FILEMETRIC, GV$RESOURCE_LIMIT, 
GV$SGASTAT, GV$SYSMETRIC, GV$SYSMETRIC_HISTORY, 
GV$SYSMETRIC_SUMMARY, GV$SYSSTAT, V$SPPARAMETER
which impact following attribute groups if the subnode is connecting to PDB:
RDB_Dba_Hist_SysMetric_Summary, 
RDB_TSFile_Metric, RDB_Resource_Limitation, RDB_Process_Summary,
RDB_GCS_Mem, RDB_GES_Mem, RDB_Sys_Metric_Growth_Percent,
RDB_Sys_Metric, RDB_Sys_Metric_History, RDB_GCS_Block_Lost,
RDB_Cache_Fusion_Write, RDB_GCS_CR_Latency, RDB_GCS_Cur_Block,
RDB_Instances_Active_Ratio, 
RDB_Active_Instance (When subnode connects to RAC instance),
RDB_Database_Topology (When subnode connects to RAC instance)

When connecting agent to Oracle multi-tenant container database, the agent needs to be connected to the CDB and PDBs in the Oracle multi-tenant setup.

The recommended monitoring setup for the CDB and PDB databases at current agent release (6.31.02.07) is as follows:
1) CDB monitoring:
Create one agent instance just to monitor CDB instance to achieve the following.
- it will collect the shared information for the CDB
- you can distinguish CDB from other PDBs
- you can create custom SQLs to monitor the CDB specific information in this agent instance - such as to monitor number of PDBs in this CDB

- it is suggested monitor oracle instance at CDB level, as agent is not able to get the status of all instances when the subnode is connected to PDB of RAC instance.

2) Create one or more agent instances to monitor all the PDBs in the multi-tenant environment.

Follow “2.3 Database Connection Number per Agent Instance” mentioned in Best Practices for ITCAM Oracle Database Extended Agent https://www.ibm.com/support/pages/node/1104033