{"id":209900,"date":"2022-08-21T14:52:05","date_gmt":"2022-08-21T06:52:05","guid":{"rendered":"https:\/\/www.keaglegz.com\/209900.html"},"modified":"2022-08-21T14:52:05","modified_gmt":"2022-08-21T06:52:05","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e5%90%af%e5%8a%a8%e6%97%b6%e6%8a%a5ora-00845%e9%94%99%e8%af%af%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.dongwubaike.cn\/fanhao\/209900.html","title":{"rendered":"\u6570\u636e\u5e93\u542f\u52a8\u65f6\u62a5ORA-00845\u9519\u8bef\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"\n

\u95ee\u9898\u63cf\u8ff0<\/span><\/strong>\uff1a\u5de1\u68c0\u65f6\u53d1\u73b0\u67d0\u4e00\u4e2a\u8282\u70b9\u6570\u636e\u5e93<\/span>down\u4e86\uff0c\u901a\u8fc7<\/span>sqlplus \u8fdb\u884c\u7cfb\u7edf\u65f6\u663e\u793a\u8fde\u63a5\u7684\u662f\u4e00\u4e2a\u7a7a\u5b9e\u4f8b\uff0c\u5c1d\u8bd5\u901a\u8fc7<\/span>startup\u91cd\u542f\u6570\u636e\u5e93\u62a5\u9519\uff0c\u63d0\u793a<\/span>MEMORY_TARGETnot supported on this system\uff0c\u67e5\u770b\u544a\u8b66\u65e5\u5fd7\u62a5<\/span>MEMORY_TARGET\u5931\u8d25\uff0c\u8981\u589e\u52a0<\/span>\/dev\/shm\u5927\u5c0f\u624d\u53ef\u4ee5\u89e3\u51b3\u95ee\u9898<\/span><\/p>\n

\u767b\u5f55\u6570\u636e\u5e93\u65f6\u62a5\u9519\u4fe1\u606f\u5982\u4e0b\uff1a<\/span><\/p>\n

[Oracle@db01 ~]$ sqlplus \/ as sysdba<\/p>\n

SQL*Plus: Release 11.2.0.4.0 Productionon Mon Oct 30 09:26:35 2017<\/p>\n

Copyright (c) 1982, 2013, Oracle.  All rights reserved.<\/p>\n

Connected to an idle instance.<\/p>\n

SQL> startup <\/p>\n

ORA-00845: MEMORY_TARGET not supported on this system<\/span><\/p>\n

\u540e\u53f0\u65e5\u5fd7\u62a5\u5982\u4e0b\u4fe1\u606f\uff1a<\/span><\/p>\n

Starting ORACLE instance (normal)<\/p>\n

WARNING: You are trying to use theMEMORY_TARGET feature. This feature requires the \/dev\/shm file system to bemounted for at least 13522436096 bytes. \/dev\/shm is either not mounted or ismounted with available space less than this size. Please fix this so that MEMORY_TARGETcan work as expected. Current available is 12203786240 and used is 454021120bytes. Ensure that the mount point is \/dev\/shm for this directory.<\/p>\n

memory_target needs larger \/dev\/shm<\/p>\n

\u95ee\u9898\u5206\u6790<\/span><\/strong>\uff1a<\/span><\/p>\n

\u7531\u4e8e<\/span>Oracle11g\u4e2d\u4f7f\u7528\u7684\u662f<\/span>AMM\uff0c\u5f53<\/span>MEMORY_TARGET\u5927\u4e8e<\/span>\/dev\/shm\u65f6\u5c31\u63d0\u793a\u4e0d\u652f\u6301\u6b64\u7cfb\u7edf\uff0c\u4ece\u800c\u62a5\u9519\u65e0\u6cd5\u542f\u52a8\u6570\u636e\u5e93\uff0c\u7531\u4e8e<\/span>\/dev\/shm\u662f\u901a\u8fc7<\/span>tmpfs\u901a\u8fc7\u5927\u5c0f\u7684\uff0c\u5728<\/span>Linux\u73af\u5883\u4e2d\u53ef\u4ee5\u901a\u8fc7\u4fee\u6539\u6b64\u5927\u5c0f\u89e3\u51b3\u95ee\u9898<\/span><\/p>\n

\u89e3\u51b3\u65b9\u6cd5<\/span>\uff1a<\/span><\/strong><\/p>\n

1\u3001  <\/span>\u67e5\u770b\u5f53\u524d\u7684<\/span>tmpfs\u5927\u5c0f\u4fe1\u606f<\/span><\/p>\n

[oracle@i60001~]$ df -h<\/p>\n

Filesystem                     Size  Used Avail Use% Mounted on<\/p>\n

\/dev\/mapper\/vg_db01-LogVol02  229G  65G  153G  30% \/<\/p>\n

tmpfs                            12G  434M  12G<\/span>  4% \/dev\/shm—<\/span>\u6b64\u5904\u8981\u4fee\u6539<\/span><\/p>\n

\/dev\/sde1                      485M  40M 420M  9% \/boot<\/p>\n

\/dev\/mapper\/vg_db01-LogVol00  30G 5.0G  24G  18% \/usr<\/p>\n

[oracle@i60001~]$ mount -o size=20G -onr_inodes=1000000 -o noatime,nodiratime -o<\/span> remount \/dev\/shm<\/p>\n

mount: onlyroot can do that<\/p>\n

\u4fee\u6539<\/span>tmpfs\u5927\u5c0f\u8981\u901a\u8fc7<\/span>root\u7528\u6237\u4e0b\u9762\u64cd\u4f5c\uff0c\u5207\u6362\u5230<\/span>root\u7528\u6237<\/span><\/p>\n

[oracle@i60001~]$ su root<\/p>\n

Password:<\/p>\n

2\u3001\u4fee\u6539<\/span>tmpfs\u5927\u5c0f<\/span><\/p>\n

[root@db01oracle]#  mount -o size=20G -o nr_inodes=1000000 -o noatime,nodiratime-o<\/span> remount \/dev\/shm<\/p>\n

[root@db01oracle]# df -h<\/p>\n

Filesystem                      Size  Used Avail Use% Mounted on<\/p>\n

\/dev\/mapper\/vg_db01-LogVol02  229G  65G  153G  30% \/<\/p>\n

tmpfs                            20G  434M  20G<\/span>  3% \/dev\/shm–\u4fee\u6539\u540e\u7684\u5927\u5c0f<\/span><\/p>\n

\/dev\/sde1                       485M  40M 420M  9% \/boot<\/p>\n

\/dev\/mapper\/vg_db01-LogVol00  30G 5.0G  24G  18% \/usr<\/p>\n

3\u3001\u4fee\u6539<\/span>tmpfs\u5927\u5c0f\u540e\uff0c\u518d\u767b\u5f55\u6570\u636e\u5e93\u4e2d\u91cd\u542f\u5b9e\u4f8b<\/span><\/p>\n

[oracle@db01~]$ sqlplus \/ as sysdba<\/p>\n

SQL*Plus:Release 11.2.0.4.0 Production on Mon Oct 30 09:42:02 2017<\/p>\n

Copyright (c)1982, 2013, Oracle.  All rights reserved.<\/p>\n

Connected toan idle instance.<\/p>\n

SQL>startup;    <\/p>\n

ORACLEinstance started.<\/p>\n

Total SystemGlobal Area 1.3462E+10 bytes<\/p>\n

Fixed Size             2265984 bytes<\/p>\n

Variable Size               7381978240 bytes<\/p>\n

DatabaseBuffers       6039797760 bytes<\/p>\n

Redo Buffers                38014976 bytes<\/p>\n

Databasemounted.<\/p>\n

Database opened.<\/span>–\u663e\u793a\u542f\u52a8\u6210\u529f<\/span><\/p>\n

—\u67e5\u8be2\u5f53\u524d\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u662f\u5426\u6b63\u5e38<\/span><\/p>\n

SQL>select open_mode from v$database;<\/p>\n

OPEN_MODE<\/p>\n

——————–<\/p>\n

READ WRITE<\/p>\n

\u66f4\u591aOracle\u76f8\u5173\u4fe1\u606f\u89c1<\/span>Oracle<\/span> \u4e13\u9898\u9875\u9762 <\/span>http:\/\/www.linuxidc.com\/topicnews.aspx?tid=12<\/span><\/span><\/p>\n

\u672c\u6587\u6c38\u4e45\u66f4\u65b0\u94fe\u63a5\u5730\u5740<\/strong><\/span>\uff1ahttp:\/\/www.linuxidc.com\/Linux\/2018-01\/150042.htm<\/p>\n

\"\u6570\u636e\u5e93\u542f\u52a8\u65f6\u62a5ORA-00845\u9519\u8bef\u89e3\u51b3\u65b9\u6cd5\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u95ee\u9898\u63cf\u8ff0 \uff1a\u5de1\u68c0\u65f6\u53d1\u73b0\u67d0\u4e00\u4e2a\u8282\u70b9\u6570\u636e\u5e93 down\u4e86\uff0c\u901a\u8fc7 sqlplus \u8fdb\u884c\u7cfb\u7edf\u65f6\u663e\u793a\u8fde\u63a5\u7684\u662f\u4e00\u4e2a\u7a7a\u5b9e\u4f8b\uff0c\u5c1d\u8bd5\u901a\u8fc7 startup\u91cd\u542f\u6570\u636e\u5e93\u62a5\u9519\uff0c\u63d0\u793a MEMORY_TARGETnot supported on this system\uff0c\u67e5\u770b\u544a\u8b66\u65e5\u5fd7\u62a5 MEMORY_TARGET\u5931\u8d25\uff0c\u8981\u589e\u52a0 \/dev\/shm\u5927\u5c0f\u624d\u53ef\u4ee5\u89e3\u51b3\u95ee\u9898<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[10316],"class_list":["post-209900","post","type-post","status-publish","format-standard","hentry","tag-eature"],"_links":{"self":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts\/209900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/comments?post=209900"}],"version-history":[{"count":0,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/posts\/209900\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/media?parent=209900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/categories?post=209900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dongwubaike.cn\/fanhao\/wp-json\/wp\/v2\/tags?post=209900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}