How to Disable or Suppress OEM Alerts for Alert Log ORA Errors in OEM 12c and 13c


I wanted the following errors in the 12c DB alert log are expected and can be ignored.

ORA-700 kskvmstatact: excessive swapping observed
ORA 7445 [_IO_default_xsputn]

But if we enable Generic Alert Log Error Metric, agent will collect this error from alert log and generate an alert.

Modifying the Metric thresholds from EM Console does not make any difference and users will continue to get these alerts.

By default we can not exclude ORA-700 alerts.

Bug 19495842 - CHANGE THRESHOLD IN THE SWAP WARNING IN THE ALERT_<SID>.LOG


Steps:

1. Stop the agent that is monitoring the database

$/AGENT_INST/bin/emctl stop agent

2. Modify the entry in the <AGENT_INST>/sysman/config/emd.properties file from:

adrAlertLogErrorCodeExcludeRegex=.*700.*

This should filter all the ORA-700 errors.

If the requirement is to filter only the "(ORA 700 [kskvmstatact: excessive swapping observed])" error, you can set:

adrAlertLogErrorCodeExcludeRegex=.*kskvmstatact.*

NOTE:

If we need to suppress multiple ORA errors,
adrAlertLogErrorCodeExcludeRegex= ".*ORA 7445 [_IO_default_xsputn]\D.*|.*ORA 7445 [kkqojeanl]\D.*|.*ORA 7445 [qcsAnalyzeBooleanExpr]\D.*"
If we need to suppress any other ORA error,
adrAlertLogErrorCodeExcludeRegex=.*3137.*


3. Save the file.

4. Start the agent

$AGENT_INST/bin/emctl start agent




If you like please follow and comment