联系：手机/微信(+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)