配置 Oracle 时出现“ORA-01109 数据库未打开”错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/28114588/
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
"ORA-01109 database did not open" error while configuring Oracle
提问by Haris Tasawar
I am currently having issues configuring Oracle DB 11g on Ubuntu 14.04. I have successfully installed Oracle but the problem comes when I start configuring it.
我目前在 Ubuntu 14.04 上配置 Oracle DB 11g 时遇到问题。我已经成功安装了 Oracle，但是当我开始配置它时问题就来了。
First it was a invalid listener issue, after some extensive searching I found out that I had to put my domain name on 127.0.0.1 which I did (my domain name also contains dashes). After I made those changes, I ran into another error:
首先，这是一个无效的侦听器问题，经过一番广泛搜索后，我发现我必须将我的域名放在 127.0.0.1 上（我的域名也包含破折号）。进行这些更改后，我遇到了另一个错误：
ORA-01109 database not open
I have had no luck with this one. What causes the "database not open" error and how could I fix it?
我对这个没有运气。是什么导致“数据库未打开”错误，我该如何解决？
回答by Oracle Nerd
Try
尝试
ALTER DATABASE OPEN
It should work I guess.
我想它应该可以工作。
Or Give this a try
或者试试这个
$ sqlplus sys/Change12345@orc01 as sysdba
SQL> shut immediate
SQL> startup
and check the status of the instance use
并检查实例使用状态
SQL> select status from v$instance;
