ORA-00600: internal error code, arguments: [kqd-objerror$]

Error: ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [88], [BIN$19274/1NYszgRAAUT/pFYw==$0], [], 

When: While purging recyclebin for a user or purging dba_recyclebin

 

SQL> purge recyclebin;

purge recyclebin

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [88], [BIN$19274/1NYszgRAAUT/pFYw==$0], [], [], [], [], [], [], []

Analysis:

Very much surprised by error like this, only clue was the hexa binary object_name specified in the error

As like any other DBA have started searching for more details of the object…

SQL> select OWNER,OBJECT_NAME,ORIGINAL_NAME,OPERATION,BASE_OBJECT,PURGE_OBJECT ,CAN_PURGE from dba_recyclebin where OBJECT_NAME like '%1NYszgRAAUT%';

OWNER       OBJECT_NAME    ORIGINAL_NAM OPERATION BASE_OBJECT PURGE_OBJECT CAN

--------  ---------------------------- --------------------- --------------------- ---------------------- ------------ ---

CE3    BIN$19274/1NYszgRAAUT/pFYw==$0 D_SR_NODE  DROP  151579    151856    NO

Got few details like Original object name & object id’s of the original as well as hexa binary object which was not recoverable although

An attempt was made to drop the object (type was trigger in my case)

SQL> drop trigger "BIN$19274/1NYszgRAAUT/pFYw==$0";

drop trigger "BIN$19274/1NYszgRAAUT/pFYw==$0"

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [88], [BIN$19274/1NYszgRAAUT/pFYw==$0], [], [], [], [], [], [], []

Process ID: 25839

Session ID: 164 Serial number: 10469

  

Oh! Got the same error

Finally got the solution after hunting on Google!

Solution:

Insert the object id’s found from dba_recyclebin into sys.objerror$, so that object causing error can be bypassed during purge recyclebin

SQL> show user

USER is "SYS"

SQL> insert into sys.objerror$ values(151579);

1 row created.

SQL> insert into sys.objerror$ values(151856);

1 row created.

SQL> select * from dba_objects where object_id='151579';

no rows selected

SQL>  select * from dba_objects where object_id='151856';

no rows selected

SQL> commit;

Commit complete.

SQL> conn CE3/test_333

Connected.

SQL> purge recyclebin;

Recyclebin purged.

SQL> conn / as sysdba

Connected.

SQL> purge dba_recyclebin;

DBA Recyclebin purged.