Oracle Shutdown Error Ora-01033

How to resolve ORA-011033: ORACLE initialization or shutdown in progress

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

Getting ORA-01033: ORACLE initialization or shutdown in progress

I've had the same problem and just want to share my solution with you, if anybody else gets the ORA-01033: ORACLE initialization or shutdown in progress
Error in Oracle 12c Database. My database showed me the error everytime i tried to connect to a user of a sample schema (for ex. hr).

The following worked for me:

SQLPlus> connect sys as sysdba
SQLPlus> alter pluggable database all open; 

oracle initialization or shutdown in progress error

Seems that your redo log file is corrupted. It's required to clear redo log.....

You can follow following steps for the same:

Assuming that your database is on mount state and login as a sys with sysdba privilege:

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

shutdown immediate;

Again, login as a sys with sysdba privileges(i.e. sqlplus sys as sysdba)

startup mount;

alter database open resentlogs;

recover database until cancel; --Here, you need to press when it prompts to specify a log.

alter database open resetlogs;

startup;

alter system set "_allow_resetlogs_corruption"=false scope=spfile; --Reverting back and bouncing the db for applying the changes.

shutdown immedaite;

startup;

---

Related Topics