My Oracle Support Banner

EM 13c: Metric DB Alert Log Filter Regular Expression (RegEx) is not Working for ORA-31 Error. (Doc ID 2607260.1)

Last updated on NOVEMBER 19, 2019

Applies to:

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

Symptoms

Enterprise Manager 13c  is creating an Incident for the Error: ORA-31, even after adding it to the Filter Expression of the EM Metric: DB Alert Log - Generic Alert Log Error. 
(Note: only the newer "DB Alert Log - Generic Alert Log Error" is in use.  The deprecated "Alert Log" Metric Collection has been disabled.)

* Critical Threshold:                  ORA-[0-9]+[^0-9]
* Warning Threshold:                Not Defined
* Alert Log Filter Expression:    .*ORA-0*(31|54|1142|1146|28|60|230|235|312|313|439|604|959|1001|1013|1031|1100|1109|1112|1119|1123|1142|1461|1461|1511|1516|1531|1534|1537|1539|1543|1545|1549|1555|1575|1598|1623|1624|1628|1636|1652|1658|1661|1665|2053|2063|2097|3113|3217|3296|3297|19510|28500|01146|27046|1659|16401|27468|16055|12170|12608|3137|3135|3136)\D.*

=> Note that the Error code 31 is first in the Filter Expression above.

Using the Perl script alerttest.pl (from Note 1538482.1 : "EM 13c, EM 12c: Database Alert Log Monitoring in Enterprise Manager Cloud Control and Alert Log Metrics Explained")
to test the Thresholds and Filter Expression above against the text found in the (DB Alert) log.xml (Result = ORA-31), resulted in:

Why it is being created if it is part of the Alert Log Filter Expression?

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.