Exclude specifi ORA error from Database target Metrics

Exclude ORA Error from Database target Metrics

To exclude an ORA Error from OEM, follow these steps:

1.  In Cloud Control, go to the target database and navigate to Oracle Database à Monitoring à Metrics and collection Settings.

2.       On Next Window click Edit icon for the “Generic Alert log Error”

3.       On Next Window we can see the Alert log filter expression with default values, there we need to add our errors which we need to ignore

4.       Below are the errors which we need to exclude as per dream environment , so I am creating the exception expression as “New one”

5.       For Creating the expression we can use the below site to check the expression values is correct or not.

http://www.regular-expressions.info/javascriptexample.html

6.       Create the expression and give the error message in the text box like above and below image and you can see the show match, it need to match, if it is matches the ORA error will exclude in OEM Metrics.

7.       On Next Window paste the tested expression in the alert log filtering box and click continue.

8.       On Next Window click ok, unless you click ok here, the metrics will save the new changes.

9.On Next Window You can see the saved metric confirmation result.