remidian.com

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>