ORA-01033: ORACLE Initialization or Shutdown in progress

CAUSE

when database was not shutdown properly for example hanged database or abnormal shutdown of server due to power etc.

SOLUTION

First Try:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL> shutdown;
OR
SQL> shutdown immediate;

SQL> startup mount;

Then note the error massege and do accordingly.

SQL> alter database recover database until cancel;

if the above command fails try

SQL> recover database using backup controlfile until cancel;

on success type

SQL> ALTER DATABASE OPEN RESETLOGS;

Then stop and restart oracle service.

Second Try:

[oracle@localhost ~]$ sqlplus / as sysdba

SQL> shutdown abort;

SQL> startup nomount

SQL> alter database mount;

SQL> alter database open;

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01245: offline file 1 will be lost if RESETLOGS is done
ORA-01110: data file 1: '/u01/app/oracle/oradata/sr/system01.dbf'

RECOVER DATAFILE

SQL> alter database datafile '/u01/app/oracle/oradata/gh/system01.dbf' offline drop;

SQL> alter database datafile '/u01/app/oracle/oradata/gh/system01.dbf' online;

Database altered.

SQL> alter database open NORESETLOGS;

Database altered.

SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup;
ORACLE instance started.

Total System Global Area 2042241024 bytes
Fixed Size 1337548 bytes
Variable Size 553649972 bytes
Database Buffers 1476395008 bytes
Redo Buffers 10858496 bytes
Database mounted.
Database opened.

SQL>