ORA-00600: 内部错误代码, 参数: [ktspfmdb:objdchk_kcbnew_3]

问题描述：开发人员在往数据库中插入（仅一张表插入数据有次问题，其他表都正常）数据时出现异常信息，无法插入数据，具体报错信息见后文。

告警日志内容：

Wed Oct 25 11:42:47 2017

Errors in file /u01/app/oracle/diag/rdbms/sjjhdb/sjjhdb1/trace/sjjhdb1_ora_11477.trc  (incident=1128284):

ORA-00600: 内部错误代码, 参数: [ktspfmdb:objdchk_kcbnew_3], [1], [217404], [4], [], [], [], [], [], [], [], []

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Wed Oct 25 11:43:03 2017

Sweep [inc][1128284]: completed

 

Trace文件内容：

[root@zwdb1 ~]# more /u01/app/oracle/diag/rdbms/sjjhdb/sjjhdb1/trace/sjjhdb1_ora_9990.trc

DDE: Problem Key 'ORA 600 [ktspfmdb:objdchk_kcbnew_3]' was flood controlled (0x6) (incident: 1128272)

ORA-00600: 内部错误代码, 参数: [ktspfmdb:objdchk_kcbnew_3], [1], [217404], [4], [], [], [], [], [], [], [], []

 

*** 2017-10-25 10:48:28.311

BH (0x4a78b1818) file#: 15 rdba: 0x03d8c801 (15/1624065) class: 8 ba: 0x4a4582000

  set: 91 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25

  dbwrid: 2 obj: 229898 objn: 229898 tsn: 12 afn: 15 hint: f

  hash: [0x8ecba7f98,0x8ecba7f98] lru: [0x76fb0efa8,0x3f7a7d3c8]

  lru-flags: on_auxiliary_list

  ckptq: [NULL] fileq: [NULL] objq: [0xb8383098,0xb8383098] objaq: [0xb8383088,0xb8383088]

  st: XCURRENT md: NULL fpin: 'ktspfwh17: ktspfundo' tch: 0 le: 0x44ffbfe10

  flags: block_written_once redo_since_read

  LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [103]

Dump of buffer cache at level 10 for tsn=12 rdba=64538625

BH (0x4a78b1818) file#: 15 rdba: 0x03d8c801 (15/1624065) class: 8 ba: 0x4a4582000

  set: 91 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25

  dbwrid: 2 obj: 229898 objn: 229898 tsn: 12 afn: 15 hint: f

  hash: [0x8ecba7f98,0x8ecba7f98] lru: [0x76fb0efa8,0x3f7a7d3c8]

  lru-flags: on_auxiliary_list

  ckptq: [NULL] fileq: [NULL] objq: [0xb8383098,0xb8383098] objaq: [0xb8383088,0xb8383088]

  st: XCURRENT md: NULL fpin: 'ktspfwh17: ktspfundo' tch: 0 le: 0x44ff