{"id":1341,"date":"2013-07-03T23:21:39","date_gmt":"2013-07-03T15:21:39","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1341"},"modified":"2013-07-06T23:25:51","modified_gmt":"2013-07-06T15:25:51","slug":"11-2-0-3-asm%e5%ae%9e%e4%be%8b%e5%87%ba%e7%8e%b0ora-4031%e5%af%bc%e8%87%b4%e6%95%b0%e6%8d%ae%e5%ba%93%e5%bd%92%e6%a1%a3%e5%a4%b1%e8%b4%a5","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1341","title":{"rendered":"11.2.0.3 ASM\u5b9e\u4f8b\u51fa\u73b0ORA-4031\u5bfc\u81f4\u6570\u636e\u5e93\u5f52\u6863\u5931\u8d25"},"content":{"rendered":"<p>\u5ba2\u6237\u768411.2.0.3 RAC\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u5f52\u6863\u5931\u8d25\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u5355\u4e2a\u5b9e\u4f8b\u51fa\u73b0HANG\u6b7b\u7684\u72b6\u51b5\u3002<br \/>\n\u68c0\u67e5\u9519\u8bef\u4fe1\u606f\u53d1\u73b0\uff1a<\/p>\n<pre lang='SQL'>Tue Jul 02 16:49:13 2013\r\nARC1: Error 19504 Creating archive log file to '+DATA02'\r\nARCH: Archival stopped, error occurred. Will continue retrying\r\nORACLE Instance orcl1 - Archival Error\r\nORA-16038: log 14 sequence# 68244 cannot be archived\r\nORA-19504: failed to create file \"\"\r\nORA-00312: online log 14 thread 1: '+DATA02\/orcl\/onlinelog\/group_14.264.792274883'\r\nORA-00312: online log 14 thread 1: '+DATA02\/orcl\/onlinelog\/group_14.265.792274889'\r\nArchiver process freed from errors. No longer stopped\r\nTue Jul 02 16:50:37 2013\r\nARC0: LGWR is actively archiving destination LOG_ARCHIVE_DEST_3\r\nARCH: Archival stopped, error occurred. Will continue retrying\r\nORACLE Instance orcl1 - Archival Error\r\nORA-16014: log 14 sequence# 68244 not archived, no available destinations\r\nORA-00312: online log 14 thread 1: '+DATA02\/orcl\/onlinelog\/group_14.264.792274883'\r\nORA-00312: online log 14 thread 1: '+DATA02\/orcl\/onlinelog\/group_14.265.792274889'\r\nARC0: Archive log rejected (thread 1 sequence 68240) at host 'orclsh'\r\nFAL[server, ARC0]: FAL archive failed, see trace file.\r\nARCH: FAL archive failed. Archiver continuing\r\nORACLE Instance orcl1 - Archival Error. Archiver continuing.<\/pre>\n<p>\u7531\u4e8e\u5f52\u6863\u5931\u8d25\u53d1\u751f\u5728ASM\u78c1\u76d8\u4e0a\uff0c\u9996\u5148\u68c0\u67e5ASM\u78c1\u76d8\u7a7a\u95f4\u4ee5\u53caDB_RECOVERY_FILE_DEST_SIZE\uff0cASM\u78c1\u76d8\u7a7a\u95f4\u662f\u8db3\u591f\u7684\uff0c\u800c\u4e14\u7531\u4e8e\u53ea\u6709\u4e00\u4e2a\u8282\u70b9\u51fa\u73b0\u51fa\u73b0\u4e86\u65e0\u6cd5\u5f52\u6863\u7684\u95ee\u9898\uff0c\u4e5f\u53ef\u4ee5\u6392\u9664\u662f\u7a7a\u95f4\u4e0d\u8db3\u9020\u6210\u7684\u3002\u786e\u8ba4\u4e24\u4e2a\u8282\u70b9\u7684DB_RECOVERY_FILE_DEST_SIZE\u53c2\u6570\u8bbe\u7f6e\u90fd\u662f0\uff0c\u57fa\u672c\u4e0a\u53ef\u4ee5\u5224\u65ad\u95ee\u9898\u548c\u5f53\u524d\u8282\u70b9\u7684ASM\u5b9e\u4f8b\u72b6\u6001\u4e0d\u6b63\u5e38\u6709\u5173\u3002<br \/>\n\u68c0\u67e5ASM\u5b9e\u4f8b\u7684\u9519\u8bef\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>Tue Jul 02 16:41:43 2013\r\nDumping diagnostic data in directory=[cdmp_20130702164115], requested by (instance=2, osid=2032294 (LMD0)), summary=[incident=165521].\r\nTue Jul 02 16:49:13 2013\r\nDumping diagnostic data in directory=[cdmp_20130702164845], requested by (instance=2, osid=2032294 (LMD0)), summary=[incident=165522].\r\nTue Jul 02 16:55:45 2013\r\nDumping diagnostic data in directory=[cdmp_20130702165517], requested by (instance=2, osid=2032294 (LMD0)), summary=[incident=165523].\r\nTue Jul 02 17:01:48 2013\r\nDumping diagnostic data in directory=[cdmp_20130702170120], requested by (instance=2, osid=2032294 (LMD0)), summary=[incident=165524].\r\nTue Jul 02 17:07:27 2013\r\nDumping diagnostic data in directory=[cdmp_20130702170659], requested by (instance=2, osid=2032294 (LMD0)), summary=[incident=165525].<\/pre>\n<p>\u5f53\u524d\u8282\u70b9ASM\u5b9e\u4f8b\u51fa\u73b0\u4e86\u7684\u8fd9\u4e2a\u4fe1\u606f\uff0c\u8bf4\u660e\u62a5\u9519\u53d1\u751f\u5728\u5b9e\u4f8b2\u4e0a\uff1a<\/p>\n<pre lang='SQL'>Tue Jul 02 18:29:55 2013\r\nErrors in file \/u01\/app\/grid\/diag\/asm\/+asm\/+ASM2\/trace\/+ASM2_lmd0_2032294.trc  (incident=186256):\r\nORA-04031: unable to allocate 3768 bytes of shared memory (\"shared pool\",\"unknown object\",\"sga heap(1,0)\",\"ges enqueues\")\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\n Insufficient shared pool to allocate a GES object (ospid 2032294)\r\nTue Jul 02 18:29:55 2013\r\nSweep [inc][186256]: completed\r\nTue Jul 02 18:36:49 2013\r\nErrors in file \/u01\/app\/grid\/diag\/asm\/+asm\/+ASM2\/trace\/+ASM2_lmd0_2032294.trc  (incident=186257):\r\nORA-04031: unable to allocate 3768 bytes of shared memory (\"shared pool\",\"unknown object\",\"sga heap(1,0)\",\"ges enqueues\")\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\n Insufficient shared pool to allocate a GES object (ospid 2032294)<\/pre>\n<p>\u679c\u7136\u5b9e\u4f8b2\u4e0a\u7684ASM\u51fa\u73b0\u4e86\u5927\u91cfORA-4031\u9519\u8bef\u3002\u68c0\u67e5ASM\u542f\u52a8\u7684\u53c2\u6570\u914d\u7f6e\uff1a<\/p>\n<pre lang='SQL'>Sat Aug 25 20:06:55 2012\r\nNOTE: No asm libraries found in the system\r\nERROR: -5(Duplicate disk DATA_DG01:ASM_DISK1)\r\nERROR: -5(Duplicate disk DATA_DG01:ASM_DISK2)\r\nMEMORY_TARGET defaulting to 411041792.\r\n* instance_number obtained from CSS = 2, checking for the existence of node 0... \r\n* node 0 does not exist. instance_number = 2 \r\nStarting ORACLE instance (normal)\r\nLICENSE_MAX_SESSION = 0\r\nLICENSE_SESSIONS_WARNING = 0\r\nPrivate Interface 'en1' configured from GPnP for use as a private interconnect.\r\n  [name='en1', type=1, ip=169.254.78.6, mac=00-1a-64-bb-50-7d, net=169.254.0.0\/16, mask=255.255.0.0, use=haip:cluster_interconnect\/62]\r\nPublic Interface 'en0' configured from GPnP for use as a public interface.\r\n  [name='en0', type=1, ip=10.1.16.35, mac=00-1a-64-bb-50-7c, net=10.1.16.32\/27, mask=255.255.255.224, use=public\/1]\r\nPicked latch-free SCN scheme 3\r\nUsing LOG_ARCHIVE_DEST_1 parameter default value as \/u01\/app\/11.2.0.3\/grid\/dbs\/arch\r\nAutotune of undo retention is turned on. \r\nLICENSE_MAX_USERS = 0\r\nSYS auditing is disabled\r\nNOTE: Volume support  enabled\r\nStarting up:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Real Application Clusters and Automatic Storage Management options.\r\nORACLE_HOME = \/u01\/app\/11.2.0.3\/grid\r\nSystem name:\tAIX\r\nNode name:\torcldb2\r\nRelease:\t1\r\nVersion:\t6\r\nMachine:\t00C94E064C00\r\nUsing parameter settings in server-side pfile \/u01\/app\/11.2.0.3\/grid\/dbs\/init+ASM2.ora\r\nSystem parameters with non-default values:\r\n  large_pool_size          = 12M\r\n  instance_type            = \"asm\"\r\n  remote_login_passwordfile= \"EXCLUSIVE\"\r\n  asm_diskstring           = \"\/dev\/ocr_*\"\r\n  asm_diskstring           = \"\/dev\/voting_*\"\r\n  asm_diskstring           = \"\/dev\/asm_*\"\r\n  asm_diskgroups           = \"DATA\"\r\n  asm_diskgroups           = \"DATA_DG01\"\r\n  asm_diskgroups           = \"SPFILE_DG\"\r\n  asm_power_limit          = 1\r\n  diagnostic_dest          = \"\/u01\/app\/grid\"\r\nCluster communication is configured to use the following interface(s) for this instance\r\n  169.254.78.6\r\ncluster interconnect IPC version:Oracle UDP\/IP (generic)\r\nIPC Vendor 1 proto 2<\/pre>\n<p>\u5f53\u524dASM\u5b9e\u4f8b\u4f7f\u7528\u9ed8\u8ba4\u7684MEMORY_TARGET\u914d\u7f6e\uff0c\u5206\u914d\u5927\u5c0f\u5927\u7ea6\u662f400M\uff0c\u6839\u636eOracle\u7684MOS\u6587\u7ae0\uff1aASM &#038; Shared Pool (ORA-4031) [ID 437924.1]\uff0c\u572811.2.0.3\u4e2d\uff0cOracle\u589e\u52a0\u4e86ASM\u5b9e\u4f8b\u6240\u5141\u8bb8\u7684\u9ed8\u8ba4\u8fdb\u7a0b\u6570PROCESSES\uff0c\u4f46\u662f\u9ed8\u8ba4\u7684MEMORY_TARGET\u53c2\u6570\u6ca1\u6709\u589e\u52a0\u3002<br \/>\n\u6839\u636eOracle\u7684\u5efa\u8bae\uff0c11.2.0.3\u7684MEMORY_TARGET\u81f3\u5c11\u5e94\u8be5\u8bbe\u7f6e\u52301536M\uff0c\u800cMEMORY_MAX_TARGET\u8bbe\u7f6e\u4e3a4096M\u3002<\/p>\n<pre lang='SQL'>SQL> alter system set memory_max_target=4096m scope=spfile;\r\nSQL> alter system set memory_target=1536m scope=spfile;<\/pre>\n<p>\u5bf9\u4e8e\u5f53\u524d\u7684\u60c5\u51b5\uff0c\u5982\u679c\u77ed\u65f6\u95f4\u5185\u65e0\u6cd5\u91cd\u542fDB\u548cASM\u5b9e\u4f8b\uff0c\u53ef\u4ee5\u5728\u95ee\u9898\u8282\u70b9\u914d\u7f6e\u4e00\u4e2a\u7b2c\u4e8c\u672c\u5730\u5f52\u6863\u8def\u5f84\uff0c\u8bbe\u7f6e\u76ee\u6807\u8def\u5f84\u4e3a\u672c\u5730\u78c1\u76d8\uff0c\u4ece\u800c\u907f\u514d\u5f52\u6863\u65e0\u6cd5\u5b8c\u6210\u800c\u5bfc\u81f4\u7684\u5b9e\u4f8bHANG\u6b7b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u768411.2.0.3 RAC\u6570\u636e\u5e93\u51fa\u73b0\u4e86\u5f52\u6863\u5931\u8d25\u7684\u60c5\u51b5\uff0c\u5bfc\u81f4\u5355\u4e2a\u5b9e\u4f8b\u51fa\u73b0HANG\u6b7b\u7684\u72b6\u51b5\u3002 \u68c0\u67e5\u9519\u8bef\u4fe1\u606f\u53d1\u73b0\uff1a Tue Jul 02 16:49:13 2013 ARC1: Error 19504 Creating archive log file to &#8216;+DATA02&#8217; ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance orcl1 &#8211; Archival Error ORA-16038: log 14 sequence# 68244 cannot be archived ORA-19504: &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1341\">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":[55,324,1183,788,789,790,442,1184,180],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-lD","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1341"}],"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=1341"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1341\/revisions"}],"predecessor-version":[{"id":1342,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1341\/revisions\/1342"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}