{"id":565,"date":"2012-02-13T23:02:10","date_gmt":"2012-02-13T15:02:10","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=565"},"modified":"2012-02-14T23:03:04","modified_gmt":"2012-02-14T15:03:04","slug":"ora-6004454%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=565","title":{"rendered":"ORA-600(4454)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u5e2dORA-600[4454]\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Fri Feb 10 18:43:57 2012\r\nErrors in file \/oracle9\/app\/admin\/settl\/udump\/settl1_ora_1667162.trc:\r\nORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], []\r\nFri Feb 10 18:43:58 2012\r\nErrors in file \/oracle9\/app\/admin\/settl\/udump\/settl1_ora_1667162.trc:\r\nORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], []<\/pre>\n<p>\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** SESSION ID:(100.63267) 2012-02-10 18:43:57.789\r\n*** 2012-02-10 18:43:57.789\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [4454], [], [], [], [], [], [], []\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp+0148          bl       ksedst               1029746CC ?\r\nksfdmp+0018          bl       01FD4010             \r\nkgeriv+0118          bl       _ptrgl               \r\nkgeasi+00cc          bl       kgeriv               1103C7470 ? 1103C7430 ?\r\n                                                   1103C7450 ? 000000000 ?\r\n                                                   FFFFFFFFFFFA9B8 ?\r\nktcsptg+00c4         bl       kgeasi               1100062D8 ? 110389E88 ?\r\n                                                   116600001166 ? 200000002 ?\r\n                                                   000000000 ? 70000010738F0E8 ?\r\n                                                   0FFFFFFFF ? 0FFFFFFFF ?\r\nksupucg+1834         bl       ktcsptg              000000000 ? 000000000 ?\r\nopiodr+0474          bl       ksupucg              100000001 ?\r\nttcpip+0cc4          bl       _ptrgl               \r\nopitsk+0d60          bl       ttcpip               11000CF60 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\nopiino+0758          bl       opitsk               000000000 ? 000000000 ?\r\nopiodr+08cc          bl       _ptrgl               \r\nopidrv+032c          bl       opiodr               3C00000018 ? 4101FAF48 ?\r\n                                                   FFFFFFFFFFFF790 ? 0A000EEA8 ?\r\nsou2o+0028           bl       opidrv               3C0C000000 ? 4A0147B50 ?\r\n                                                   FFFFFFFFFFFF790 ?\r\nmain+0138            bl       01FD3A28             \r\n__start+0098         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------\r\n.\r\n.\r\n.\r\n===================================================\r\nFiles currently opened by this process:\r\n===================================================\r\nPROCESS STATE\r\n-------------\r\nProcess global information:\r\n     process: 7000001043a07d8, call: 70000011126cab8, xact: 70000010dd8de90, curses: 70000010738f0e8, usrses: 70000010738f0e8\r\n  ----------------------------------------\r\n  SO: 7000001043a07d8, type: 2, owner: 0, flag: INIT\/-\/-\/0x00\r\n  (process) Oracle pid=63, calls cur\/top: 70000011126cab8\/70000011126cab8, flag: (0) -\r\n            int error: 0, call error: 0, sess error: 0, txn error 0\r\n  (post info) last post received: 0 0 50\r\n              last post received-location: kcbzww\r\n              last process to post me: 7000001043a1288 32 0\r\n              last post sent: 789830 0 50\r\n              last post sent-location: kcbzww\r\n              last process posted by me: 700000104398798 1 0\r\n    (latch info) wait_event=0 bits=0\r\n    Process Group: DEFAULT, pseudo proc: 70000010537bfc8\r\n    O\/S info: user: oracle9, term: UNKNOWN, ospid: 1667162\r\n    OSD pid info: Unix process pid: 1667162, image: oracle@zwq_jies1 (TNS V1-V3)\r\n    ----------------------------------------\r\n    SO: 7000001150d3e80, type: 8, owner: 7000001043a07d8, flag: INIT\/-\/-\/0x00\r\n    (FOB) flags=2 fib ptr=138c9638 incno=0 pending i\/o cnt=0\r\n    ----------------------------------------\r\n    SO: 7000001150d3dc8, type: 8, owner: 7000001043a07d8, flag: INIT\/-\/-\/0x00\r\n    (FOB) flags=2 fib ptr=138c7908 incno=0 pending i\/o cnt=0\r\n    ----------------------------------------\r\n    SO: 7000001150d3d10, type: 8, owner: 7000001043a07d8, flag: INIT\/-\/-\/0x00\r\n    (FOB) flags=2 fib ptr=138c9468 incno=0 pending i\/o cnt=0\r\n    ----------------------------------------\r\n    SO: 7000001150d3c58, type: 8, owner: 7000001043a07d8, flag: INIT\/-\/-\/0x00\r\n    (FOB) flags=2 fib ptr=138c6e10 incno=1 pending i\/o cnt=0\r\n    ----------------------------------------\r\n    SO: 70000010738f0e8, type: 4, owner: 7000001043a07d8, flag: INIT\/-\/-\/0x00\r\n    (session) trans: 70000010dd8de90, creator: 7000001043a07d8, flag: (100041) USR\/- BSY\/-\/-\/-\/-\/-\r\n              DID: 0001-003F-00002EDF, short-term DID: 0000-0000-00000000\r\n              txn branch: 7000001147dbed8\r\n              oct: 0, prv: 0, sql: 0, psql: 700000117b7f778, user: 24\/SETTLE\r\n    O\/S info: user: settle, term: , ospid: 1056780, machine: zwq_jies2\r\n              program: \/settlement\/pkg01\/bin\/long\/long_app@zwq_jies2 (T\r\n    application name: \/settlement\/pkg01\/bin\/long\/long_app@zwq_jies2 (T, hash value=0\r\n    last wait for 'SQL*Net message from client' blocking sess=0x0 seq=19236 wait_time=220\r\n                driver id=54435000, #bytes=1, =0\r\n    temporary object counter: 0\r\n      ----------------------------------------\r\n      SO: 70000010644cf68, type: 6, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      (enqueue) DX-00000007-00000000\tDID: 0001-003F-40019DB5\r\n      lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 \r\n      res: 70000010545ea28, mode: X, prv: 70000010545ea38, sess: 70000010738f0e8, proc: 7000001043a07d8\r\n      ----------------------------------------\r\n      SO: 700000117488008, type: 51, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=700000117488008 handle=70000011bfe6650 mode=N\r\n      call pin=0 session pin=700000129bb44e0\r\n      htl=700000117488078[7000001122c7900,7000001122c7900] htb=7000001122c7900\r\n      user=70000010738f0e8 session=70000010738f0e8 count=1 flags=[00] savepoint=126982\r\n      LIBRARY OBJECT HANDLE: handle=70000011bfe6650\r\n      namespace=CRSR flags=RON\/KGHP\/PN0\/[10010000]\r\n      kkkk-dddd-llll=0000-0001-0041 lock=N pin=0 latch#=16\r\n      lwt=70000011bfe6680[70000011bfe6680,70000011bfe6680] ltm=70000011bfe6690[70000011bfe6690,70000011bfe6690]\r\n      pwt=70000011bfe66b0[70000011bfe66b0,70000011bfe66b0] ptm=70000011bfe6740[70000011bfe6740,70000011bfe6740]\r\n      ref=70000011bfe6660[70000011bfe6a68, 70000011bfe6a68] lnd=70000011bfe6758[70000011bfe6758,70000011bfe6758]\r\n        LIBRARY OBJECT: object=70000011bfe6278\r\n        type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0\r\n        DEPENDENCIES: count=1 size=16\r\n        AUTHORIZATIONS: count=1 size=16 minimum entrysize=16\r\n        ACCESSES: count=1 size=16\r\n        TRANSLATIONS: count=1 size=16\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 70000011bfe6590 70000011bfe5f00 I\/P\/A     0 NONE  \r\n            6 70000011bfe6398        0 I\/P\/-     0 NONE  \r\n      ----------------------------------------\r\n      SO: 700000113f7d738, type: 51, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=700000113f7d738 handle=70000011bfe6f10 mode=N\r\n      call pin=7000001113b2e20 session pin=0\r\n      htl=700000113f7d7a8[7000001122c8030,7000001122c8030] htb=7000001122c8030\r\n      user=70000010738f0e8 session=70000010738f0e8 count=1 flags=[00] savepoint=126981\r\n      LIBRARY OBJECT HANDLE: handle=70000011bfe6f10\r\n      name=select trim(fee_type) ,trim(fee_dir) ,trim(fee_rate) ,trim(rate_unit)  from app_clearing_fee_rate  order by fee_type asc             \r\n      hash=336a54ce timestamp=01-17-2012 17:46:10\r\n      namespace=CRSR flags=RON\/KGHP\/TIM\/PN0\/MED\/[50010000]\r\n      kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=16\r\n      lwt=70000011bfe6f40[70000011bfe6f40,70000011bfe6f40] ltm=70000011bfe6f50[70000011bfe6f50,70000011bfe6f50]\r\n      pwt=70000011bfe6f70[70000011bfe6f70,70000011bfe6f70] ptm=70000011bfe7000[70000011bfe7000,70000011bfe7000]\r\n      ref=70000011bfe6f20[70000011bfe6f20, 70000011bfe6f20] lnd=70000011bfe7018[70000011bfe7018,70000011bfe7018]\r\n        LIBRARY OBJECT: object=70000011bfe6b38\r\n        type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0\r\n        CHILDREN: size=16\r\n        child#    table reference   handle\r\n        ------ -------- --------- --------\r\n             0 70000011bfe6d98 70000011bfe6a68 70000011bfe6650\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 70000011bfe6e50 70000011bfe6c30 I\/P\/A     0 NONE  \r\n      ----------------------------------------\r\n.\r\n.\r\n.\r\n      ----------------------------------------\r\n      SO: 700000111208478, type: 51, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=700000111208478 handle=700000119951970 mode=N\r\n      call pin=7000001171fea08 session pin=0\r\n      htl=7000001112084e8[7000001122c76a0,7000001122c76a0] htb=7000001122c76a0\r\n      user=70000010738f0e8 session=70000010738f0e8 count=1 flags=[00] savepoint=125499\r\n      LIBRARY OBJECT HANDLE: handle=700000119951970\r\n      name=select count(*)  into :b1  from app_msc_default \r\n      hash=1042c435 timestamp=01-17-2012 17:46:09\r\n      namespace=CRSR flags=RON\/KGHP\/TIM\/PN0\/SML\/[12010000]\r\n      kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=6\r\n      lwt=7000001199519a0[7000001199519a0,7000001199519a0] ltm=7000001199519b0[7000001199519b0,7000001199519b0]\r\n      pwt=7000001199519d0[7000001199519d0,7000001199519d0] ptm=700000119951a60[700000119951a60,700000119951a60]\r\n      ref=700000119951980[700000119951980, 700000119951980] lnd=700000119951a78[700000119951a78,700000119951a78]\r\n        LIBRARY OBJECT: object=7000001199516a8\r\n        type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0\r\n        CHILDREN: size=16\r\n        child#    table reference   handle\r\n        ------ -------- --------- --------\r\n             0 700000119936450 7000001199361b8 700000119936048\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 7000001199518b0 7000001199517a0 I\/P\/A     0 NONE  \r\n      ----------------------------------------\r\n      SO: 700000114c02960, type: 51, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=700000114c02960 handle=700000118a36ab0 mode=N\r\n      call pin=0 session pin=7000001126e7a20\r\n      htl=700000114c029d0[7000001122c8230,7000001122c8230] htb=7000001122c8230\r\n      user=70000010738f0e8 session=70000010738f0e8 count=1 flags=[00] savepoint=873\r\n      LIBRARY OBJECT HANDLE: handle=700000118a36ab0\r\n      namespace=CRSR flags=RON\/KGHP\/PN0\/[10010000]\r\n      kkkk-dddd-llll=0000-0001-0041 lock=N pin=0 latch#=7\r\n      lwt=700000118a36ae0[700000118a36ae0,700000118a36ae0] ltm=700000118a36af0[700000118a36af0,700000118a36af0]\r\n      pwt=700000118a36b10[700000118a36b10,700000118a36b10] ptm=700000118a36ba0[700000118a36ba0,700000118a36ba0]\r\n      ref=700000118a36ac0[700000118a36ec8, 700000118a36ec8] lnd=700000118a36bb8[700000118a36bb8,700000118a36bb8]\r\n        LIBRARY OBJECT: object=700000118a366d8\r\n        type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0\r\n        DEPENDENCIES: count=1 size=16\r\n        AUTHORIZATIONS: count=1 size=16 minimum entrysize=16\r\n        ACCESSES: count=1 size=16\r\n        TRANSLATIONS: count=1 size=16\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 700000118a369f0 700000118a36360 I\/P\/A     0 NONE  \r\n            6 700000118a367f8        0 I\/P\/-     0 NONE  \r\n      ----------------------------------------\r\n      SO: 700000114c025a8, type: 51, owner: 70000010738f0e8, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=700000114c025a8 handle=700000118a37370 mode=N\r\n      call pin=70000011226a160 session pin=0\r\n      htl=700000114c02618[7000001122c76f0,7000001122c76f0] htb=7000001122c76f0\r\n      user=70000010738f0e8 session=70000010738f0e8 count=1 flags=[00] savepoint=854\r\n      LIBRARY OBJECT HANDLE: handle=700000118a37370\r\n      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)))            \r\n      hash=2238ad3a timestamp=01-17-2012 17:45:01\r\n      namespace=CRSR flags=RON\/KGHP\/TIM\/PN0\/MED\/[50010000]\r\n      kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=7\r\n      lwt=700000118a373a0[700000118a373a0,700000118a373a0] ltm=700000118a373b0[700000118a373b0,700000118a373b0]\r\n      pwt=700000118a373d0[700000118a373d0,700000118a373d0] ptm=700000118a37460[700000118a37460,700000118a37460]\r\n      ref=700000118a37380[700000118a37380, 700000118a37380] lnd=700000118a37478[700000118a37478,700000118a37478]\r\n        LIBRARY OBJECT: object=700000118a36f98\r\n        type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0\r\n        CHILDREN: size=16\r\n        child#    table reference   handle\r\n        ------ -------- --------- --------\r\n             0 700000118a371f8 700000118a36ec8 700000118a36ab0\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 700000118a372b0 700000118a37090 I\/P\/A     0 NONE  \r\n      ----------------------------------------<\/pre>\n<p>\u67e5\u8be2MOS\u53d1\u73b0\uff0c\u8fd9\u4e2a\u9519\u8bef\u548cBug 1402161 &#8211; OERI:4411\/OERI:4454 on long running job [ID 1402161.8]\u63cf\u8ff0\u7684\u5341\u5206\u76f8\u8fd1\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u7531\u4e8eSAVEPOINT\u4fe1\u606f\u88ab\u8986\u76d6\uff0c\u5bfc\u81f4\u4f1a\u8bdd\u5f02\u5e38\u3002<br \/>\n\u867d\u7136\u8fd9\u4e2a\u9519\u8bef\u786e\u8ba4\u57289.2.0.1\u4e2d\u88ab\u4fee\u6b63\uff0c\u7406\u8bba\u4e0a\u57289.2.0.8\u4e2d\u51fa\u73b0\u7684\u6982\u7387\u5f88\u4f4e\uff0c\u4e0d\u8fc7\u53c2\u8003\u6587\u6863Large SQL Statement or Import Fails With ORA-600 [4454] [ID 353190.1]\u63cf\u8ff0\u7684\u5185\u5bb9\uff0cOracle\u572810.2\u4e2d\u624d\u5f7b\u5e95\u6539\u53d8\u4e86\u5185\u90e8SAVEPOINT\u7684\u5b9e\u73b0\uff0c\u56e0\u6b64\u8fd9\u4e2a\u95ee\u9898\u57289.2\u548c10.1\u4e2d\u4ecd\u7136\u53ef\u80fd\u51fa\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u5e2dORA-600[4454]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a 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], [], &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=565\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[456,8,457],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-97","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/565"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=565"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/565\/revisions"}],"predecessor-version":[{"id":567,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/565\/revisions\/567"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}