Tuesday, October 16, 2012

Alertlog Error Filter in Oracle Cloud Control

ISSUE:
Some ORA- error in alert log file of oracle database instance is known and can be ignored for your system. You want to filter the error out so that no event will be generated when the error appears in the log

SOLUTION:
modify the filter expression
in all or any database instance target
Go to oracle database >monitoring> metric and collection setting>
Click edit for General Alter Log Error
change .*ORA-0*(54|1142|1146)\D.* to .*ORA-0*(54|1142|1146|???)(\D.*|$)

e. g.
to fileter ora-1234

new filter expression should be .*ORA-0*(54|1142|1146|1234)(\D.*|$)


reference:
http://docs.oracle.com/cd/E24628_01/em.121/e25160/osm_instance.htm
http://docs.oracle.com/cd/E24628_01/doc.121/e24473/toc.htm
http://docs.python.org/release/1.5.2p2/lib/re-syntax.html

1 comment:

  1. We have ORA-0*(600|7445|4031)[^0-9] critical threshold set for generic alertlog. We need to exclude ORA-00600[keswxReadGlobalInfoFromStream:magic] from being reported in OEM. Please help with reg expression.

    ReplyDelete