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 188.8.131.52 onwards
Last updated on MARCH 15, 2018
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Certain 'Incidents' or 'problems' shown on the database home page, do not generate email notification beginning with Enterprise Manager (EM) 220.127.116.11. Typically these incidents/problems will appear on the home page as:
Problem: <error code>
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":
- Go to the Database Home Page
- From the 'Oracle Database' drop down menu, select Monitoring then Incident Manager
- 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.
- At the bottom left half of the screen, the problem details are shown
- At the bottom right half of the screen, the Actions "Support Workbench:Package Diagnostic" is shown
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%'
and the Metric Group=Incident
Example of a correctly received email notification from the 'Incident' metric
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