database ORA-1033: 正在进行 ORACLE 初始化或关闭
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18491892/
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-1033: ORACLE initialization or shutdown in progress
提问by Captain Kenpachi
I am stuck with a little Oracle problem. My PC was shut down improperly after my graphics card freaked out, which caused Oracle 11g Express to not properly close down. This means that I get the above error when I try to connect. My PC has been on for 3 hours, and I still get the error, so it is safe to assume that there's something wrong.
我遇到了一个小 Oracle 问题。我的电脑在我的显卡出故障后不正常关闭，导致 Oracle 11g Express 无法正常关闭。这意味着当我尝试连接时出现上述错误。我的 PC 已经开启了 3 个小时，但我仍然收到错误消息，因此可以安全地假设出现了问题。
The usual way of remedying the problem is to use the following sequence of commands from the command line:
解决问题的常用方法是从命令行使用以下命令序列：
sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open;
However, when I give the shutdown command, I get the error
但是，当我发出关闭命令时，出现错误
ORA-12560: TNS:protocol adapter error
ORA-12560: TNS: 协议适配器错误
So now, I can't mount my db. ANy help would be appreciated.
所以现在，我无法挂载我的数据库。任何帮助，将不胜感激。
回答by user2176902
This worked for me:
这对我有用：
- Open the Start menu --> All Programs
- Open folder "Oracle Database 11g Express Edition"
- Choose "Start Database"
- Wait until you get "C:\Windows\system32"
- Open "Run SQL Command Line"and connect to your database
- 打开开始菜单-->所有程序
- 打开文件夹“Oracle Database 11g Express Edition”
- 选择“启动数据库”
- 等到你得到“C:\Windows\system32”
- 打开“运行 SQL 命令行”并连接到您的数据库
回答by Captain Kenpachi
This is probably not necessary or even possible in all cases, but I ended up uninstalling and reinstalling Oracle because I get paid per hour and I'd rather spend that time producing code than wrestling with Oracle.
这可能在所有情况下都不是必需的，甚至是不可能的，但我最终卸载并重新安装了 Oracle，因为我按小时收费，我宁愿花时间编写代码也不愿与 Oracle 搏斗。
回答by winkbrace
My guess would be that your listener service is not running. You can check this by openening the services screen by (in Win7) searching for "services". In the list you should find an Oracle Listener service with status Started.
我的猜测是您的侦听器服务没有运行。您可以通过（在 Win7 中）搜索“服务”打开服务屏幕来检查这一点。在列表中，您应该找到状态为 Started 的 Oracle Listener 服务。
