EM 12c, EM 13c: How to Check that Agent Evaluated Enterprise Manager Metric Alerts are working as Expected in Enterprise Manager Cloud Control (Doc ID 1600486.1)

Last updated on DECEMBER 02, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Goal

There are two types of metric alert in Enterprise Manager 12c:-

1) Metrics which are evaluated by the agent

2) Metrics which are evaluated by the database itself (via the server generated alert system) which the agent subscribes to.   Note that in 12.1.0.4 Cloud Control and higher, there are less metrics which rely on the server generated alert system.  In 12.1.0.4 onwards, any metric for which it is possible to set a threshold for in the console, will not be utilizing the server generated alert system.  For more details see <Note:1680788.1> "Changes to Oracle Database Monitoring in Enterprise Manager Cloud Control 12.1.0.4".  Metrics for which it is not possible to specify a threshold for in the console (eg. 'Recovery Area'/'Snapshot too old' etc) will still be evaluated by the server generated alert system.

When setting up Enterprise Manager for the first time, it is useful to create a test metric condition to confirm that metric notification is working as expected.  

This article concentrates on metrics which are evaluated by the agent.

For metrics which are evaluated by the database itself see <Note:1541511.1> "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?"  (This is applicable for 12.1.0.1 -> 12.1.0.3 only).  For testing the Tablespace Space Used (%) metric in higher versions, see <Note:1927636.1> "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