Skip to content

Insight and analysis of technology and business strategy

How to Quickly Ignore ORA Error on Agent Layer

Matheus Boesing date icon
Tags: , , , , ,
I had a very specific situation where I wanted to ignore an error from a specific agent. It turns out that it is easier and quicker to ignore a specific error using an OEM Metric. How? By using an agent parameter. adrAlertLogErrorCodeExcludeRegex.

How to do it?

In [AGENT_INST]/sysman/config/emd.properties, add a line with these parameters and the Regex to ignore the desired error or message. Ignoring all ORA-700, for example, can be done by: 
adrAlertLogErrorCodeExcludeRegex=.*700.*
Now to ignore specific errors, for example, ORA 700 [kskvmstatact: excessive swapping observed]: 
adrAlertLogErrorCodeExcludeRegex=.*kskvmstatact.*
After this parameter inclusion, a restart on the agent is required. This is also well-documented as per MOS EM 12c, 13c: How to Disable or Suppress OEM Alerts for Alert Log Error ORA-700 (Doc ID 2406779.1) Hope this helps!
Matheus Boesing

Well known in the Oracle community in Latin America and Europe where he participates regularly in technology events, Matheus is actually the youngest Oracle ACE Director in the world. Lead Database Consultant at Pythian, Matheus is a Computer Scientist by PUCRS and has been working as an Oracle DBA for the last 10 years.

Top Categories

  • There are no suggestions because the search field is empty.

Tell us how we can help!
dba-cloud-services
Upcoming-Events-banner