database 如何解决 ORA-011033：正在进行 ORACLE 初始化或关闭
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/53676/
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
How to resolve ORA-011033: ORACLE initialization or shutdown in progress
提问by rohancragg
When trying to connect to an ORACLEuser via TOAD (Quest Software) or any other means (Oracle Enterprise Manager) I get this error:
尝试ORACLE通过 TOAD（Quest 软件）或任何其他方式 ( Oracle Enterprise Manager)连接到用户时，出现此错误：
ORA-011033: ORACLE initialization or shutdown in progress
ORA-011033: ORACLE initialization or shutdown in progress
回答by rohancragg
After some googling, I found the advice to do the following, and it worked:
经过一番谷歌搜索后，我找到了执行以下操作的建议，并且奏效了：
SQL> startup mount
ORACLE Instance started
SQL> recover database
Media recovery complete
SQL> alter database open;
Database altered
回答by zee
Here is my solution to this issue:
这是我对这个问题的解决方案：
SQL> Startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 1904054272 bytes
Fixed Size 2404024 bytes
Variable Size 570425672 bytes
Database Buffers 1325400064 bytes
Redo Buffers 5824512 bytes
Database mounted.
SQL> Show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string C:\APP\USER\ORADATA\ORACLEDB\C
ONTROL01.CTL, C:\APP\USER\FAST
_RECOVERY_AREA\ORACLEDB\CONTRO
L02.CTL
SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
b.group# and b.status='CURRENT'
2
SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
b.group# and b.status='CURRENT';
MEMBER
--------------------------------------------------------------------------------
GROUP# STATUS
---------- ----------------
C:\APP\USER\ORADATA\ORACLEDB\REDO03.LOG
3 CURRENT
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1904054272 bytes
Fixed Size 2404024 bytes
Variable Size 570425672 bytes
Database Buffers 1325400064 bytes
Redo Buffers 5824512 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 4234808 generated at 01/21/2014 18:31:05 needed for thread 1
ORA-00289: suggestion :
C:\APP\USER\FAST_RECOVERY_AREA\ORACLEDB\ARCHIVELOG14_01_22\O1_MF_1_108_%U_.AR
C
ORA-00280: change 4234808 for thread 1 is in sequence #108
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\APP\USER\ORADATA\ORACLEDB\REDO03.LOG
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
And it worked:
它起作用了：
回答by Witold Kaczurba
I had a similar problem when I had installed the 12c database as per Oracle's tutorial. The instruction instructs reader to create a PLUGGABLE DATABASE (pdb).
当我按照Oracle 的教程安装 12c 数据库时，我遇到了类似的问题。该指令指示读者创建一个可插拔数据库（pdb）。
The problem
问题
sqlplus hr/hr@pdborclwould result in ORACLE initialization or shutdown in progress.
sqlplus hr/hr@pdborcl会导致ORACLE initialization or shutdown in progress.
The solution
解决方案
Login as
SYSDBAto the dabase:sqlplus SYS/Oracle_1@pdborcl AS SYSDBA
Alter database:
alter pluggable database pdborcl open read write;
Login again:
sqlplus hr/hr@pdborcl
登录
SYSDBA到数据库：sqlplus SYS/Oracle_1@pdborcl AS SYSDBA
更改数据库：
alter pluggable database pdborcl open read write;
再次登录：
sqlplus hr/hr@pdborcl
That worked for me
那对我有用
Some documentation here
一些文档在这里
回答by JoshL
This error can also occur in the normal situation when a database is starting or stopping. Normally on startup you can wait until the startup completes, then connect as usual. If the error persists, the service(on a Windows box) may be started without the databasebeing started. This may be due to startup issues, or because the service is not configured to automatically start the database. In this case you will have to connect as sysdba and physically start the database using the "startup" command.
在数据库启动或停止时的正常情况下，也会发生此错误。通常在启动时，您可以等到启动完成，然后照常连接。如果错误仍然存在，则服务（在 Windows 机器上）可能会在没有启动数据库的情况下启动。这可能是由于启动问题，或者因为该服务未配置为自动启动数据库。在这种情况下，您必须以 sysdba 身份连接并使用“启动”命令物理启动数据库。
回答by gadildafissh
I used a combination of the answers from rohancragg, Mukul Goel, and NullSoulException from above. However I had an additional error:
我结合了 rohancragg、Mukul Goel 和上面的 NullSoulException 的答案。但是我有一个额外的错误：
ORA-01157: cannot identify/lock data file string - see DBWR trace file
ORA-01157: 无法识别/锁定数据文件字符串 - 请参阅 DBWR 跟踪文件
To which I found the answer here: http://nimishgarg.blogspot.com/2014/01/ora-01157-cannot-identifylock-data-file.html
我在这里找到了答案：http: //nimishgarg.blogspot.com/2014/01/ora-01157-cannot-identifylock-data-file.html
Incase the above post gets deleted I am including the commands here as well.
如果上面的帖子被删除，我也在这里包含了命令。
C:\>sqlplus sys/sys as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 30 19:07:16 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 778387456 bytes
Fixed Size 1384856 bytes
Variable Size 520097384 bytes
Database Buffers 251658240 bytes
Redo Buffers 5246976 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 11 – see DBWR trace file
ORA-01110: data file 16: 'E:\oracle\app\nimish.garg\oradata\orcl\test_ts.dbf'
SQL> select NAME from v$datafile where file#=16;
NAME
--------------------------------------------------------------------------------
E:\ORACLE\APP\NIMISH.GARG\ORADATA\ORCL\TEST_TS.DBF
SQL> alter database datafile 16 OFFLINE DROP;
Database altered.
SQL> alter database open;
Database altered.
Thanks everyone you saved my day!
谢谢大家，你们拯救了我的一天！
Fissh
鱼
回答by Alan Hollis
The issue can also be due to lack of hard drive space. The installation will succeed but on startup, oracle won't be able to create the required files and will fail with the same above error message.
该问题也可能是由于硬盘空间不足造成的。安装会成功，但在启动时，oracle 将无法创建所需的文件，并且会失败并显示与上述相同的错误消息。
回答by Goku
I hope this will help somebody, I solved the problem like this
我希望这会帮助某人，我解决了这样的问题
There was a problem because the database was not open. Command startup opens the database.
出现问题，因为数据库未打开。命令启动打开数据库。
This you can solve with command alter database openin some case with alter database open resetlogs
alter database open在某些情况下， 您可以使用命令解决此问题alter database open resetlogs
$ sqlplus / sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 8628936 bytes
Variable Size 624952632 bytes
Database Buffers 436207616 bytes
Redo Buffers 3952640 bytes
Database mounted.
Database opened.
SQL> conn user/pass123
Connected.
回答by Hari
I faced the same problem. I restarted the oracle service for that DB instance and the error is gone.
我遇到了同样的问题。我重新启动了该数据库实例的 oracle 服务，错误消失了。
