CLEAN OEM ALERTS

Some times OEM show lots of alerts. But alerts will be available on OEM alert tab,  after fixed the issues, and It's creating a confusion the alert was fixed or not. 

So it's very simple to delete the entry after fix the alert > issue on OEM. 

Below the steps you have to follow.

==============

Clean OEM Alerts

==============

1. MGMT_CURRENT_SEVERITY  table show for the TARGET_GUID, METRIC_GUID and KEY_VALUE. 

SELECT TARGET_GUID, METRIC_GUID,KEY_VALUE from MGMT_CURRENT_SEVERITY;

2. Connect to db user SYSMAN and execute:

exec EM_SEVERITY.delete_current_severity(TARGET_GUID,METRIC_GUID,KEY_VALUE);

for example:

exec EM_SEVERITY.delete_current_severity('0DEB8E6980695B7548CF98871084AD10','F95BA0D95585002889E1ABF92B2DA7C3','SYS');

3. Wait a few minutes.

Commit.

4. Verify it on OEM and table also

SELECT TARGET_GUID, METRIC_GUID,KEY_VALUE from MGMT_CURRENT_SEVERITY;

or

OEM.

Enjoy.....!!!!