Clearing Alerts in Oracle GRID Control

  • Published on Nov 12 2007
  • # 3,042
  • Grid

Here’s how to clear alerts from the Oracle GRID manually.

For some obscure reason Oracle is very reluctant in providing the information that is described here below. Search Metalink and you will find no entries… The information below is from dbasupport.com and helps me to clear alerts that the Agent does NOT clear for me.

sysman.em_severity
[REMI@DB01.REMIDIAN.COM]
SQL>  @desc sysman.em_severity
.
.
PROCEDURE DELETE_CURRENT_SEVERITY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_TARGET_GUID                  RAW                     IN
 P_METRIC_GUID                  RAW                     IN
 P_KEY_VALUE                    VARCHAR2                IN
.
.

Generate SQL to remove alerts from specific targets
select t.target_name
,      t.target_type
,      collection_timestamp
,      message
,      'exec em_severity.delete_current_severity(''' ||
           t.target_guid || ''',''' ||
           metric_guid || ''',''' ||
           key_value || ''')' em_severity
from   mgmt_targets t
inner join
       mgmt_current_severity s
on
       t.target_guid = s.target_guid
where
       target_name like '&TARGET'
Remove the Alert
[REMI@DB01.REMIDIAN.COM]
SQL> begin
  2  em_severity.delete_current_severity('3DFABFF28D9C283435DBD2491D35B92B','3E6F70DB22758B7B9756EF342180E7BB','UNDO');
  3  end;
  4  /

PL/SQL procedure successfully completed.

[REMI@DB01.REMIDIAN.COM]
SQL> 

3 thoughts on “Clearing Alerts in Oracle GRID Control

  1. Tiago says:

    That works good… thanks!

  2. Jos says:

    Nice one!!
    even 4 years later, nothing on Metalink about this.
    Thanks

  3. Mausumi Moharar says:

    This worked really well! Thank you!

Leave a Reply to Jos Cancel reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>