ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862]

Fri Apr 20 12:24:30 2012
Errors in file d:\oracle\product\10.2.0\admin\tss1112\bdump\tss5_mmon_2416.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []

BEGIN :success := dbms_ha_alerts_prvt.check_ha_resources; END;



To implement the workaround, please execute the following steps as the SYS user:

1. Collect the following information and spool it to a file for your records.

a. output of select * from v$instance
b. show parameter instance_name
c. set pages 1000
d. select * from recent_resource_incarnations$

2. Create a backup table of recent_resource_incarnations$.

SQL> create table recent_resource_inc$bk as select * from recent_resource_incarnations$;


3. Truncate recent_resource_incarnations$. Be sure to do this while the instance is up and running. Do not issue this statement if a shutdown is pending.

SQL> truncate table recent_resource_incarnations$;


4. Perform a clean shutdown, followed by a startup.