How to Quickly Ignore ORA Error on Agent Layer

Posted in: Oracle, Technical Track

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!

email

Interested in working with Matheus? Schedule a tech call.

About the Author

Lead Database Consultant
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.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *