EM 12c, EM 13c: ADR Incidents generated by the rdbms and detected by the EM 'Incident' metric do not generate Email Notification in Enterprise Manager 12.1.0.4 onwards

(Doc ID 2046362.1)

Last updated on MARCH 13, 2017

Applies to:

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

Symptoms

Certain 'Incidents' or 'problems' shown on the database home page, do not generate email notification in Enterprise Manager 12.1.0.4 onwards. Typically these incidents/problems will appear on the home page as:

Problem: <error code>

eg. 

Problem: ORA 600
Problem: ORA 7445
Problem: ORA 700 [kgerev1]

and tend to be associated with an error, for example:

An access violation detected in /oracle/orabase/diag/rdbms/<sid>/<sid>/alert/log.xml at time/line number: Fri Aug 21 11:48:04 2015/213702.

These problems/incidents can also be seen in "Incident Manager":

  1. Go to the Database Home Page
  2. From the 'Oracle Database' drop down menu, select Monitoring then Incident Manager
  3. Click on the left hand link 'All open problems'

The 'incidents' or 'problems' that do not generate emails are all related to ADR incidents (which are originally raised by the rdbms).

To confirm whether these are ADR incidents, highlight the 'problem' line.

This shows that this is an ADR Incident.

These ADR incidents should be detected by the EM 'Incident' Metric which is normally enabled automatically out-of-the-box.  

If email notification is correctly received from the EM 'Incident' metric to report on an ADR incident, it will contain the event name of 'adrAlertLog%'

eg.

adrAlertLogIncidentError:outOfMemoryErrStack
adrAlertLogIncidentError:genericInternalErrStack
adrAlertLogDataFailure:dataFailuerErrStack

and the Metric Group=Incident

Example of a correctly received email notification from the 'Incident' metric

 

Cause

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