ORA-01033: ORACLE initialization or shutdown in progress

I am sure you reading this post because you've got this ORA-01033 error message.

 

Quickly without wasting time here is the solution:

I have noticed this error happened when the database has not been properly shutdown .

1. Go to the command prompt CMD:
2. > set oracle_sid= your_sid_name
3. > sqlplus /nolog
4. SQL> connect / as sysdba
5. output: connected
6. SQL> shutdown abort
7. output: ORACLE instance shut down
8. SQL> startup nomount
9. output: ORACLE instance started
10. SQL> alter database mount
11. output: Database altered
12. SQL> alter database open
13. output: Database altered
14.  Done !