Posted in Oracle, Oracle Problems & Solutions, Oracle Solutions, Sql Problems. Tagged in ORA-01033: ORACLE initialization or shutdown in progress, oracle, oracle database, shutdown modes in oracle. Shortlink. 5 Comments.
Yesterday when i tried to login into my application , i could not login into my account . I was unable to login with the following error. But datbase was in open state.
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.
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
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