Friday, September 19, 2014

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

If this error occurs when trying to drop a trigger, e.g.
DROP TRIGGER RADIUS_DB.RADACCT_RADACCTID;

  1. Find the object_id of the trigger
    select object_id from dba_objects where object_name='RADACCT_RADACCTID';
  2. Insert the object_id into objerror$
    insert into sys.objerror$ values(126915);
    commit;
  3. shutdown abort
  4. startup
  5. Retry to drop the trigger, this should be OK now.
    DROP TRIGGER RADIUS_DB.RADACCT_RADACCTID;