{"id":287,"date":"2011-11-14T23:10:00","date_gmt":"2011-11-14T15:10:00","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=287"},"modified":"2011-11-15T15:10:02","modified_gmt":"2011-11-15T07:10:02","slug":"ora-7445sigsetjmp%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=287","title":{"rendered":"ORA-7445(sigsetjmp)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u51fa\u73b0ORA-7445\u9519\u8bef\uff0c\u5bfc\u81f4\u9519\u8bef\u7684SQL\u5728\u8bbf\u95eeV$ACCESS\u89c6\u56fe\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Sun Sep 19 17:15:17 2010\r\nErrors in file \/home\/oracle\/admin\/ARIC\/udump\/aric_ora_26489.trc:\r\nORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [0] [] [] []<\/pre>\n<p>\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\uff1a<\/p>\n<pre lang='SQL'>\/home\/oracle\/admin\/ARIC\/udump\/aric_ora_26489.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nORACLE_HOME = \/home\/oracle\/product\/10.2.0\r\nSystem name: SunOS\r\nNode name: aric\r\nRelease: 5.10\r\nVersion: Generic_127128-11\r\nMachine: i86pc\r\nInstance name: ARIC\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 51\r\nUnix process pid: 26489, image: oracleARIC@aric\r\n*** 2010-09-19 17:15:17.370\r\n*** ACTION NAME:() 2010-09-19 17:15:17.339\r\n*** MODULE NAME:(TOAD 8.6.1.0) 2010-09-19 17:15:17.339\r\n*** SERVICE NAME:(ARIC) 2010-09-19 17:15:17.339\r\n*** SESSION ID:(202.3926) 2010-09-19 17:15:17.339\r\nException signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0\r\n*** 2010-09-19 17:15:17.371\r\nksedmp: internal or fatal error\r\nORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [0] [] [] []\r\nCurrent SQL statement for this session:\r\nSELECT  sid, owner, type, object FROM v$access WHERE  sid = '651'\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+23          ?        0000000000000001     0017B341C 000000000 0062E5A60\r\n                                                   000000000\r\nksedmp()+636         ?        0000000000000001     0017B1EB1 000000000 00000000B\r\n                                                   000000000\r\nssexhd()+729         ?        0000000000000001     000E90E7E 000000000 0062E5B90\r\n                                                   000000000\r\nsigsetjmp()+25       ?        0000000000000001     0FDDC00B6 0FFFFFD7F 0062E5B50\r\n                                                   000000000\r\ncall_user_handler()  ?        0000000000000001     0FDDB53A2 0FFFFFD7F 0062E5EF0\r\n+589                                               000000000\r\nsigacthandler()+163  ?        0000000000000001     0FDDB5588 0FFFFFD7F 0FF3FB2F0\r\n                                                   0FFFFFD7F\r\n_memcpy()+245        ?        0000000000000001     0FFFFFFFF 0FFFFFFFF 00000000B\r\n                                                   000000000\r\nkglLockIterator()+5  ?        0000000000000001     003E36CE1 000000000 0C582FDCC\r\n96                                                 000000000\r\nkqlftl()+194         ?        0000000000000001     001F2A4B7 000000000 000000000\r\n                                                   000000000\r\nqerfxFetch()+4999    ?        0000000000000001     00340E894 000000000 000000000\r\n                                                   000000000\r\nqerjotFetch()+214    ?        0000000000000001     0033BEBA3 000000000 0060B9478\r\n                                                   000000000\r\nqerjotFetch()+280    ?        0000000000000001     0033BEBE5 000000000 0000001F4\r\n                                                   000000000\r\nqerghFetch()+293     ?        0000000000000001     0034C19B2 000000000 0000001F4\r\n                                                   000000000\r\nqervwFetch()+158     ?        0000000000000001     0033BCFBB 000000000 0000001F4\r\n                                                   000000000\r\nopifch2()+2608       ?        0000000000000001     002932E8D 000000000 000000000\r\n                                                   000000000\r\nkpoal8()+3638        ?        0000000000000001     0028CF6BB 000000000 000000000\r\n                                                   000000000\r\nopiodr()+1087        ?        0000000000000001     000E97C5C 000000000 000000000\r\n                                                   000000000\r\nttcpip()+1165        ?        0000000000000001     003D9F6CA 000000000 005F663F8\r\n                                                   000000000\r\nopitsk()+1278        ?        0000000000000001     000E939C3 000000000 000E97840\r\n                                                   000000000\r\nopiino()+931         ?        0000000000000001     000E96F08 000000000 005F5D840\r\n                                                   000000000\r\nopiodr()+1087        ?        0000000000000001     000E97C5C 000000000 000000000\r\n                                                   000000000\r\nopidrv()+748         ?        0000000000000001     000E924C1 000000000 0FFDFF8C8\r\n                                                   0FFFFFD7F\r\nsou2o()+86           ?        0000000000000001     000E8F8FB 000000000 000000000\r\n                                                   000000000\r\nopimai_real()+127    ?        0000000000000001     000E552D4 000000000 000000000\r\n                                                   000000000\r\nmain()+95            ?        0000000000000001     000E551A4 000000000 000000000\r\n                                                   000000000\r\n0000000000E54FE7     ?        0000000000000001     000E54FEC 000000000 000000000\r\n                                                   000000000\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u5bfc\u81f4\u9519\u8bef\u4ea7\u751f\u7684\u8bed\u53e5\u5f88\u7b80\u5355\uff0c\u5c31\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u5355\u8868\u67e5\u8be2\uff0c\u53ea\u4e0d\u8fc7\u8bbf\u95ee\u7684\u662fOracle\u7684\u52a8\u6001\u6027\u80fd\u89c6\u56fe\u8868\u3002\u800c\u8fd9\u79cd\u60c5\u51b5\u4e0b\u51fa\u73b0\u7684\u9519\u8bef\uff0c\u57fa\u672c\u4e0a\u53ef\u4ee5\u786e\u5b9a\u662fbug\u3002<br \/>\n\u6839\u636e\u9519\u8bef\u53f7sigsetjmp\u68c0\u67e5MOS\u4fe1\u606f\uff0c\u53d1\u73b0\u5305\u62ec\u5806\u6808\u4fe1\u606f\u5728\u5185\u7684\u5404\u65b9\u9762\u4fe1\u606f\u90fd\u4e0eBug 7149072: ORA-7445 OCCURS WHEN SELECTING FROM V$ACCESS\u63cf\u8ff0\u7684\u4e00\u81f4\uff0c\u53ea\u4e0d\u8fc7\u8fd9\u4e2abug\u63cf\u8ff0\u5e76\u4e0d\u662f\u4e00\u4e2a\u57fa\u672cBUG\uff0c\u800c\u8fd9\u4e2a\u95ee\u9898\u5bf9\u5e94\u7684\u57fa\u672cbug\u662f\uff1aBug 4969005  Dump [kglLockIterator] querying V$ views\uff0c\u800c\u8fd9\u4e2abug\u63cf\u8ff0\u4e2d\u5bf9\u5e94\u7684kglLockIterator\u548cmemcpy\u9519\u8bef\u51fd\u6570\u5728\u5f53\u524d\u9519\u8bef\u4e2d\u540c\u6837\u5b58\u5728\uff0c\u800c\u4e14\u5f53\u524d\u6570\u636e\u5e93\u7248\u672c\u7684\u4e5f\u662f\u53d7\u5f71\u54cd\u768410.2.0.3\uff0c\u57fa\u672c\u4e0a\u53ef\u4ee5\u786e\u5b9abug\u4e86\u3002<br \/>\n\u8fd9\u4e2aBUG\u572811.2.0.4\u548c11.1.0.6\u4e2d\u88abfixed\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u51fa\u73b0ORA-7445\u9519\u8bef\uff0c\u5bfc\u81f4\u9519\u8bef\u7684SQL\u5728\u8bbf\u95eeV$ACCESS\u89c6\u56fe\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Sun Sep 19 17:15:17 2010 Errors in file \/home\/oracle\/admin\/ARIC\/udump\/aric_ora_26489.trc: ORA-07445: exception encountered: core dump [SIGSEGV] [Address not mapped to object] [0] [] [] [] \u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\uff1a \/home\/oracle\/admin\/ARIC\/udump\/aric_ora_26489.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 &#8211; Production With the Partitioning, &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=287\">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":[212,211,118,210,213],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-4D","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/287"}],"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=287"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/287\/revisions"}],"predecessor-version":[{"id":288,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/287\/revisions\/288"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}