How to Test Whether the "Tablespace Space Used (%)" Metric Alert is Working as Expected for a Database Instance or Cluster Database Instance in Enterprise Manager 12c? (Doc ID 1541511.1)

Last updated on APRIL 07, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.5.0 [Release 12.1]
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

Goal

How to check whether the Enterprise Manager Tablespace Space Used (%) metric is working as expected?  This article will be useful for troubleshooting:-

Metric alert for Database Instance "Tablespace Space Used (%)"  in Enterprise Manager 12c

Sometimes it is necessary to simulate a metric alert in Enterprise Manager Cloud Control 12c, to check whether the metric alert condition is detected.  Sometimes this is necessary when testing with incident rules/email notification, sometimes it is necessary to ascertain whether there's a general problem with the agents subscription to the databases server generated alert system.  When testing alerts its useful to trigger a new alert, because for example,  if new incident rules have been created, they will not fire for an alert which is already active.

Note that this is *not* applicable to Enterprise Manager 12.1.0.4 onwards.  For Enterprise Manager 12.1.0.4 see:

<Note:1927636.1> "EM 12c, EM 13c: Testing and Troubleshooting the 'Tablespace Space Full (%)' metric in Enterprise Manager 12.1.0.4 and higher"

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms