客户数据库出席ORA-600[4454]错误。
错误信息如下：
Fri Feb 10 18:43:57 2012 Errors IN file /oracle9/app/admin/settl/udump/settl1_ora_1667162.trc: ORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], [] Fri Feb 10 18:43:58 2012 Errors IN file /oracle9/app/admin/settl/udump/settl1_ora_1667162.trc: ORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], [] |
对应的TRACE文件信息为：
*** SESSION ID:(100.63267) 2012-02-10 18:43:57.789 *** 2012-02-10 18:43:57.789 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], [] ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedmp+0148 bl ksedst 1029746CC ? ksfdmp+0018 bl 01FD4010 kgeriv+0118 bl _ptrgl kgeasi+00cc bl kgeriv 1103C7470 ? 1103C7430 ? 1103C7450 ? 000000000 ? FFFFFFFFFFFA9B8 ? ktcsptg+00c4 bl kgeasi 1100062D8 ? 110389E88 ? 116600001166 ? 200000002 ? 000000000 ? 70000010738F0E8 ? 0FFFFFFFF ? 0FFFFFFFF ? ksupucg+1834 bl ktcsptg 000000000 ? 000000000 ? opiodr+0474 bl ksupucg 100000001 ? ttcpip+0cc4 bl _ptrgl opitsk+0d60 bl ttcpip 11000CF60 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? opiino+0758 bl opitsk 000000000 ? 000000000 ? opiodr+08cc bl _ptrgl opidrv+032c bl opiodr 3C00000018 ? 4101FAF48 ? FFFFFFFFFFFF790 ? 0A000EEA8 ? sou2o+0028 bl opidrv 3C0C000000 ? 4A0147B50 ? FFFFFFFFFFFF790 ? main+0138 bl 01FD3A28 __start+0098 bl main 000000000 ? 000000000 ? --------------------- Binary Stack Dump --------------------- . . . =================================================== Files currently opened BY this process: =================================================== PROCESS STATE ------------- Process global information: process: 7000001043a07d8, CALL: 70000011126cab8, xact: 70000010dd8de90, curses: 70000010738f0e8, usrses: 70000010738f0e8 ---------------------------------------- SO: 7000001043a07d8, TYPE: 2, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=63, calls cur/top: 70000011126cab8/70000011126cab8, flag: (0) - INT error: 0, CALL error: 0, sess error: 0, txn error 0 (post info) LAST post received: 0 0 50 LAST post received-location: kcbzww LAST process TO post me: 7000001043a1288 32 0 LAST post sent: 789830 0 50 LAST post sent-location: kcbzww LAST process posted BY me: 700000104398798 1 0 (latch info) wait_event=0 bits=0 Process GROUP: DEFAULT, pseudo proc: 70000010537bfc8 O/S info: USER: oracle9, term: UNKNOWN, ospid: 1667162 OSD pid info: Unix process pid: 1667162, image: oracle@zwq_jies1 (TNS V1-V3) ---------------------------------------- SO: 7000001150d3e80, TYPE: 8, owner: 7000001043a07d8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=138c9638 incno=0 pending i/o cnt=0 ---------------------------------------- SO: 7000001150d3dc8, TYPE: 8, owner: 7000001043a07d8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=138c7908 incno=0 pending i/o cnt=0 ---------------------------------------- SO: 7000001150d3d10, TYPE: 8, owner: 7000001043a07d8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=138c9468 incno=0 pending i/o cnt=0 ---------------------------------------- SO: 7000001150d3c58, TYPE: 8, owner: 7000001043a07d8, flag: INIT/-/-/0x00 (FOB) flags=2 fib ptr=138c6e10 incno=1 pending i/o cnt=0 ---------------------------------------- SO: 70000010738f0e8, TYPE: 4, owner: 7000001043a07d8, flag: INIT/-/-/0x00 (SESSION) trans: 70000010dd8de90, creator: 7000001043a07d8, flag: (100041) USR/- BSY/-/-/-/-/- DID: 0001-003F-00002EDF, short-term DID: 0000-0000-00000000 txn branch: 7000001147dbed8 oct: 0, prv: 0, SQL: 0, psql: 700000117b7f778, USER: 24/SETTLE O/S info: USER: settle, term: , ospid: 1056780, machine: zwq_jies2 program: /settlement/pkg01/bin/long/long_app@zwq_jies2 (T application name: /settlement/pkg01/bin/long/long_app@zwq_jies2 (T, hash VALUE=0 LAST wait FOR 'SQL*Net message from client' blocking sess=0x0 seq=19236 wait_time=220 driver id=54435000, #bytes=1, =0 TEMPORARY object counter: 0 ---------------------------------------- SO: 70000010644cf68, TYPE: 6, owner: 70000010738f0e8, flag: INIT/-/-/0x00 (enqueue) DX-00000007-00000000 DID: 0001-003F-40019DB5 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res: 70000010545ea28, mode: X, prv: 70000010545ea38, sess: 70000010738f0e8, proc: 7000001043a07d8 ---------------------------------------- SO: 700000117488008, TYPE: 51, owner: 70000010738f0e8, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: LOCK=700000117488008 handle=70000011bfe6650 mode=N CALL pin=0 SESSION pin=700000129bb44e0 htl=700000117488078[7000001122c7900,7000001122c7900] htb=7000001122c7900 USER=70000010738f0e8 SESSION=70000010738f0e8 COUNT=1 flags=[00] SAVEPOINT=126982 LIBRARY OBJECT HANDLE: handle=70000011bfe6650 namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0001-0041 LOCK=N pin=0 latch#=16 lwt=70000011bfe6680[70000011bfe6680,70000011bfe6680] ltm=70000011bfe6690[70000011bfe6690,70000011bfe6690] pwt=70000011bfe66b0[70000011bfe66b0,70000011bfe66b0] ptm=70000011bfe6740[70000011bfe6740,70000011bfe6740] REF=70000011bfe6660[70000011bfe6a68, 70000011bfe6a68] lnd=70000011bfe6758[70000011bfe6758,70000011bfe6758] LIBRARY OBJECT: object=70000011bfe6278 TYPE=CRSR flags=EXS[0001] pflags= [00] STATUS=VALD LOAD=0 DEPENDENCIES: COUNT=1 SIZE=16 AUTHORIZATIONS: COUNT=1 SIZE=16 minimum entrysize=16 ACCESSES: COUNT=1 SIZE=16 TRANSLATIONS: COUNT=1 SIZE=16 DATA BLOCKS: DATA# heap pointer STATUS pins CHANGE ----- -------- -------- ------ ---- ------ 0 70000011bfe6590 70000011bfe5f00 I/P/A 0 NONE 6 70000011bfe6398 0 I/P/- 0 NONE ---------------------------------------- SO: 700000113f7d738, TYPE: 51, owner: 70000010738f0e8, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: LOCK=700000113f7d738 handle=70000011bfe6f10 mode=N CALL pin=7000001113b2e20 SESSION pin=0 htl=700000113f7d7a8[7000001122c8030,7000001122c8030] htb=7000001122c8030 USER=70000010738f0e8 SESSION=70000010738f0e8 COUNT=1 flags=[00] SAVEPOINT=126981 LIBRARY OBJECT HANDLE: handle=70000011bfe6f10 name=SELECT TRIM(fee_type) ,TRIM(fee_dir) ,TRIM(fee_rate) ,TRIM(rate_unit) FROM app_clearing_fee_rate ORDER BY fee_type ASC hash=336a54ce TIMESTAMP=01-17-2012 17:46:10 namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000] kkkk-dddd-llll=0000-0001-0001 LOCK=N pin=0 latch#=16 lwt=70000011bfe6f40[70000011bfe6f40,70000011bfe6f40] ltm=70000011bfe6f50[70000011bfe6f50,70000011bfe6f50] pwt=70000011bfe6f70[70000011bfe6f70,70000011bfe6f70] ptm=70000011bfe7000[70000011bfe7000,70000011bfe7000] REF=70000011bfe6f20[70000011bfe6f20, 70000011bfe6f20] lnd=70000011bfe7018[70000011bfe7018,70000011bfe7018] LIBRARY OBJECT: object=70000011bfe6b38 TYPE=CRSR flags=EXS[0001] pflags= [00] STATUS=VALD LOAD=0 CHILDREN: SIZE=16 child# TABLE reference handle ------ -------- --------- -------- 0 70000011bfe6d98 70000011bfe6a68 70000011bfe6650 DATA BLOCKS: DATA# heap pointer STATUS pins CHANGE ----- -------- -------- ------ ---- ------ 0 70000011bfe6e50 70000011bfe6c30 I/P/A 0 NONE ---------------------------------------- . . . ---------------------------------------- SO: 700000111208478, TYPE: 51, owner: 70000010738f0e8, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: LOCK=700000111208478 handle=700000119951970 mode=N CALL pin=7000001171fea08 SESSION pin=0 htl=7000001112084e8[7000001122c76a0,7000001122c76a0] htb=7000001122c76a0 USER=70000010738f0e8 SESSION=70000010738f0e8 COUNT=1 flags=[00] SAVEPOINT=125499 LIBRARY OBJECT HANDLE: handle=700000119951970 name=SELECT COUNT(*) INTO :b1 FROM app_msc_default hash=1042c435 TIMESTAMP=01-17-2012 17:46:09 namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000] kkkk-dddd-llll=0000-0001-0001 LOCK=N pin=0 latch#=6 lwt=7000001199519a0[7000001199519a0,7000001199519a0] ltm=7000001199519b0[7000001199519b0,7000001199519b0] pwt=7000001199519d0[7000001199519d0,7000001199519d0] ptm=700000119951a60[700000119951a60,700000119951a60] REF=700000119951980[700000119951980, 700000119951980] lnd=700000119951a78[700000119951a78,700000119951a78] LIBRARY OBJECT: object=7000001199516a8 TYPE=CRSR flags=EXS[0001] pflags= [00] STATUS=VALD LOAD=0 CHILDREN: SIZE=16 child# TABLE reference handle ------ -------- --------- -------- 0 700000119936450 7000001199361b8 700000119936048 DATA BLOCKS: DATA# heap pointer STATUS pins CHANGE ----- -------- -------- ------ ---- ------ 0 7000001199518b0 7000001199517a0 I/P/A 0 NONE ---------------------------------------- SO: 700000114c02960, TYPE: 51, owner: 70000010738f0e8, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: LOCK=700000114c02960 handle=700000118a36ab0 mode=N CALL pin=0 SESSION pin=7000001126e7a20 htl=700000114c029d0[7000001122c8230,7000001122c8230] htb=7000001122c8230 USER=70000010738f0e8 SESSION=70000010738f0e8 COUNT=1 flags=[00] SAVEPOINT=873 LIBRARY OBJECT HANDLE: handle=700000118a36ab0 namespace=CRSR flags=RON/KGHP/PN0/[10010000] kkkk-dddd-llll=0000-0001-0041 LOCK=N pin=0 latch#=7 lwt=700000118a36ae0[700000118a36ae0,700000118a36ae0] ltm=700000118a36af0[700000118a36af0,700000118a36af0] pwt=700000118a36b10[700000118a36b10,700000118a36b10] ptm=700000118a36ba0[700000118a36ba0,700000118a36ba0] REF=700000118a36ac0[700000118a36ec8, 700000118a36ec8] lnd=700000118a36bb8[700000118a36bb8,700000118a36bb8] LIBRARY OBJECT: object=700000118a366d8 TYPE=CRSR flags=EXS[0001] pflags= [00] STATUS=VALD LOAD=0 DEPENDENCIES: COUNT=1 SIZE=16 AUTHORIZATIONS: COUNT=1 SIZE=16 minimum entrysize=16 ACCESSES: COUNT=1 SIZE=16 TRANSLATIONS: COUNT=1 SIZE=16 DATA BLOCKS: DATA# heap pointer STATUS pins CHANGE ----- -------- -------- ------ ---- ------ 0 700000118a369f0 700000118a36360 I/P/A 0 NONE 6 700000118a367f8 0 I/P/- 0 NONE ---------------------------------------- SO: 700000114c025a8, TYPE: 51, owner: 70000010738f0e8, flag: INIT/-/-/0x00 LIBRARY OBJECT LOCK: LOCK=700000114c025a8 handle=700000118a37370 mode=N CALL pin=70000011226a160 SESSION pin=0 htl=700000114c02618[7000001122c76f0,7000001122c76f0] htb=7000001122c76f0 USER=70000010738f0e8 SESSION=70000010738f0e8 COUNT=1 flags=[00] SAVEPOINT=854 LIBRARY OBJECT HANDLE: handle=700000118a37370 name=SELECT ltrim(rtrim(h1h2h3h4)) ,ltrim(rtrim(long_code_new)) ,ltrim(rtrim(settle_type)) FROM b_h1h2h3_code_allocate ORDER BY LENGTH(ltrim(rtrim(h1h2h3h4))) hash=2238ad3a TIMESTAMP=01-17-2012 17:45:01 namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000] kkkk-dddd-llll=0000-0001-0001 LOCK=N pin=0 latch#=7 lwt=700000118a373a0[700000118a373a0,700000118a373a0] ltm=700000118a373b0[700000118a373b0,700000118a373b0] pwt=700000118a373d0[700000118a373d0,700000118a373d0] ptm=700000118a37460[700000118a37460,700000118a37460] REF=700000118a37380[700000118a37380, 700000118a37380] lnd=700000118a37478[700000118a37478,700000118a37478] LIBRARY OBJECT: object=700000118a36f98 TYPE=CRSR flags=EXS[0001] pflags= [00] STATUS=VALD LOAD=0 CHILDREN: SIZE=16 child# TABLE reference handle ------ -------- --------- -------- 0 700000118a371f8 700000118a36ec8 700000118a36ab0 DATA BLOCKS: DATA# heap pointer STATUS pins CHANGE ----- -------- -------- ------ ---- ------ 0 700000118a372b0 700000118a37090 I/P/A 0 NONE ---------------------------------------- |
查询MOS发现，这个错误和Bug 1402161 – OERI:4411/OERI:4454 on long running job [ID 1402161.8]描述的十分相近，导致问题的原因是由于SAVEPOINT信息被覆盖，导致会话异常。
虽然这个错误确认在9.2.0.1中被修正，理论上在9.2.0.8中出现的概率很低，不过参考文档Large SQL Statement or Import Fails With ORA-600 [4454] [ID 353190.1]描述的内容，Oracle在10.2中才彻底改变了内部SAVEPOINT的实现，因此这个问题在9.2和10.1中仍然可能出现。