Manually Clear Alerts in Oracle Enterprise Manager 11g

In our 11gR2 RAC databse, we got some ORA-00600 errors in the alert log file. These errors have been fixed by applying the oracle patches. But, in the Oracle Enterprise Manager these old alerts are not cleared. To manually clear the alerts, I did the following steps;

1. Go to Enterprise Manager Home Page > select Instance Name > Metrics and policy settings > changed the view to all metrics > Choose the “Generic Internal Error” metric to disable it.

Follow the links below to see the steps;

http://www.oracle-class.com/wp-content/uploads/2011/11/EM1.png

http://www.oracle-class.com/wp-content/uploads/2011/11/EM2.png

http://www.oracle-class.com/wp-content/uploads/2011/11/EM3.png

http://www.oracle-class.com/wp-content/uploads/2011/11/EM4.png

2. Go to the Instance from the SSH client > export correct environment for the database instance > as the oracle database software owner issue “emctl clearstate agent” command.

3. Go to console and check the alert is cleared now,

4. To enable the metric now for future alerts; Go to DB Console Home Page > select Instance Name > Metrics and policy settings > changed the view to all metrics > Click on “Generic Internal Error” metric and enable it again by adding the characters “.*” in the critical threshold field and save the changes.

You can find the article here: www.oracle-class.com

Hope it helps!

Wissem EL KHLIFI