ORA-01033: ORACLE initialization or shutdown in progress

I keep on getting this error when i shutdown my vm improperly.
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
SP2-0751: Unable to connect to Oracle.

Very simple solution is to do below –

> login as sysdba
$sqlplus sys/password@SERVICE as SYSDBA
SQL> recover database until cancel;
SQL> alter database open resetlogs;

Let me know if this doesn’t work for you…

Be Sociable, Share!

Leave a Reply

Your email address will not be published. Required fields are marked *