Oracle 共享内存域不存在
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15644862/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle shared memory realm does not exist
提问by Jap Evans
I am running Oracle 11 on a windows 7 machine. I have this strange problem from this morning. When i try to connect to the database, it says 'shared memory realm does not exist'. However when i use Database Configuration Assistant, select a database and click next, it does 'retrieving database information'. During that time, when i connect to database it says 'Oracle shutdown in progress' message. Once the 'retrieving database information' is done (and i dont go beyond that step in Database Configuration Assistant') I am able to connect to the database without any issues.
我在 Windows 7 机器上运行 Oracle 11。从今天早上我就有这个奇怪的问题。当我尝试连接到数据库时，它说“共享内存领域不存在”。但是，当我使用数据库配置助手时，选择一个数据库并单击下一步，它会“检索数据库信息”。在那段时间里，当我连接到数据库时，它显示“Oracle 正在关闭”消息。一旦“检索数据库信息”完成（并且我不会超出数据库配置助手中的那一步），我就可以毫无问题地连接到数据库。
I compared the environment variables and the windows services running before and after working and its all the same.
我比较了环境变量和工作前后运行的windows服务，都是一样的。
Question is, what does 'retrieving database information' in Database Configuration Assistant do that fixes 'Shared memory realm does not exist' problem?
问题是，数据库配置助手中的“检索数据库信息”做了什么来修复“共享内存领域不存在”的问题？
Any suggestions would be helpful.
任何的意见都将会有帮助。
P.S. I checked other questions related to this subject in stackoverflow and didnt find anything useful or i did not understand it properly. So please do not close this question as duplicate.
PS我在stackoverflow中检查了与这个主题相关的其他问题，但没有发现任何有用的东西，或者我没有正确理解它。所以请不要将这个问题作为重复关闭。
回答by Jap Evans
Thanks Guys
谢谢你们
I resolved the issue by doing the below.
我通过执行以下操作解决了该问题。
1) Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Administration Assistant for Windows.
2) Right-click the SID.
3) Choose Startup/Shutdown Options.
4) Choose the Oracle Instance tab.
1) 选择开始 > 程序 > Oracle - HOME_NAME > 配置和迁移工具 > Windows 管理助手。
2) 右键单击 SID。
3) 选择启动/关闭选项。
4) 选择 Oracle 实例选项卡。
Select Start up instance when service is started, Shut down instance when service is stopped, or both.
选择服务启动时启动实例、服务停止时关闭实例，或两者都选择。
I restarted the machine and it worked.
我重新启动了机器，它工作了。
