联系:手机/微信(+86 17813235971) QQ(107644445)
标题:ORA-00600: internal error code, arguments: [1301]
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有网友数据库报ORA-00600: internal error code, arguments: [1301]错误,然后就crash.简单查mos发现是bug引起
数据库版本
Sun Jul 01 17:48:09 2018 ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0 vsnsql=14 vsnxtr=3 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V5.2 Service Pack 2 CPU : 32 - type 8664, 2 Physical Cores
alert日志报错
Sun Jul 01 17:48:09 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_pmon_98792.trc: ORA-00600: internal error code, arguments: [1301], [0x15CAEAF5C8], [11], [], [], [], [], [] Sun Jul 01 17:48:14 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_pmon_98792.trc: ORA-00600: internal error code, arguments: [1301], [0x15CAEAF5C8], [11], [], [], [], [], [] Sun Jul 01 17:48:14 2018 PMON: terminating instance due to error 472 Sun Jul 01 17:48:14 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_lgwr_98004.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:14 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_psp0_97900.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:15 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_dbw3_79724.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:16 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_dbw0_89896.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:16 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_ckpt_98468.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:16 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_dbw2_98348.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:17 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_j000_109140.trc: ORA-00472: PMON 进程因错误而终止 Sun Jul 01 17:48:17 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_dbw1_99112.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:17 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_mman_91488.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:48:53 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_q001_81352.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:50:59 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_reco_91716.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:50:59 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\bdump\xifenfei_smon_98428.trc: ORA-00472: PMON process terminated with error Sun Jul 01 17:51:02 2018 Instance terminated by PMON, pid = 98792
trace文件信息中的call stack信息
ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [1301], [0x15CAEAF5C8], [11], [], [], [], [], [] check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\xifenfei_ora_0.trc for preloading .sym file messages ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp+663 CALL??? ksedst+55 003C878B8 000000000 00C18CE58 000000000 ksfdmp+19 CALL??? ksedmp+663 000000003 009BE3650 00BD10040 003CACC80 kgeriv+184 CALL??? ksfdmp+19 000000001 000000037 15CAEAF5C8 13CA54BB60 kgesiv+102 CALL??? kgeriv+184 003C8735C 000000001 0000003BC 15CA0562E0 ksesic2+125 CALL??? kgesiv+102 00000000A 15CAEAF5C8 15CF809B88 00042965C ksuxdp+652 CALL??? ksesic2+125 000000515 000000002 15CAEAF5C8 000000000 ksuxdpg+114 CALL??? ksuxdp+652 000000000 0080D5698 76CCBF8BD519 009BE3010 ksucln+2458 CALL??? ksuxdpg+114 000000003 000000000 00BD3DC60 000000048 ksbrdp+903 CALL??? ksucln+2458 0049B7760 0049B777C 000000002 000000005 opirip+700 CALL??? ksbrdp+903 726F77740000001E 003C8B000 00C18FA50 000000000 opidrv+860 CALL??? opirip+700 000000032 000000004 00C18FD70 000000000 sou2o+52 CALL??? opidrv+860 000000032 000000004 00C18FD70 000000003 opimai_real+272 CALL??? sou2o+52 000000000 0076C0000 000040000 000000000 opimai+96 CALL??? opimai_real+272 000000000 000000000 000000000 000000000 BackgroundThreadSta CALL??? opimai+96 00C18FEC8 000000001 000000000 rt+633 000000000 0000000078D3B71A CALL??? BackgroundThreadSta D65F12CF0 000000000 000000000 rt+633 00C18FFA8
基本上可以定位因为Bug 7294679 – ORA-600 [1301] – INSTANCE TERMINATED BY PMON 原因导致pmon无法完全正常清理被kill掉的session而引起pmon异常从而使得数据库crash.在10.2.0.5和11.2.0.1版本之前alter system kill session 请谨慎,还有类似因为kill session导致 ORA-00600 [1113]的错误.
参考文档:ORA-00600 [1301] – Instance Terminated by PMON After Killing Sessions (Doc ID 737561.1)
ORA-00600 [1113] Instance Termination When Killing Sessions (Doc ID 561322.1)