如何解决ORA-011033：ORACLE初始化或关闭进行中 [英] How to resolve ORA-011033: ORACLE initialization or shutdown in progress

问题描述

当尝试通过TOAD（Quest Software）或任何其他方式（Oracle企业管理器）连接到ORACLE用户时，我只遇到错误：

When trying to connect to an ORACLE user via TOAD (Quest Software) or any other means (Oracle Enterprise Manager) I simply get the error:

ORA-011033：ORACLE初始化或
正在关闭

ORA-011033: ORACLE initialization or shutdown in progress

---

[在StackOverflow的精神，我会回答这一个自己 - 至少我会告诉我如何解决它在我的情况 - 请也关联你自己的这样的冒险...]

---

[in the spirit of StackOverflow I will answer this one myself - at least I'll relate how I resolved it in my case - please also relate your own such adventures...]

推荐答案

在一些googling之后，我发现了以下建议：

After some googling I found the advice to do the following:

> sqlplus /nolog

SQL> connect / as sysdba

Connected.

SQL> shutdown abort

ORACLE Instance shut down.

SQL> startup nomount

ORACLE Instance started

SQL> alter database mount;

SQL> alter database open;

其中仍出现错误：

ORA-00600：内部错误代码，参数：[kcratr1_lostwrt]

ORA-00600: internal error code, arguments: [kcratr1_lostwrt]

SQL> startup mount

ORACLE Instance started

SQL> recover database 

Media recovery complete

SQL> alter database open;

Database altered

这篇关于如何解决ORA-011033：ORACLE初始化或关闭进行中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！