My Headlines

HowTo: Clearing Alerts in OEM 10g Grid Control

Sunday, February 12, 2012 Published by satya

I was browsing the Oracle Forums earlier today and this post with a bit of SQL to clear OEM alerts from mnazim, who always has good advice to offer:
To clear the alert:

1. Make a SELECT * from MGMT_CURRENT_SEVERITY and show for the TARGET_GUID, METRIC_GUID and KEY_VALUE.

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');

Filed under:

1 comments:

  1. Anonymous Says:

    Oracle: Howto: Clearing Alerts In Oem 10G Grid Control >>>>> Download Now

    >>>>> Download Full

    Oracle: Howto: Clearing Alerts In Oem 10G Grid Control >>>>> Download LINK

    >>>>> Download Now

    Oracle: Howto: Clearing Alerts In Oem 10G Grid Control >>>>> Download Full

    >>>>> Download LINK Ae

    Posted on April 10, 2022 at 6:40 PM  

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

Followers