EM 13.5: Condition Based Alert Log Monitoring - Send Mail Alerts Based on Comparison Result of Two ORA- Errors in Alert Log (Doc ID 2815540.1)

Last updated on OCTOBER 26, 2021

Applies to:

Goal

So far alert log monitoring detects any ORA- error logged in database alert log. These ORA- errors will be sent through email notifications depending on threshold settings on 'Alert Log/DB Alert' Log metric. At certain times the ORA- errors occurs in pair and noted in database alert log. There is a requirement to compare these ORA- error pairs, and send the alert only if certain condition matches.

For example, below are the entries from DB alert log.

In this case, if there is 'ORA-4031' is followed by 'ORA-2063', the alert should not trigger by OEM. This ORA- pair indicates some known issue over remote DB in customer setup. Similarly there might be other requirements for comparing two ORA- errors before sending the mail notification.

Solution

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