ORA-00600: internal error code, arguments: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []

1.数据库异常恢复后数据库提示一下报错

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5239.trc  (incident=121363):
ORA-00600: internal error code, arguments: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

2.通过查查trace文件发现问题

通过以下日志文件，判断是DATA_OBJECT_ID=104126这个对象有问题

*** SESSION ID:(32.9) 2021-09-25 09:15:01.750
OBJD MISMATCH typ=16, seg.obj=-2, diskobj=104128, dsflg=0, dsobj=104126, tid=104126, cls=4
Incident 120379 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_120379/orcl_ora_3092_i120379.trc
ORA-00600: internal error code, arguments: [ktecgsc:kcbz_objdchk], [0], [0], [1], [], [], [], [], [], [], [], []

3.检查DATA_OBJECT_ID=104126这个对象

发现对象在数据库上已经不存在，但是还能查询到。发现这个表是自己创建的并不是系统表，删除之后恢复正常

SQL> select object_name,object_type,owner from dba_objects where DATA_OBJECT_ID=104126;
OBJECT_NAME          OBJECT_TYPE         OWNER
-------------------- ------------------- ------------------------------
XINJU_HEADROOM_SCN   TABLE               SYS

SQL> select * from XINJU_HEADROOM_SCN;
select * from XINJU_HEADROOM_SCN
              *
ERROR at line 1:
ORA-08103: object no longer exists