{"id":1357,"date":"2012-11-06T23:20:02","date_gmt":"2012-11-06T15:20:02","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1357"},"modified":"2013-07-09T00:26:41","modified_gmt":"2013-07-08T16:26:41","slug":"ora-7445ksfd_odmwat%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1357","title":{"rendered":"ORA-7445(ksfd_odmwat)\u9519\u8bef"},"content":{"rendered":"<p>Oracle 9206 RAC\u73af\u5883\u8bbf\u95eeLOGMINER\u89c6\u56fe\u65f6\u62a5\u9519\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>Wed Aug 10 17:06:37 2011\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl2_ora_20704.trc:\r\nORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []\r\nWed Aug 10 17:07:22 2011\r\nTrace dumping is performing id=[cdmp_20110810170722]<\/pre>\n<p>\u5bf9\u5e94\u7684TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>*** 2011-08-10 17:06:37.463\r\n*** SESSION ID:(49.28760) 2011-08-10 17:06:37.461\r\nException signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8, PC: [0x10069ab88, 000000010069AB88]\r\n*** 2011-08-10 17:06:37.463\r\nksedmp: internal or fatal error\r\nORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []\r\nCurrent SQL statement for this session:\r\nselect count(*) from v$logmnr_contents\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?\r\n                                                   000000000 ? 00000004A ?\r\n                                                   FFFFFFFF7FFF0658 ?\r\n                                                   1032E18E8 ?\r\nssexhd()+676         CALL     ksedmp()             000103705 ? 103705000 ?\r\n                                                   103705468 ? 10370A000 ?\r\n                                                   000102C00 ? 000000000 ?\r\nsigacthandler()+44   PTR_CALL 0000000000000000     00010370D ?\r\n                                                   FFFFFFFF7FFF76F0 ?\r\n                                                   10370D000 ? 10370A620 ?\r\n                                                   000000000 ? 10370D578 ?\r\nksfd_odmwat()+968    PTR_CALL 0000000000000000     00000000B ?\r\n                                                   FFFFFFFF7FFF76F0 ?\r\n                                                   FFFFFFFF7FFF7410 ?\r\n                                                   000004400 ? 000103400 ?\r\n                                                   00000000E ?\r\nksfdwtio()+812       CALL     ksfd_odmwat()        FFFFFFFF7B7E63A8 ?\r\n                                                   000000000 ? 1037077D4 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   0FFFFFFFB ?\r\nksfdwat1()+64        CALL     ksfdwtio()           38000A800 ? 1037077D4 ?\r\n                                                   380011054 ? 000000000 ?\r\n                                                   0FFFFFFFB ? 01CBA91A7 ?\r\nksfdrwat0()+212      CALL     ksfdwat1()           0FFFFFFFB ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   10370A000 ? 00000FC00 ?\r\nkcrfais()+752        CALL     ksfdwat()            38000A000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   00000001B ? 10370AA10 ?\r\nkcrfdr()+292         CALL     kcrfais()            FFFFFFFF7B7E1478 ?\r\n                                                   FFFFFFFF7B7E1400 ?\r\n                                                   FFFFFFFF7B7E1210 ?\r\n                                                   000000800 ? 000002002 ?\r\n                                                   FFFFFFFF7FFF9D7C ?\r\nkcrfrgv()+452        CALL     kcrfdr()             FFFFFFFF7B7E10F0 ?\r\n                                                   FFFFFFFF7B7E1168 ?\r\n                                                   000000040 ? 000103400 ?\r\n                                                   00010370B ? 000000002 ?\r\nkrvxrgr_GetRedo()+1  CALL     kcrfrgv()            FFFFFFFF7B7E10F0 ?\r\n04                                                 0000002D0 ? 0000002D0 ?\r\n                                                   000000080 ? 000000000 ?\r\n                                                   00000FC00 ?\r\nkrvxror_ReadOneReco  CALL     krvxrgr_GetRedo()    FFFFFFFF7B7E6818 ?\r\nrd()+1284                                          FFFFFFFF7B7E10F0 ?\r\n                                                   FFFFFFFF7FFFB018 ?\r\n                                                   FFFFFFFF7B7E10E0 ?\r\n                                                   1033E7E98 ? 1033E7E88 ?\r\nkrvxread()+432       CALL     krvxror_ReadOneReco  FFFFFFFF7B7E10E0 ?\r\n                              rd()                 FFFFFFFF7B7E3118 ?\r\n                                                   FFFFFFFF7B7E2F90 ?\r\n                                                   000000007 ?\r\n                                                   FFFFFFFF7FFFB910 ?\r\n                                                   000000000 ?\r\nkrvxgtsp_GetTxnSing  CALL     krvxread()           FFFFFFFF7B7E6818 ?\r\nleProcess()+28                                     000000000 ? 000000000 ?\r\n                                                   0990FD824 ? 000000000 ?\r\n                                                   FFFFFFFF7B7E2F90 ?\r\nkrvxgt()+604         CALL     krvxgtsp_GetTxnSing  FFFFFFFF7B7E6818 ?\r\n                              leProcess()          000000000 ? 103708000 ?\r\n                                                   FFFFFFFFFFFFFFFF ?\r\n                                                   000000000 ? 000000000 ?\r\nkrvfcact()+1940      CALL     krvxgt()             FFFFFFFF7B7E6818 ?\r\n                                                   000000001 ?\r\n                                                   FFFFFFFF7FFFB2D4 ?\r\n                                                   FFFFFFFF7FFFB2B8 ?\r\n                                                   FFFFFFFF7FFFB2C0 ?\r\n                                                   0000000CA ?\r\nqerfxFetch()+1056    PTR_CALL 0000000000000000     FFFFFFFF7B7E6818 ?\r\n                                                   000001000 ?\r\n                                                   FFFFFFFF7B7E7768 ?\r\n                                                   FFFFFFFF7B7E0068 ?\r\n                                                   47CABB0D8 ?\r\n                                                   FFFFFFFF7B7E2F90 ?\r\nqergsFetch()+2268    PTR_CALL 0000000000000000     4C9EB4768 ? 102E54FC8 ?\r\n                                                   000000000 ? 102DDC520 ?\r\n                                                   102E53830 ? 000007FFF ?\r\nopifch2()+1724       PTR_CALL 0000000000000000     000101800 ?\r\n                                                   FFFFFFFF7B7E74E0 ?\r\n                                                   000000000 ? 000000001 ?\r\n                                                   100FD5400 ? 4C9EB46D0 ?\r\nopiall0()+3860       CALL     opifch2()            101001000 ? 102E55AD8 ?\r\n                                                   100FD5400 ? 0000000C9 ?\r\n                                                   FFFFFFFF7FFFB910 ?\r\n                                                   FFFFFFFF7FFFBF3C ?\r\nkpoal8()+1040        CALL     opiall0()            000000000 ? 00000005E ?\r\n                                                   FFFFFFFF7FFFC1C8 ?\r\n                                                   103705808 ?\r\n                                                   FFFFFFFF7B7E7B48 ?\r\n                                                   FFFFFFFF7FFFC558 ?\r\nopiodr()+1688        PTR_CALL 0000000000000000     000000000 ? 000000001 ?\r\n                                                   FFFFFFFF7FFFEA10 ?\r\n                                                   000000024 ? 000000000 ?\r\n                                                   0000022B0 ?\r\nttcpip()+1556        PTR_CALL 0000000000000000     000103400 ? 100FBBFC0 ?\r\n                                                   10370D808 ? 103705808 ?\r\n                                                   103707D40 ?\r\n                                                   FFFFFFFF7FFFCBB0 ?\r\nopitsk()+984         CALL     ttcpip()             10370D800 ? 000000014 ?\r\n                                                   FFFFFFFF7FFFEA10 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   FFFFFFFF7FFFDCFC ?\r\nopiino()+1572        CALL     opitsk()             000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   103707D28 ?\r\n                                                   FFFFFFFF7FFFEB64 ?\r\nopiodr()+1688        PTR_CALL 0000000000000000     000380007 ? 10370C658 ?\r\n                                                   1037F9458 ?\r\n                                                   FFFFFFFF7FFFF8A0 ?\r\n                                                   000000000 ? 47DED9E20 ?\r\nopidrv()+736         CALL     opiodr()             000103400 ? 10100C380 ?\r\n                                                   10370D808 ? 103705808 ?\r\n                                                   103707D40 ?\r\n                                                   FFFFFFFF7FFFF3C0 ?\r\nsou2o()+16           CALL     opidrv()             000000000 ? 000000004 ?\r\n                                                   1037051EC ? 00000003C ?\r\n                                                   1037056C8 ? 000103400 ?\r\nmain()+184           CALL     sou2o()              FFFFFFFF7FFFF8C0 ?\r\n                                                   00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF8A0 ?\r\n                                                   000039E70 ? 000000000 ?\r\n_start()+380         CALL     main()               000000002 ?\r\n                                                   FFFFFFFF7FFFFA08 ?\r\n                                                   FFFFFFFF7FFFFA20 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   100000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u5f53\u524d\u7684\u6570\u636e\u5e93\u91c7\u7528ODM:VERITAS 4.1.20.00 ODM Library, Version 1.1\uff0c\u800c\u5728\u53d1\u751f\u9519\u8bef\u65f6\u7b49\u5f85\u7684\u662fODM\u7684IO\u64cd\u4f5c\u3002\u8fd9\u4e2a\u9519\u8bef\u5728MOS\u751a\u81f3\u662fGOOGLE\u4e0a\u90fd\u627e\u4e0d\u5230\uff0c\u4e0d\u8fc7\u53ef\u4ee5\u5f88\u5bb9\u6613\u7684\u5224\u65ad\u51fa\uff0c\u95ee\u9898\u53d1\u751f\u5728Oracle\u4e0eVeritas\u4e4b\u95f4\u7684\u914d\u5408\u6709\u5173\u3002<br \/>\n\u53d1\u751f\u9519\u8bef\u7684\u8bed\u53e5\u662fSELECT COUNT(*) FROM V$LOGMNR_CONTENTS\uff0c\u4f46\u662f\u89c2\u5bdf\u4f1a\u8bdd\u7684\u5386\u53f2\u6267\u884c\u9700\u8981\uff0c\u4e4b\u524d\u5df2\u7ecf\u505a\u8fc7\u5bf9V$LOGMNR_CONTENTS\u7684\u5168\u8868\u8bbf\u95ee\uff0c\u5e76\u672a\u5f15\u53d1\u5f02\u5e38\uff1a<\/p>\n<pre lang='SQL'>Cursor Dump:\r\n----------------------------------------\r\nCursor 1 (ffffffff7ca60490): CURROW  curiob: ffffffff7ca69068\r\n curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800\r\n cursor name: select * from v$logmnr_contents\r\n child pin: 48f2da230, child lock: 490123c90, parent lock: 490123da0\r\n xscflg: 80100074, parent handle: 4a8d79a90, xscfl2: 4200409\r\n  nxt: 15.0x00000008  nxt: 14.0x00000158  nxt: 13.0x00000fa8  nxt: 12.0x00000fa8\r\n  nxt: 11.0x00000158  nxt: 10.0x00000fa8  nxt: 9.0x00000180  nxt: 8.0x00000fa8\r\n  nxt: 7.0x00000fa8  nxt: 6.0x00000158  nxt: 5.0x00000fa8  nxt: 4.0x00000420\r\n  nxt: 3.0x000007c8  nxt: 2.0x000007c8  nxt: 1.0x000007c8\r\nCursor frame allocation dump:\r\nfrm: -------- Comment --------  Size  Seg Off \r\n bhp size: 160\/600\r\n whp size: 11066784\/11067768\r\nDump of CURRENT WORK HEAP:\r\n******************************************************\r\n.\r\n.\r\n.\r\n******************************************************\r\n----------------------------------------\r\nCursor 2 (ffffffff7ca604e0): CURBOUND  curiob: ffffffff7b7e8130\r\n curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800\r\n cursor name: select distinct operation from v$logmnr_contents\r\n child pin: 0, child lock: 48f491d08, parent lock: 48f492368\r\n xscflg: 100024, parent handle: 4aa79cb50, xscfl2: 4200409\r\n bhp size: 160\/600\r\n----------------------------------------\r\nCursor 3 (ffffffff7ca60530): CURFETCH  curiob: ffffffff7b7e7b48\r\n curflg: 4e curpar: 0 curusr: 0 curses 47e8b7800\r\n cursor name: select count(*) from v$logmnr_contents\r\n child pin: 48f2db030, child lock: 490125618, parent lock: 490125c78\r\n xscflg: 80100074, parent handle: 4c9ec3038, xscfl2: 4200409\r\n  nxt: 4.0x00000008  nxt: 3.0x00000060  nxt: 2.0x000004c0  nxt: 1.0x000007c8\r\nCursor frame allocation dump:\r\nfrm: -------- Comment --------  Size  Seg Off \r\n bhp size: 160\/600\r\n whp size: 11046016\/11046720\r\nDump of CURRENT WORK HEAP:\r\n******************************************************<\/pre>\n<p>\u663e\u7136\u8fd9\u4e2a\u9519\u8bef\u7684\u53d1\u751f\u662f\u5076\u7136\u7684\uff0c\u76ee\u524d\u5e76\u6ca1\u6709\u5bfc\u81f4\u6216\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u7684\u660e\u786e\u65b9\u5f0f\uff0c\u4e0d\u8fc7\u8003\u8651\u53ea\u662f\u5076\u5c14\u5f71\u54cdv$logmnr_contents\u7684\u8bbf\u95ee\uff0c\u53ef\u4ee5\u5ffd\u7565\u6389\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 9206 RAC\u73af\u5883\u8bbf\u95eeLOGMINER\u89c6\u56fe\u65f6\u62a5\u9519\u3002 \u9519\u8bef\u4fe1\u606f\uff1a Wed Aug 10 17:06:37 2011 Errors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl2_ora_20704.trc: ORA-07445: exception encountered: core dump [000000010069AB88] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] Wed Aug 10 17:07:22 2011 Trace dumping is performing id=[cdmp_20110810170722] \u5bf9\u5e94\u7684TRACE\u4fe1\u606f\u4e3a\uff1a *** &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1357\">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":[1196,1195,1197,118,1162],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-lT","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1357"}],"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=1357"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions"}],"predecessor-version":[{"id":1358,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1357\/revisions\/1358"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}