{"id":4800,"date":"2020-12-28T20:38:50","date_gmt":"2020-12-28T12:38:50","guid":{"rendered":"http:\/\/www.menglanglang.cn\/?p=4800"},"modified":"2020-12-28T20:43:58","modified_gmt":"2020-12-28T12:43:58","slug":"ora-27101shared-memory-realm-does-not-exist","status":"publish","type":"post","link":"http:\/\/www.menglanglang.cn\/?p=4800","title":{"rendered":"ORA-27101:shared memory realm does not exist"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5728\u901a\u8fc7 PLSQL \u8fde\u63a5 Oracle \u6570\u636e\u5e93\u65f6\uff0c\u5982\u679c\u63d0\u793a\u5982\u4e0b\u9519\u8bef\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"222\" src=\"\/\/images.weserv.nl\/?url=https:\/\/img-blog.csdnimg.cn\/20201017182940367.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R6aHV3Yg==,size_16,color_FFFFFF,t_70\" width=\"454\"\/>\u200b<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>ORA-01034:ORACLE not available<\/p><p>ORA-27101:shared memory realm does not exist<\/p><p>\u8fdb\u7a0b ID: 0<\/p><p>\u4f1a\u8bdd ID: 0 \u5e8f\u5217\u53f7: 0<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u6709\u7684\u8bf4\u5427 Oracle \u76d1\u542c\u670d\u52a1\u91cd\u542f\uff0c\u8bd5\u4e86\u4e0b\u4e0d\u597d\u7528\uff01\uff01\uff01\u8fd8\u6709\u4e00\u79cd\u89e3\u51b3\u65b9\u5f0f\uff0c\u53ef\u4ee5\u4e00\u8bd5~<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7b2c\u4e00\u6b65\uff0c\u547d\u4ee4\u884c\u6a21\u5f0f\u4e0b\u5206\u522b\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>sqlplus \/nolog<br \/>conn \/ as sysdba<br \/>startup<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u7ed3\u679c\u5982\u56fe\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" height=\"429\" width=\"664\" alt=\"\" src=\"\/\/images.weserv.nl\/?url=https:\/\/img-blog.csdnimg.cn\/20201017183711223.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R6aHV3Yg==,size_16,color_FFFFFF,t_70\"\/><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u518d\u6b21\u7528 PLSQL \u8fde\u63a5\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7b2c\u4e8c\u6b65\uff0c\u5982\u679c\u8fd8\u662f\u65e0\u6cd5\u8fde\u63a5\uff0c\u53ef\u4ee5\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">show parameter background_dump_dest;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u83b7\u53d6\u8ddf\u8e2a\u65e5\u5fd7\u8def\u5f84\uff0c\u67e5\u770b\u65e5\u5fd7\u4fe1\u606f\uff0c\u5982\uff1aC:\\app\\Administrator\\diag\\rdbms\\orcl\\orcl\\trace\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53ef\u4ee5\u770b\u5230\u8fd9\u91cc\u539f\u56e0\u662f\u5f52\u6863\u65e5\u5fd7\u7a7a\u95f4\u5df2\u6ee1\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" height=\"508\" width=\"900\" alt=\"\" src=\"\/\/images.weserv.nl\/?url=https:\/\/img-blog.csdnimg.cn\/20201017190834913.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R6aHV3Yg==,size_16,color_FFFFFF,t_70\"\/><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u51b3\u529e\u6cd5\u4e00\uff1a\u6269\u5c55\u7a7a\u95f4\u5927\u5c0f<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>select * from v$recovery_file_dest;<br \/>&#8211;\u4fee\u6539\u7a7a\u95f4\u5927\u5c0f\uff0c\u8fd9\u91cc\u662f\u6539\u4e3a10G\u3002<br \/>alter system set db_recovery_file_dest_size=10737418240<br \/>alter database open<br \/>exit<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u51b3\u529e\u6cd5\u4e8c\uff1a\u5220\u9664\u8fc7\u671f\u5f52\u6863\u65e5\u5fd7<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>&#8211;\u8fdb\u5165rman\u5de5\u5177\u7a97\u53e3<br \/>rman target \/<br \/>&#8211;\u8fd0\u884c\u8fd9\u4e2a\u547d\u4ee4\u53ef\u4ee5\u628a\u65e0\u6548\u7684\u7684archivelog\u6807\u51fa\u6765<br \/>RMAN&gt;crosscheck archivelog all;<br \/>&#8211;\u76f4\u63a5\u5168\u90e8\u5220\u9664\u8fc7\u671f\u7684\u5f52\u6863\u65e5\u5fd7<br \/>RMAN&gt;delete expired archivelog all;<br \/>&#8211;\u6216\u8005\u76f4\u63a5\u7528\u4e00\u4e2a\u6307\u5b9a\u7684\u65e5\u671f\u6765\u5220\u9664<br \/>RMAN&gt;delete noprompt archivelog until time &#8220;sysdate -3&#8221;;<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u7a7a\u95f4\u5927\u5c0f\u95ee\u9898\u89e3\u51b3\u540e\uff0c\u9700\u8981\u518d\u6b21\u6267\u884c\u7b2c\u4e00\u6b65\u8fdb\u884c\u91cd\u65b0\u88c5\u8f7d\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u7136\u540e\u518d\u5c1d\u8bd5\u8fde\u63a5\u6570\u636e\u5e93\u5373\u53ef\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u539f\u6587\u94fe\u63a5\uff1a<a href=\"https:\/\/blog.csdn.net\/tzhuwb\/article\/details\/109136526\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.csdn.net\/tzhuwb\/article\/details\/109136526<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u901a\u8fc7 PLSQL \u8fde\u63a5 Oracle \u6570\u636e\u5e93\u65f6\uff0c\u5982\u679c\u63d0\u793a\u5982\u4e0b\u9519\u8bef\uff1a \u200b ORA &hellip; <a href=\"http:\/\/www.menglanglang.cn\/?p=4800\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ai_generated_summary":"","wpai_meta_description":"","footnotes":""},"categories":[796],"tags":[335,679,681,750,828],"class_list":["post-4800","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-error","tag-oracle","tag-plsql","tag-750","tag-828"],"_links":{"self":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/4800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4800"}],"version-history":[{"count":3,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/4800\/revisions"}],"predecessor-version":[{"id":4804,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/4800\/revisions\/4804"}],"wp:attachment":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4800"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}