7 Replies Latest reply: Mar 22, 2014 1:59 PM by zain.mr89 RSS

    ORA-01033: ORACLE initialization or shutdown in progress

    zain.mr89

      My oracle 11g -R2 database was working fine but now its showing this error :-

      ERROR:

      ORA-01033: ORACLE initialization or shutdown in progress

      Process ID: 0

      Session ID: 0 Serial number: 0

       

      I searched internet and was found out to do following steps :-

      step1: connect / as sysdba
      step2: shutdown immediate;
      step3: startup mount;
      step4: alter database recover;
      step5: alter database open;
      step6: exit;


      when i wrote "alter database recover;" it showed this error that's why further steps were not performed :-

      "ORA-00283: recovery session canceled due to errors

      ORA-01610: recovery using the BACKUP CONTROLFILE option must be done"


      I again searched internet and tried these steps :-

      step1: connect / as sysdba

      step2: select status, database_status from v$instance; (status column was shown as "mounted" on this query)

      step3: alter database mount;     (skipped this step as database was already mounted)

      step4: select open_mode from v$database; (status column showed "mounted")

      step5: exit;

      step6: connect / as sysdba

      step7: alter database open;

      step8: select status, database_status from v$instance;

      step9: select open_mode from v$database;


      On step#7 it showed following error that's why further steps were not performed :-

      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


      Please help me out.