Hi all ,
our OEM 13c (Release 13.3.0.0.0) does not send immediate any email/notification when the alert.log file of a database contains an ORA-00600 entry (e.g. ORA-00600: internal error code, arguments:). Instead of sending this important notification immediate, the OEM sends the email/notification 7 days later. This is due to the Rule Name "Clear metric alert events older than 7 days". My expectation is that the Rule Name "Create incident for critical metric alerts" should send that notification when the metric alert detects an ORA-00600 entry. Under "Metric and Collection Settings" I have activated the Metrics "Alert Log", "Alert Log Error Status", "DB Alert Log" and "DB Alert Log Error Status" with a Collection Schedule of "every 15 Minutes". Under "Generic Alert Log Error" and "Generic Alert Log Error Status" I have set the comparison operator to "Matches" and the Warning Threshold to "ORA-0*(600?|7445|4[0-9][0-9][0-9])[^0-9]". BTW: these are the default settings.
I currently do not understand why the OEM does not send the email/notification when the ORA-00600 error gest detected in the alert.log. Do I need to set up something else which I'm currently not aware of to receive the email/notification?
Any help will be appreciated.
best regards
Jan