ORA-600(4454)错误

最新推荐文章于 2021-05-15 01:58:01 发布

ckawt40802

最新推荐文章于 2021-05-15 01:58:01 发布

阅读量186

点赞数

文章标签：数据库

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