ORA-00600: internal error code, arguments: [kkdc1prc:BadType]

周一刚上班就遇到ORA-00600报错，现场反馈，其他业务都正常，就一个业务异常无法使用，alert报错如下：

2023-04-07T11:10:18.036001+08:00
ARC1 (PID:297134): Archived Log entry 2584 added for T-1.S-1667 ID 0xcf58e07d LAD:1
2023-04-07T11:15:08.934134+08:00
Index USR_JW.PK_T_SJCJ_FWSJ or some [sub]partitions of the index have been marked unusable
2023-04-07T11:25:15.929909+08:00
Dumping diagnostic data in directory=[cdmp_20230407112410], requested by (instance=2, osid=442317), summary=[incident=236297].
2023-04-07T11:25:18.016609+08:00
Dumping diagnostic data in directory=[cdmp_20230407112412], requested by (instance=2, osid=10951), summary=[incident=236298].
2023-04-07T11:25:19.878018+08:00
Dumping diagnostic data in directory=[cdmp_20230407112414], requested by (instance=2, osid=10988), summary=[incident=236075].
2023-04-07T11:26:17.315989+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_347675.trc  (incident=298657):
ORA-00600: internal error code, arguments: [kkdc1prc:BadType], [1], [87], [0], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_298657/orcl1_ora_347675_i298657.trc
2023-04-07T11:26:17.610229+08:00

[root@db1 ~]#  strings /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_347675.trc|more
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_347675.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
Build label:    RDBMS_19.15.0.0.0DBRU_LINUX.X64_220330
ORACLE_HOME:    /u01/app/oracle/product/19.0.0/db_1
System name:    Linux
Node name:    db1
Release:    3.10.0-957.el7.x86_64
Version:    #1 SMP Thu Nov 1 00:13:43 PDT 2018
Machine:    x86_64
Instance name: orcl1
Redo thread mounted by this instance: 1
Oracle process number: 212
Unix process pid: 347675, image: oracle@db1
*** 2023-04-07T11:26:17.316512+08:00
*** SESSION ID:(1466.21874) 2023-04-07T11:26:17.316530+08:00
*** CLIENT ID:() 2023-04-07T11:26:17.316535+08:00
*** SERVICE NAME:(orcl) 2023-04-07T11:26:17.316538+08:00
*** MODULE NAME:(JDBC Thin Client) 2023-04-07T11:26:17.316542+08:00
*** ACTION NAME:() 2023-04-07T11:26:17.316546+08:00
*** CLIENT DRIVER:(jdbcthin) 2023-04-07T11:26:17.316550+08:00
2023-04-07T11:26:17.316366+08:00
Incident 298657 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_298657/orcl1_ora_347675_i298657.trc
ORA-00600: internal error code, arguments: [kkdc1prc:BadType], [1], [87], [0], [], [], [], [], [], [], [], []
[root@db1 ~]#

[root@db1 ~]#  strings /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_298657/orcl1_ora_347675_i298657.trc|more
Dump file /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_298657/orcl1_ora_347675_i298657.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.15.0.0.0
Build label:    RDBMS_19.15.0.0.0DBRU_LINUX.X64_220330
ORACLE_HOME:    /u01/app/oracle/product/19.0.0/db_1
System name:    Linux
Node name:    db1
Release:    3.10.0-957.el7.x86_64
Version:    #1 SMP Thu Nov 1 00:13:43 PDT 2018
Machine:    x86_64
Instance name: orcl1
Redo thread mounted by this instance: 1
Oracle process number: 212
Unix process pid: 347675, image: oracle@db1
*** 2023-04-07T11:26:17.316684+08:00
*** SESSION ID:(1466.21874) 2023-04-07T11:26:17.316690+08:00
*** CLIENT ID:() 2023-04-07T11:26:17.316693+08:00
*** SERVICE NAME:(orcl) 2023-04-07T11:26:17.316696+08:00
*** MODULE NAME:(JDBC Thin Client) 2023-04-07T11:26:17.316699+08:00
*** ACTION NAME:() 2023-04-07T11:26:17.316701+08:00
*** CLIENT DRIVER:(jdbcthin) 2023-04-07T11:26:17.316704+08:00
[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_347675.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kkdc1prc:BadType], [1], [87], [0], [], [], [], [], [], [], [], []
[TOC00001-END]
[TOC00002]
========= Dump for incident 298657 (ORA 600 [kkdc1prc:BadType]) ========
*** 2023-04-07T11:26:17.317001+08:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=75126rtdvacux) -----
UPDATE EMAP_QZ_TRIGGERS SET JOB_NAME = :1 , JOB_GROUP = :2 , DESCRIPTION = :3 , NEXT_FIRE_TIME = :4 , PREV_FIRE_TIME = :5 , TRIGGER_STATE = :6 , TRIGGER_TYPE = :7 , START_T
IME = :8 , END_TIME = :9 , CALENDAR_NAME = :10 , MISFIRE_INSTR = :11 , PRIORITY = :12  WHERE SCHED_NAME = 'EmapClusterScheduler2-gemini-geminiplugin' AND TRIGGER_NAME = :13
  AND TRIGGER_GROUP = :14
[TOC00003-END]
[TOC00004]

可能是表问题，转给产品处理了，让他们手动执行故障sql看看效果，下班后反馈找到问题了，表结构被修改导致，无人认领。自己人坑自己人

ORA-00600 [kkdc1prc:BadType] Raised Running Query (Doc ID 1591377.1)