{"id":1400,"date":"2012-11-14T23:04:15","date_gmt":"2012-11-14T15:04:15","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1400"},"modified":"2013-07-14T23:07:02","modified_gmt":"2013-07-14T15:07:02","slug":"ora-1000%e5%af%bc%e8%87%b4%e7%9a%84ora-7445%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1400","title":{"rendered":"ORA-1000\u5bfc\u81f4\u7684ORA-7445\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.1\u73af\u5883\uff0c\u51fa\u73b0\u4e86ORA-1000\u9519\u8bef\u5e76\u5bfc\u81f4\u4e86ORA-7445\u9519\u8bef\u7684\u4ea7\u751f\u3002<br \/>\nOracle\u7684ORA-1000\u9519\u8bef\u662f\u4e2a\u666e\u901a\u7684\u95ee\u9898\uff0c\u5c31\u662f\u5f53\u524d\u4f7f\u7528\u7684\u6e38\u6807\u503c\u8d85\u8fc7\u4e86OPEN_CURSOR\u521d\u59cb\u5316\u53c2\u6570\u7684\u503c\uff0c\u800c\u8fd9\u4e2a\u9519\u8bef\u5bfc\u81f4\u7684ORA-7445\u9519\u8bef\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff1a<\/p>\n<pre lang='SQL'>Thu Oct 28 16:32:57 2010\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/orcl\/orcl_mmon_356528.trc:\r\nORA-07445: exception encountered: core dump [] [] [] [] [] []\r\nORA-00604: error occurred at recursive SQL level 2\r\nORA-01000: maximum open cursors exceeded<\/pre>\n<p>\u5728\u6587\u6863ORA-7445 Followed By ORA-1000 &#8220;MAXIMUM OPEN CURSORS EXCEEDED&#8221; Error [ID 1138647.1]\u4ecb\u7ecd\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u663e\u7136\u8fd9\u4e2a\u9519\u8bef\u7684\u89e3\u51b3\u65b9\u6cd5\u5c31\u662f\u8c03\u6574OPEN_CURSORS\u7684\u503c\uff0c\u800c\u5f53\u524d\u6570\u636e\u5e93\u91c7\u7528\u4e86\u9ed8\u8ba4\u503c300\uff0c\u786e\u5b9e\u5e76\u4e0d\u9ad8\u3002\u7531\u4e8eOPEN_CURSORS\u8bbe\u7f6e\u7684\u662f\u6700\u5927\u503c\uff0c\u56e0\u6b64\u5c06\u8fd9\u4e2a\u503c\u8bbe\u7f6e\u7684\u9ad8\u4e00\u4e9b\u5e76\u4e0d\u4f1a\u6709\u4ec0\u4e48\u4e0d\u826f\u5f71\u54cd\uff0c\u53ef\u4ee5\u5c06\u5176\u8c03\u6574\u52301000\u751a\u81f3\u662f3000\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.1\u73af\u5883\uff0c\u51fa\u73b0\u4e86ORA-1000\u9519\u8bef\u5e76\u5bfc\u81f4\u4e86ORA-7445\u9519\u8bef\u7684\u4ea7\u751f\u3002 Oracle\u7684ORA-1000\u9519\u8bef\u662f\u4e2a\u666e\u901a\u7684\u95ee\u9898\uff0c\u5c31\u662f\u5f53\u524d\u4f7f\u7528\u7684\u6e38\u6807\u503c\u8d85\u8fc7\u4e86OPEN_CURSOR\u521d\u59cb\u5316\u53c2\u6570\u7684\u503c\uff0c\u800c\u8fd9\u4e2a\u9519\u8bef\u5bfc\u81f4\u7684ORA-7445\u9519\u8bef\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff1a Thu Oct 28 16:32:57 2010 Errors in file \/u01\/app\/oracle\/admin\/orcl\/orcl\/orcl_mmon_356528.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] ORA-00604: error occurred at recursive SQL level 2 ORA-01000: maximum open cursors exceeded \u5728\u6587\u6863ORA-7445 Followed By ORA-1000 &#8220;MAXIMUM &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1400\">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":[1227,1226,672,118],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-mA","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1400"}],"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=1400"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1400\/revisions"}],"predecessor-version":[{"id":1401,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1400\/revisions\/1401"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}