OEM Deleting Alert Manually

Sometimes Oracle Enterprise Manager alert was triggered and will not go away.  You cannot even delete those alert from the OEM User Interface and wait for the alerts to go away automatically but it never goes away.




When this happen here is some option you can try to remove those alerts.

Loggon to OEM server and login as sysman.

select target_guid, metric_guid, key_value, message from mgmt_current_severity 

where message like 'User SYS logged on %';

TARGET_GUID                      METRIC_GUID
-------------------------------- --------------------------------
KEY_VALUE
-------------------------
MESSAGE
--------------------------------------------------------------------------------
BF0B06F8FE2A18DBD8CB3F89C6503995 D6438569B496BC9205481E8A70F92F1E
SYS_grape
User SYS logged on from grape.

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

 SQL> exec EM_SEVERITY.delete_current_severity('BF0B06F8FE2A18DBD8CB3F89C6503995'
,'D6438569B496BC9205481E8A70F92F1E','SYS_grape');
PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.