{"id":848,"date":"2012-05-17T19:31:54","date_gmt":"2012-05-17T11:31:54","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=848"},"modified":"2012-12-10T00:37:02","modified_gmt":"2012-12-09T16:37:02","slug":"ora-7445ksuklms%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=848","title":{"rendered":"ORA-7445(ksuklms)\u9519\u8bef"},"content":{"rendered":"

\u5ba2\u6237\u768411.2.0.2 RAC\u73af\u5883\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-7445[ksuklms]\u9519\u8bef\u3002
\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n

2012-05-10 16:25:38.561000 +08:00\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, count: 1]\r\nErrors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_28387.trc (incident=449642):\r\nORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address not mapped to object] []\r\nIncident details in: \/app\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_449642\/orcl1_ora_28387_i449642.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\n2012-05-10 16:25:40.465000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120510162540], requested by (instance=1, osid=28387), summary=[incident=449642].\r\n2012-05-10 16:25:42.061000 +08:00\r\nSweep [inc][449642]: completed\r\nSweep [inc2][449642]: completed<\/pre>\n
\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n
*** 2012-05-10 16:25:38.800\r\n*** SESSION ID:(917.28879) 2012-05-10 16:25:38.800\r\n*** CLIENT ID:() 2012-05-10 16:25:38.800\r\n*** SERVICE NAME:(SYS$USERS) 2012-05-10 16:25:38.800\r\n*** MODULE NAME:(sqlplus@ecsyhdb1 (TNS V1-V3)) 2012-05-10 16:25:38.800\r\n*** ACTION NAME:() 2012-05-10 16:25:38.800\r\nDump continued from file: \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_28387.trc\r\nORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address not mapped to object] []\r\n========= Dump for incident 449642 (ORA 7445 [ksuklms()+392]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, count: 1]\r\nRegisters:\r\n----------\r\n%i0: 0xffffffff7fff72e4 %i1: 0xffffffff7fff72d6 %i2: 0xffffffff7fff72ee\r\n%i3: 0xffffffff7fff72e4 %i4: 0x0000000000000000 %i5: 0xffffffff7a6068f8\r\n%i6: 0xffffffff7fff6a21 %fp: 0xffffffff7fff7220 %i7: 0x0000000100a54020\r\n%l0: 0xffffffff7fff721c %l1: 0x000000038000b840 %l2: 0x00000000000019d8\r\n%l3: 0x0000000000001670 %l4: 0x000000000000163a %l5: 0x0000000000000000\r\n%l6: 0xffffffff7fff72d6 %l7: 0x00000000000019e0\r\n%o0: 0x0000000000000000 %o1: 0x0000000000008343 %o2: 0x0000000000000b4a\r\n%o3: 0xffffffff7fff72e8 %o4: 0x000000000000001a %o5: 0x0000000000000000\r\n%o6: 0xffffffff7fff68c1 %sp: 0xffffffff7fff70c0 %o7: 0x0000000100a5546c\r\n%g1: 0x0000000be0d2fbd8 %g2: 0x0000000000008342 %g3: 0x0000000000008342\r\n%g4: 0x0000000000041a10 %g5: 0x0000000000000000 %g6: 0x0000000000000000\r\n%g7: 0xffffffff7c100200\r\n%pc: 0x0000000100a554a8 %npc: 0x0000000100a554ac %y: 0x0000000000000000\r\nStack info:\r\n----------\r\nss_sp: 0xffffffff7e000000 ss_size: 0x0000000002000000 ss_flags: 0\r\nSwap entries = 1 \r\npath=\/dev\/md\/dsk\/d1, size=75500789760, free=75500789760, length=147462480\r\n*** 2012-05-10 16:25:38.814\r\ndbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)\r\n----- Current SQL Statement for this session (sql_id=55z15wr7xssjk) -----\r\nalter system kill session '33603,2890'\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst1()+96         CALL     skdstdst()           FFFFFFFF7A5FD640 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   00000000A ? 000000001 ?\r\n                                                   10BD552E0 ?\r\nksedst()+60          CALL     ksedst1()            000000001 ? 000000001 ?\r\n                                                   00010C1D1 ? 00010C000 ?\r\n                                                   10C1CA000 ? 00010C1CA ?\r\ndbkedDefDump()+2032  CALL     ksedst()             000000001 ? 10B21A000 ?\r\n                                                   10B21AA90 ? 10C1D2000 ?\r\n                                                   00010B000 ? 00010C1D2 ?\r\nssexhd()+2196        CALL     ksedmp()             000000003 ? 000000003 ?\r\n                                                   000000B4A ? 00038000B ?\r\n                                                   000380000 ? 000000003 ?\r\n__sighndlr()+12      PTR_CALL ssexhd()             10C1CE000 ? BE8D30A10 ?\r\n                                                   10B86D110 ?\r\n                                                   FFFFFFFF7A601EF0 ?\r\n                                                   00010C1C9 ? 0000003E8 ?\r\ncall_user_handler()  CALL     __sighndlr()         00000000B ?\r\n+992                                               FFFFFFFF7A601EF0 ?\r\n                                                   FFFFFFFF7A601C10 ?\r\n                                                   1046F1AA0 ? 000000000 ?\r\n                                                   00000000A ?\r\nksuklms()+392        PTR_CALL 0000000000000000     FFFFFFFF7C100200 ?\r\n                                                   FFFFFFFF7C100200 ?\r\n                                                   FFFFFFFF7A601C10 ?\r\n                                                   000000009 ? 000000000 ?\r\n                                                   000000000 ?\r\nksukil()+480         CALL     ksuklms()            FFFFFFFF7FFF72E4 ?\r\n                                                   FFFFFFFF7FFF72D6 ?\r\n                                                   FFFFFFFF7FFF72EE ?\r\n                                                   FFFFFFFF7FFF72E4 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7A6068F8 ?\r\nkkyasy()+4988        CALL     ksukil()             000000000 ? 000000001 ?\r\n                                                   AE4BE0C42 ? AE4BE0B08 ?\r\n                                                   10529ACB0 ? 000000B4A ?\r\nkksExecutorclmand()  CALL     kkyasy()             000000001 ?\r\n+2244                                              FFFFFFFF7AA56F28 ?\r\n                                                   07FFFFFFF ? 000000001 ?\r\n                                                   000000000 ? 07FFFFFFF ?\r\nopiexe()+13404       CALL     kksExecutorclmand()  FFFFFFFF7AA56F28 ?\r\n                                                   00010C1E3 ? 000000004 ?\r\n                                                   BF0F4AB10 ? 10C1CE900 ?\r\n                                                   10C1CE4C8 ?\r\nkpoal8()+2368        CALL     opiexe()             000000049 ? 000000003 ?\r\n                                                   FFFFFFFF7FFFA91C ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   0BFFFFFFF ?\r\nopiodr()+1428        PTR_CALL kpoal8()             00000005E ? 00000001C ?\r\n                                                   FFFFFFFF7FFFDDD8 ?\r\n                                                   00010C000 ? 10C1CA000 ?\r\n                                                   000001648 ?\r\nttcpip()+1056        PTR_CALL opiodr()             00010A755 ? 00000001C ?\r\n                                                   103E6CC40 ? 00010A400 ?\r\n                                                   000001400 ? 10C1CA000 ?\r\nopitsk()+1528        CALL     ttcpip()             000000000 ? 10A686E74 ?\r\n                                                   10C1CA3E0 ?\r\n                                                   FFFFFFFF7FFFDDD8 ?\r\n                                                   FFFFFFFF7FFFC820 ?\r\n                                                   10C1E0F98 ?\r\nopiino()+1000        CALL     opitsk()             10A686E74 ? 10C1E63E8 ?\r\n                                                   10C1E0DA4 ? 10C1DF0A8 ?\r\n                                                   000000000 ? 10C1CA0A0 ?\r\nopiodr()+1428        PTR_CALL opiino()             000002270 ? 10C1E0E20 ?\r\n                                                   00010C000 ? 000380000 ?\r\n                                                   0000000FC ?\r\n                                                   FFFFFFFF7FFFF730 ?\r\nopidrv()+1100        CALL     opiodr()             10C1E0000 ? 000000004 ?\r\n                                                   10359CF20 ? 00010C000 ?\r\n                                                   000001400 ? 10C1CA000 ?\r\nsou2o()+92           CALL     opidrv()             00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF730 ?\r\n                                                   0001EA190 ?\r\n                                                   FFFFFFFF7AF42F10 ?\r\n                                                   10C3D42B0 ?\r\nopimai_real()+304    CALL     sou2o()              FFFFFFFF7FFFF708 ?\r\n                                                   00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF730 ?\r\n                                                   00010C000 ? 00010B800 ?\r\nssthrdmain()+320     PTR_CALL opimai_real()        000000000 ?\r\n                                                   FFFFFFFF7FFFF9D8 ?\r\n                                                   FFFFFFFF7DF3AEB8 ?\r\n                                                   00010B800 ? 000000001 ?\r\n                                                   000000002 ?\r\nmain()+308           CALL     ssthrdmain()         00010C000 ? 000000002 ?\r\n                                                   00044D000 ? 100604320 ?\r\n                                                   10C1EF000 ? 00010C1EF ?\r\n_start()+380         CALL     main()               000000002 ?\r\n                                                   FFFFFFFF7FFFFAE8 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7FFFF9E8 ?\r\n                                                   FFFFFFFF7FFFFAF8 ?\r\n                                                   FFFFFFFF7C100200 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n
\u8fd9\u4e2a\u9519\u8bef\u662f10.2.0.4\u5f00\u59cb\u5f15\u5165\u7684\uff0cOracle\u572810.2.0.5\u4e2d\u5df2\u7ecffixed\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u6ca1\u60f3\u5230\u572811.2.0.2\u4e2d\uff0c\u8fd9\u4e2a\u95ee\u9898\u4ecd\u7136\u51fa\u73b0\u3002\u572810.2.0.4\u4e2d\uff0c\u5728RAC\u73af\u5883\u4e0b\u6740\u6389\u4e00\u4e2a\u4f1a\u8bdd\u53ef\u80fd\u5bfc\u81f4\u8282\u70b9\u7684CRASH\uff0c\u4f46\u662f11.2\u4e2d\uff0c\u867d\u7136\u51fa\u73b0\u4e86\u540c\u6837\u7684\u9519\u8bef\uff0c\u4f46\u662f\u6570\u636e\u5e93\u5b9e\u4f8b\u5e76\u672aCRASH\u3002\u8be5\u95ee\u9898\u7684\u63cf\u8ff0\u53ef\u4ee5\u53c2\u8003\u6587\u6863\uff1aBug 7038750 – Dump (ksuklms) \/ instance crash [ID 7038750.8]\u3002
\n\u572811.2\u4e2d\u53ef\u4ee5\u7b80\u5355\u7684\u5ffd\u7565\u8fd9\u4e2a\u95ee\u9898\uff0c\u800c10.2.0.4\u73af\u5883\u5982\u679c\u78b0\u5230\u8fd9\u4e2a\u9519\u8bef\uff0c\u9664\u4e86\u5c06\u6570\u636e\u5e93\u5347\u7ea7\u523010.2.0.5\u621610.2.0.4.1\u4ee5\u5916\uff0c\u8fd8\u53ef\u4ee5\u5728\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6\u4e2d\u6dfb\u52a0event\uff1a\u201810422 trace name context forever, level 1\u2019\u6765\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\u9020\u6210\u5b9e\u4f8b\u7684CRASH\u3002<\/p>\n
\u6700\u8fd1\u78b0\u5230\u4e8610.2.0.4\u4e0a\u7684\u8fd9\u4e2aBUG\uff0c\u5728\u68c0\u67e5MOS\u53d1\u73b0Oracle\u66f4\u65b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u7684\u72b6\u6001\uff0c\u5728\u6587\u6863Bug 14024668 – ORA-7445 [ksuklms] from ‘alter system kill session (non-existent)’ [ID 14024668.8]\u4e2d\u8bb0\u5f55\u4e8611.2\u4e0a\u7684\u95ee\u9898\u3002<\/p>\n
\u8fd9\u4e2a\u9519\u8bef\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u4e3a11.2.0.3\uff0cOracle\u572811.2.0.4\u4e2d\u786e\u8ba4FIXED\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u768411.2.0.2 RAC\u73af\u5883\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-7445[ksuklms]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a 2012-05-10 16:25:38.561000 +08:00 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, count: 1] Errors in file \/app\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_28387.trc (incident=449642): ORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address not mapped to object] … Continue reading →<\/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":[716,490,718,521,719,717,118,180],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dG","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/848"}],"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=848"}],"version-history":[{"count":4,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/848\/revisions"}],"predecessor-version":[{"id":1218,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/848\/revisions\/1218"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}