ORA-600(4454)错误

客户数据库出席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中仍然可能出现。

This entry was posted in BUG and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *