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

databaseoracle

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

ORA-011033: ORACLE initialization or shutdown in progress

Best Solution

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