{"id":218,"date":"2011-10-17T23:52:28","date_gmt":"2011-10-17T15:52:28","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=218"},"modified":"2011-10-18T02:12:03","modified_gmt":"2011-10-17T18:12:03","slug":"%e5%88%9b%e5%bb%ba%e7%a3%81%e7%9b%98%e7%bb%84%e6%97%b6%e5%87%ba%e7%8e%b0ora-15238%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=218","title":{"rendered":"\u521b\u5efa\u78c1\u76d8\u7ec4\u65f6\u51fa\u73b0ORA-15238\u9519\u8bef"},"content":{"rendered":"<p>\u6d4b\u8bd5\u4e0d\u540c\u7684AU_SIZE\u7684\u5f71\u54cd\u65f6\uff0c\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u5efa\u7acbAU_SIZE\u5927\u5c0f\u4e3a64M\u7684\u78c1\u76d8\u7ec4\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>SQL> create diskgroup data_au64m external redundancy disk '\/dev\/asm-disk3' attribute 'au_size'='64m','compatible.asm'='11.2','compatible.rdbms'='11.2';\r\nORA-15018: diskgroup cannot be created\r\nORA-15238: 64m is not a valid value for attribute au_size<\/pre>\n<p>\u5f00\u59cb\u8fd8\u4ee5\u4e3a\u662fOracle\u5bf9\u4e8e64m\u7684\u5927\u5c0f\u6709\u9650\u5236\uff0c\u5e76\u975e\u6240\u6709\u7684\u7cfb\u7edf\u90fd\u652f\u6301\u3002\u56e0\u4e3a\u5bf9\u4e8e32K\u7684BLOCK_SIZE\u5c31\u662f\u8fd9\u6837\uff0cWindows\u73af\u5883\u548cLinux\u73af\u5883\u90fd\u662f\u4e0d\u652f\u6301\u7684\uff0c\u83ab\u975e64m\u7684AU_SIZE\u4e5f\u662f\u5f53\u524dLinux\u7cfb\u7edf\u6240\u4e0d\u652f\u6301\u7684\u3002<br \/>\n\u540e\u6765\u53d1\u73b0\u539f\u6765\u5e76\u975e\u662f\u7cfb\u7edf\u4e0d\u652f\u6301\uff0c\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u7adf\u7136\u662fm\u6ca1\u6709\u5927\u5199\uff0c\u5c06\u8bed\u6cd5\u4fee\u6539\u540e\uff0c\u78c1\u76d8\u7ec4\u521b\u5efa\u6210\u529f\uff1a<\/p>\n<pre lang='SQL'>SQL> CREATE DISKGROUP DATA_AU64M EXTERNAL REDUNDANCY DISK '\/dev\/asm-disk1' ATTRIBUTE 'au_size'='64M',\r\n'compatible.asm' = '11.2.0.0.0', 'compatible.rdbms' = '11.2.0.0.0'\r\nDiskgroup created.<\/pre>\n<p>\u6ca1\u60f3\u5230\u4e00\u4e2a\u8868\u793a\u5927\u5c0f\u7684\u5355\u4f4d\u800c\u5df2\uff0cOracle\u4e5f\u8981\u533a\u5206\u5927\u5c0f\u5199\uff0c\u800c\u4e14\u8fd8\u6ca1\u6709\u660e\u786e\u7684\u9519\u8bef\u63d0\u793a\uff0c\u8fd9\u5757\u7684\u5b9e\u73b0\u6709\u70b9\u592a\u4e0d\u4eba\u6027\u5316\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6d4b\u8bd5\u4e0d\u540c\u7684AU_SIZE\u7684\u5f71\u54cd\u65f6\uff0c\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u5efa\u7acbAU_SIZE\u5927\u5c0f\u4e3a64M\u7684\u78c1\u76d8\u7ec4\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\uff1a SQL> create diskgroup data_au64m external redundancy disk &#8216;\/dev\/asm-disk3&#8217; attribute &#8216;au_size&#8217;=&#8217;64m&#8217;,&#8217;compatible.asm&#8217;=&#8217;11.2&#8242;,&#8217;compatible.rdbms&#8217;=&#8217;11.2&#8242;; ORA-15018: diskgroup cannot be created ORA-15238: 64m is not a valid value for attribute au_size \u5f00\u59cb\u8fd8\u4ee5\u4e3a\u662fOracle\u5bf9\u4e8e64m\u7684\u5927\u5c0f\u6709\u9650\u5236\uff0c\u5e76\u975e\u6240\u6709\u7684\u7cfb\u7edf\u90fd\u652f\u6301\u3002\u56e0\u4e3a\u5bf9\u4e8e32K\u7684BLOCK_SIZE\u5c31\u662f\u8fd9\u6837\uff0cWindows\u73af\u5883\u548cLinux\u73af\u5883\u90fd\u662f\u4e0d\u652f\u6301\u7684\uff0c\u83ab\u975e64m\u7684AU_SIZE\u4e5f\u662f\u5f53\u524dLinux\u7cfb\u7edf\u6240\u4e0d\u652f\u6301\u7684\u3002 \u540e\u6765\u53d1\u73b0\u539f\u6765\u5e76\u975e\u662f\u7cfb\u7edf\u4e0d\u652f\u6301\uff0c\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u7adf\u7136\u662fm\u6ca1\u6709\u5927\u5199\uff0c\u5c06\u8bed\u6cd5\u4fee\u6539\u540e\uff0c\u78c1\u76d8\u7ec4\u521b\u5efa\u6210\u529f\uff1a SQL> CREATE DISKGROUP DATA_AU64M EXTERNAL REDUNDANCY DISK &#8216;\/dev\/asm-disk1&#8217; ATTRIBUTE &#8216;au_size&#8217;=&#8217;64M&#8217;, &#8216;compatible.asm&#8217; &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=218\">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":[3],"tags":[155,154,156,153],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-3w","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/218"}],"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=218"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}