EM 12c, EM 13c: Testing and Troubleshooting the 'Tablespace Space Full (%)' Metric in Enterprise Manager Cloud Control 220.127.116.11 and Higher
(Doc ID 1927636.1)
Last updated on JANUARY 15, 2020
Enterprise Manager for Oracle Database - Version 18.104.22.168.0 and later Information in this document applies to any platform.
Metric alert for Database Instance "Tablespace Space Used (%)" in Enterprise Manager 12c
Metric alert for Cluster Database "Tablespace Space Used (%)" in Enterprise Manager 12c
This article also applies to Enterprise Manager 13c
Starting with Enterprise Manager (EM) Cloud Control 22.214.171.124 (which ships with the database plug-in 126.96.36.199), there are some changes to the way metrics are evaluated. In the previous versions of Cloud Control some database metrics were evaluated by the server itself, via the server generated alert system, whereas some database metrics were evaluated by the agent. In 188.8.131.52 Cloud Control and higher, changes have been made so that any metric for which a threshold can be set in EM, will no longer rely on the server generated alert system, but will instead be evaluated by the EM agent. This change affects the 'Tablespace Space Full (%)' metric which was previously evaluated by the server generated alert system. In 184.108.40.206 (with database plugin 220.127.116.11), this metric will now be evaluated purely by the agent. This article is applicable to databases which are managed by 18.104.22.168 Cloud Control (or higher) and which are using the 22.214.171.124 database plugin (or higher). This article does not apply to earlier versions of Cloud Control.
Note: On a new 126.96.36.199 install the database plug-in will always be 188.8.131.52 (or higher), but on a system which has been upgraded from an earlier release, it's possible that some agents may not be using the 184.108.40.206 database plug-in. The database plug-in version can be obtained by running the command:
$ emctl listplugins agent
Oracle Enterprise Manager Cloud Control 12c Release 4 Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved. --------------------------------------------------------------- oracle.sysman.oh 220.127.116.11.0 /u01/12104Agent/plugins/oracle.sysman.oh.agent.plugin_18.104.22.168.0 oracle.sysman.db 22.214.171.124.0 /u01/12104Agent/plugins/oracle.sysman.db.agent.plugin_126.96.36.199.0 <-THIS IS THE DATABASE PLUGIN
on the agent machine which monitors the db target.
This article will be useful for troubleshooting the Metric alert for Database Instance "Tablespace Space Used (%)" in Enterprise Manager 12c and 13c
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!