How to Quickly Ignore ORA Error on Agent Layer

1 min read

Mar 2, 2020 12:00:00 AM

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!

Oracle Database Consulting Services

Ready to optimize your Oracle Database for the future?

Speak with our Oracle Database consultants ->

On this page

Ready to unlock value from your data?

With Pythian, you can accomplish your data transformation goals and more.

Speak with Pythian consultants now →

Services

How to Quickly Ignore ORA Error on Agent Layer

How to do it?

Oracle Database Consulting Services

Share this

Share this

More resources

JSP Cache Issues in 11i and R12

Expand Elastic Configuration on Oracle Exadata - Part 2

Oracle Instance Memory Usage

Ready to unlock value from your data?