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!

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 →

What We Do

How to Quickly Ignore ORA Error on Agent Layer

How to do it?

Share this

Share this

More resources

Oracle Enterprise Manager Cloud Control 13c release 3 (13.3.0.0) database template

Exadata: How to manage OS dependencies when upgrading to 19c

Issues with Plan Cache Reuse & Row Goal Optimization

Ready to unlock value from your data?