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

Views: 208

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Notional Pool Setups

Hi All,

I have a requirement to setup a Notional Cash pool setups between pool leader and subaccount,

Please let me know what are the setups required to complete this.

Thanks,

Kishore

Posted by Kishore on September 14, 2014 at 11:00pm

Join cases between related tables in data computing and analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.

Table structure:

The table emp stores the employee data table, in which the…

Continue

Posted by Jim King on August 25, 2014 at 1:35am

Oracle RAC Classes

Contact me for Oracle High Availability Training / Online Classes - Dubai shans.dba@gmail.com

Posted by Shanmugam on August 18, 2014 at 1:00am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service