ORA-600 kkkicreatecgmap:!efn3---惜分飞
联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-600 kkkicreatecgmap:!efn3
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
raid故障恢复之后,数据库recover成功,但是open报ORA-03113: end-of-file on communication channel错误
SQL> recover database;Media recovery complete.SQL> alter database open;alter database open*ERROR at line 1:ORA-03113: end-of-file on communication channelProcess ID: 20394Session ID: 191 Serial number: 3对应的alert日志错误为ORA-600 错误
ALTER DATABASE RECOVER databaseMedia Recovery Start started logmerger processParallel Media Recovery started with 4 slavesMon Oct 20 18:51:06 2025Recovery of Online Redo Log: Thread 1 Group 1 Seq 32119 Reading mem 0 Mem# 0: /u01/oradata/redo01.logMedia Recovery Complete (orcl)Completed: ALTER DATABASE RECOVER databaseMon Oct 20 18:51:16 2025alter database openBeginning crash recovery of 1 threads parallel recovery started with 3 processesStarted redo scanCompleted redo scan read 41 KB redo, 0 data blocks need recoveryStarted redo application at Thread 1: logseq 32119, block 34978Recovery of Online Redo Log: Thread 1 Group 1 Seq 32119 Reading mem 0 Mem# 0: /u01/oradata/redo01.logCompleted redo application of 0.00MBCompleted crash recovery at Thread 1: logseq 32119, block 35061, scn 17375938230308 0 data blocks read, 0 data blocks written, 41 redo k-bytes readMon Oct 20 18:51:16 2025Thread 1 advanced to log sequence 32120 (thread open)Thread 1 opened at log sequence 32120 Current log# 2 seq# 32120 mem# 0: /u01/oradata/redo02.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setMon Oct 20 18:51:16 2025SMON: enabling cache recoverySuccessfully onlined Undo Tablespace 2.Verifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryRe-creating tempfile /u01/oradata/temp01.dbfDatabase Characterset is ZHS16GBKException Exception Exception No Resource Manager plan activeMon Oct 20 18:51:16 2025Errors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbrm_20286.trc (incident=3649):ORA-00600: internal error code, arguments: , , , [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/app/diag/rdbms/orcl/orcl/incident/incdir_3649/orcl_dbrm_20286_i3649.trcErrors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbrm_20286.trc:ORA-00600: internal error code, arguments: , , , [], [], [], [], [], [], [], [], []DBRM (ospid: 20286): terminating the instance due to error 56710Instance terminated by DBRM, pid = 20286对应的trace文件内容
----- Call Stack Trace -----calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ----------------------------skdstdst()+36 call kgdsdst() 000000000 ? 000000000 ? 7FFD0876F978 ? 000000001 ? 7FFD08773E78 ? 000000000 ?ksedst1()+98 call skdstdst() 000000000 ? 000000000 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?ksedst()+34 call ksedst1() 000000000 ? 000000001 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?dbkedDefDump()+2736 call ksedst() 000000000 ? 000000001 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?ksedmp()+36 call dbkedDefDump() 000000003 ? 000000002 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?ksfdmp()+64 call ksedmp() 000000003 ? 000000002 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?dbgexPhaseII()+1764 call ksfdmp() 000000003 ? 000000002 ? 7FFD0876F978 ? 000000001 ? 000000000 ? 000000000 ?dbgexProcessError() call dbgexPhaseII() 7F16CCF3E6F0 ? 7F16CA6F2598 ?+2279 7FFD0877BC68 ? 000000001 ? 000000000 ? 000000000 ?dbgeExecuteForError call dbgexProcessError() 7F16CCF3E6F0 ? 7F16CA6F2598 ?()+83 000000001 ? 000000000 ? 7FFD00000000 ? 000000000 ?dbgePostErrorKGE()+ call dbgeExecuteForError 7F16CCF3E6F0 ? 7F16CA6F2598 ?1615 () 000000001 ? 000000001 ? 000000000 ? 000000000 ?dbkePostKGE_kgsf()+ call dbgePostErrorKGE() 000000000 ? 7F16CA560040 ?63 000000258 ? 7F16CA6F2598 ? 000000000 ? 000000000 ?kgeadse()+383 call dbkePostKGE_kgsf() 00A99D360 ? 7F16CA560040 ? 000000258 ? 7F16CA6F2598 ? 000000000 ? 000000000 ?kgerinv_internal()+ call kgeadse() 00A99D360 ? 7F16CA560040 ?45 000000258 ? 000000000 ? 000000000 ? 000000000 ?kgerinv()+33 call kgerinv_internal() 00A99D360 ? 7F16CA560040 ? 877420000000000 ? 000000258 ? 000000000 ? 000000000 ?kgeasnmierr()+143 call kgerinv() 00A99D360 ? 7F16CA560040 ? 877420000000000 ? 000000000 ? 000000000 ? 000000000 ?kkkicreatecgmap()+3 call kgeasnmierr() 00A99D360 ? 7F16CA560040 ?125 877420000000000 ? 000000000 ? 000000000 ? 00000057B ?kskirefreshcgmap()+ call kkkicreatecgmap() 121DC3050 ? 7F16CA560040 ?104 877420000000000 ? 000000000 ? 000000000 ? 00000057B ?kskreload()+1150 call kskirefreshcgmap() 121DC3050 ? 7F16CA560040 ? 877420000000000 ? 000000000 ? 000000000 ? 00000057B ?kskdbrmpa()+378 call kskreload() 7FFD0877D428 ? 000000001 ? 000000000 ? 000000001 ? 000000000 ? 00000020A ?ksbabs()+465 call kskdbrmpa() 7FFD0877D418 ? 000000058 ? 000000000 ? 000000001 ? 000000000 ? 00000020A ?ksbrdp()+923 call ksbabs() 7FFD0877D418 ? 000000058 ? 000000000 ? 000000001 ? 000000000 ? 00000020A ?opirip()+618 call ksbrdp() 7FFD0877D418 ? 000000058 ? 000000000 ? 000000001 ? 000000000 ? 00000020A ?opidrv()+598 call opirip() 000000032 ? 000000004 ? 7FFD0877E598 ? 000000001 ? 000000000 ? 00000020A ?sou2o()+98 call opidrv() 000000032 ? 000000004 ? 7FFD0877E598 ? 000000001 ? 000000000 ? 00000020A ?opimai_real()+261 call sou2o() 7FFD0877E570 ? 000000032 ? 000000004 ? 7FFD0877E598 ? 000000000 ? 00000020A ?ssthrdmain()+209 call opimai_real() 000000000 ? 7FFD0877E760 ? 000000004 ? 7FFD0877E598 ? 000000000 ? 00000020A ?main()+196 call ssthrdmain() 000000003 ? 7FFD0877E760 ? 000000001 ? 000000000 ? 000000000 ? 00000020A ?__libc_start_main() call main() 000000003 ? 7FFD0877E900 ?+253 000000001 ? 000000000 ? 000000000 ? 00000020A ?_start()+36 call __libc_start_main() 0009D3D94 ? 000000001 ? 7FFD0877E8F8 ? 000000000 ? 000000000 ? 00000020A ?虽然ORA-600 kkkicreatecgmap:!efn3没有见过但是数据库open过程中kgegpa、kgebse的故障还是遇到不少,大部分可能和undo有一定关系,处理undo问题之后,继续尝试open库,依旧报ORA-03113: end-of-file on communication channel
SQL> alter database Open;ERROR:ORA-03113: end-of-file on communication channelProcess ID: 20586Session ID: 191 Serial number: 3但是后台的alert日志已经改变ORA-600 4193,ORA-600 kkkicreatecgmap:!efn3错误
Mon Oct 20 18:54:39 2025Thread 1 advanced to log sequence 32121 (thread open)Thread 1 opened at log sequence 32121 Current log# 3 seq# 32121 mem# 0: /u01/oradata/redo03.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setMon Oct 20 18:54:39 2025SMON: enabling cache recoverySuccessfully onlined Undo Tablespace 2.Verifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryDatabase Characterset is ZHS16GBKErrors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_smon_20492.trc (incident=4905):ORA-00600: internal error code, arguments: , [], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/app/diag/rdbms/orcl/orcl/incident/incdir_4905/orcl_smon_20492_i4905.trcNo Resource Manager plan activeMon Oct 20 18:54:39 2025Errors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbrm_20478.trc (incident=4849):ORA-00600: internal error code, arguments: , , , [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/app/diag/rdbms/orcl/orcl/incident/incdir_4849/orcl_dbrm_20478_i4849.trcErrors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_dbrm_20478.trc:ORA-00600: internal error code, arguments: , , , [], [], [], [], [], [], [], [], []DBRM (ospid: 20478): terminating the instance due to error 56710Some DDE async actions failed or were cancelledErrors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_smon_20492.trc (incident=4906):ORA-00353: log corruption near block 8 change 17375938190767 time 10/03/2025 00:20:34ORA-00312: online log 1 thread 1: '/u01/oradata/redo01.log'ORA-00600: internal error code, arguments: , [], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/app/diag/rdbms/orcl/orcl/incident/incdir_4906/orcl_smon_20492_i4906.trcErrors in file /u01/app/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_smon_20492.trc:ORA-00354: corrupt redo log block headerORA-00353: log corruption near block 8 change 17375938190767 time 10/03/2025 00:20:34ORA-00312: online log 1 thread 1: '/u01/oradata/redo01.log'ORA-00600: internal error code, arguments: , [], [], [], [], [], [], [], [], [], [], []Instance terminated by DBRM, pid = 20478虽然ORA-600 kkkicreatecgmap:!efn3还在,但是看到了比较熟悉的ORA-600 4193错误,处理undo异常回滚段,数据库open成功,重建undo,尝试导出数据,完成数据恢复任务.
补充说明,对于ORA-00600: internal error code, arguments: , 网络上没有任何资料,查询了mos发现一个有一点类似的报错信息
Bug 28167557 – bigscn_dbim_tm_def – trc – kkkdchkcriticalobj – ORA-700 [kkkdchkcriticalob (Doc ID 28167557.8)
DescriptionInformation about new symptoms: - Signaling function: kkkdchkcriticalobj (kkkd.c)- Symptom: ORA-700 - Owner: SUELEE- Special Run: BIGSCN_DBIM_TM_DEF (owner: WAI-SZE.TAM, sr_id: 2709)- Release: 19.1- Job id: 22488605- Base label: RDBMS_MAIN_LINUX.X64_180607 ORA-600 ORA-600 kkkicreatecgmap:!group ORA-700 kkkdchkcriticalobj ORA-600 ORA-600 kkkicreatecgmap:!group ORA-700 kkkdchkcriticalobj REDISCOVERY INFORMATION: Symptoms are any of the following: ORA-600 ORA-600 kkkicreatecgmap:!group ORA-700 kkkdchkcriticalobj . WORKAROUND: None由于这个是硬件故障恢复出来的数据文件（涉及磁盘坏道，磁盘顺序，磁盘在raid中均衡,raid的cache等因素可能会一起Oracle各种非常规问题）,分析原因意义不大,重点是快速解决问题,不做过多分析
[*]云主机快照之后Oracle无法正常启动处理
[*]ORA-600 on shutdown
[*]dbca创建数据库报ORA-00443
[*]ORA-600 2131故障说明
[*]ORA-600与ORA-07445错误
[*]ORA-00600: internal error code, arguments:
[*]ORA-00600: internal error code, arguments:
[*]ORA-600 2032故障处理
[*]12.2 standby 报ORA-01110
[*]truncate table强制终止导致ORA-00600
[*]ORA-600 kcvent_internal_02故障处理
[*]ORA-600 kffmLoad_1 kffmVerify_4
来源：程序园用户自行投稿发布，如果侵权，请联系站长删除
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！ 感谢分享 不错，里面软件多更新就更好了 这个有用。 感谢分享
页:
[1]