{"id":1418,"date":"2012-11-19T23:09:28","date_gmt":"2012-11-19T15:09:28","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1418"},"modified":"2013-07-20T23:11:20","modified_gmt":"2013-07-20T15:11:20","slug":"%e5%85%b3%e9%97%ad%e6%95%b0%e6%8d%ae%e5%ba%93%e5%87%ba%e7%8e%b0pmon-failed-to-acquire-latch%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1418","title":{"rendered":"\u5173\u95ed\u6570\u636e\u5e93\u51fa\u73b0PMON failed to acquire latch\u4fe1\u606f"},"content":{"rendered":"<p>\u5f88\u5e38\u89c1\u7684\u4e00\u4e2a\u4fe1\u606f\uff0c\u4ee5\u524d\u5e76\u6ca1\u6709\u592a\u5728\u610f\uff0c\u4e0d\u8fc7\u5373\u4f7f\u662f\u8fd9\u79cd\u5f02\u5e38\u4fe1\u606f\uff0cOracle\u4e5f\u8ba4\u4e3a\u662fbug\u3002<br \/>\n\u5173\u95ed\u6570\u636e\u5e93\u65f6\uff0c\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Tue Aug 16 15:38:06 2011\r\nShutting down archive processes\r\nTue Aug 16 15:38:11 2011\r\nARCH shutting down\r\nARC2: Archival stopped\r\nTue Aug 16 15:43:41 2011\r\nStarting background process EMN0\r\nEMN0 started with pid=28, OS id=1294500\r\nTue Aug 16 15:43:41 2011\r\nShutting down instance: further logons disabled\r\nTue Aug 16 15:43:41 2011\r\nStopping background process QMNC\r\nTue Aug 16 15:43:41 2011\r\nStopping background process CJQ0\r\nTue Aug 16 15:43:44 2011\r\nStopping background process MMNL\r\nTue Aug 16 15:43:45 2011\r\nStopping background process MMON\r\nTue Aug 16 15:43:46 2011\r\nShutting down instance (immediate)\r\nLicense high water mark = 10\r\nTue Aug 16 15:43:46 2011\r\nStopping Job queue slave processes\r\nTue Aug 16 15:43:51 2011\r\nProcess OS id : 1474740 alive after kill\r\nErrors in file \r\nTue Aug 16 15:43:51 2011\r\nJob queue slave processes stopped\r\nTue Aug 16 15:44:01 2011\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nTue Aug 16 15:44:11 2011\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nTue Aug 16 15:44:22 2011\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nTue Aug 16 15:44:32 2011\r\nPMON failed to acquire latch, see PMON dump\r\nPMON failed to acquire latch, see PMON dump\r\nTue Aug 16 15:44:37 2011\r\nALTER DATABASE CLOSE NORMAL\r\nTue Aug 16 15:44:37 2011\r\nSMON: disabling tx recovery\r\nSMON: disabling cache recovery\r\nTue Aug 16 15:44:37 2011\r\nShutting down archive processes\r\nArchiving is disabled\r\nTue Aug 16 15:44:42 2011\r\nARCH shutting down\r\nARC1: Archival stopped\r\nTue Aug 16 15:44:47 2011\r\nARCH shutting down\r\nARC0: Archival stopped\r\nTue Aug 16 15:44:49 2011\r\nThread 1 closed at log sequence 9371\r\nSuccessful close of redo thread 1\r\nTue Aug 16 15:44:49 2011\r\nCompleted: ALTER DATABASE CLOSE NORMAL\r\nTue Aug 16 15:44:49 2011\r\nALTER DATABASE DISMOUNT\r\nCompleted: ALTER DATABASE DISMOUNT\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active\r\nARCH: Archival disabled due to shutdown: 1089\r\nShutting down archive processes\r\nArchiving is disabled\r\nArchive process shutdown avoided: 0 active<\/pre>\n<p>Oracle\u5728MOS\u6587\u6863Bug 4632780 &#8211; PMON &#8220;failed to acquire latch&#8221; during shutdown [ID 4632780.8]\u4e13\u95e8\u4ecb\u7ecd\u4e86\u8fd9\u4e2a\u4fe1\u606f\uff0c\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u5305\u62ec9.2.0.7\u300110.1.0.5\u548c10.2.0.1\uff0cOracle\u57289.2.0.8\u300110.2.0.2\u548c11.1.0.6\u4e2d\u8fdb\u884c\u4e86\u4fee\u590d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f88\u5e38\u89c1\u7684\u4e00\u4e2a\u4fe1\u606f\uff0c\u4ee5\u524d\u5e76\u6ca1\u6709\u592a\u5728\u610f\uff0c\u4e0d\u8fc7\u5373\u4f7f\u662f\u8fd9\u79cd\u5f02\u5e38\u4fe1\u606f\uff0cOracle\u4e5f\u8ba4\u4e3a\u662fbug\u3002 \u5173\u95ed\u6570\u636e\u5e93\u65f6\uff0c\u4fe1\u606f\u5982\u4e0b\uff1a Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started with pid=28, OS id=1294500 Tue Aug 16 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1418\">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":[1254,421],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-mS","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1418"}],"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=1418"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1418\/revisions"}],"predecessor-version":[{"id":1419,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1418\/revisions\/1419"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}