Solution to: ORA-01033: ORACLE initialization or shutdown in progress

ORA-01033  error occurs when client is not connected to the Oracle Databas,it is in the process of initializing or shutting down and when the database service is in the process of starting or stopping.
This error message indicates that the database has crashed.

cmd>sqlplus mining/mining@mining


ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

cmd--> sqlplus /nolog

connected

C:\>set ORACLE_SID=mining

SQL>conn sys/sys as sysdba
connected
SQL> shut abort
SQL>startup mount
SQL>recover database
SQL>alter database open;

If, you directly give the :
SQL>startup

possibly,it will show the following error.

ORA-01172: recovery of thread 1 stuck at block 9 of file 2

ORA-01151: use media recovery to recover block, restore backup if needed.