ORA-01033: ORACLE initialization or shutdown in progress

Actually , while trying to find out the problem , the archive log was full and removed some of the archived log file to create the space Now another problem came i.e. oracale initalization or shutdown in progress.

Solution 1:

if you have a backup of the database + archive logs: restore and recover

without backup, the tablespace became useless: drop it while in mount mode, then open the database

i.e.

sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open;

Sometime the above syntax dont work resulting the following error

ORA-00600: internal error code, arguments: [kcratr1_lostwrt]

Under this situation follow the following steps:

SQL> startup mount

ORACLE Instance started

SQL> recover database 

Media recovery complete

SQL> alter database open

Database altered