10 Replies Latest reply: Mar 29, 2012 3:22 AM by 927194 RSS

    ORA-01033: ORACLE initialization or shutdown in progress

    927194
      Hi,

      I am using Oracle 11g R1 on my Windows XP OS. When i try to login, I am getting the following error:

      ERROR:
      ORA-01033: ORACLE initialization or shutdown in progress

      Oracle and Listener services are all started.

      When i try the following,
      SQL>connect sys/manager as sysdba
      SQL>shutdown immediate
      SQL>startup

      I am getting the following errors:

      ORA-01157: cannot identify/lock data file 2- see DBWR trace file
      ORA-01110: data file 2: 'C:\.....\ORADATA\ORCL\SYSAUX01.DBF'

      Please help me.
        • 1. Re: ORA-01033: ORACLE initialization or shutdown in progress
          819493
          Hi,

          Given the error message, please verify that the data file mentioned in the message exists, and is writable for the oracle-user
          ORA-01157: cannot identify/lock data file 2- see DBWR trace file
          ORA-01110: data file 2: 'C:\.....\ORADATA\ORCL\SYSAUX01.DBF'
          Also, can you post the relevant lines from the alert-log (%ORACLE_BASE%/diag/rdbms/%ORACLE_SID%/%ORACLE_SID%/trace/alert_%ORACLE_SID%.log)

          HtH
          Johan
          • 2. Re: ORA-01033: ORACLE initialization or shutdown in progress
            NikolayIvankin
            Welcome to OTN!
            924191 wrote:
            ERROR:
            ORA-01033: ORACLE initialization or shutdown in progress

            When i try the following,
            SQL>connect sys/manager as sysdba
            SQL>shutdown immediate
            SQL>startup

            I am getting the following errors:

            ORA-01157: cannot identify/lock data file 2- see DBWR trace file
            ORA-01110: data file 2: 'C:\.....\ORADATA\ORCL\SYSAUX01.DBF'
            Instance can't open sysaux.dbf while trying to open, and remains in mount state. Therefore you obtain ORA-01033 when try to connect under non-sysdba user.
            Post alert.log
            • 3. Re: ORA-01033: ORACLE initialization or shutdown in progress
              927194
              Hi,

              Thanks for your answer.

              The file SYSAUX01.DBF exists. But it is an empty file. It has no content in it.

              alert-log has the following contents:


              Starting up ORACLE RDBMS Version: 11.1.0.6.0.
              Using parameter settings in server-side spfile C:\APP\ARIVAV\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
              System parameters with non-default values:
              processes = 150
              memory_target = 820M
              control_files = "C:\APP\ARIVAV\ORADATA\ORCL\CONTROL01.CTL"
              control_files = "C:\APP\ARIVAV\ORADATA\ORCL\CONTROL02.CTL"
              control_files = "C:\APP\ARIVAV\ORADATA\ORCL\CONTROL03.CTL"
              db_block_size = 8192
              compatible = "11.1.0.0.0"
              db_recovery_file_dest = "C:\app\arivav\flash_recovery_area"
              db_recovery_file_dest_size= 2G
              undo_tablespace = "UNDOTBS1"
              remote_login_passwordfile= "EXCLUSIVE"
              db_domain = ""
              dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
              audit_file_dest = "C:\APP\ARIVAV\ADMIN\ORCL\ADUMP"
              audit_trail = "DB"
              db_name = "orcl"
              open_cursors = 300
              diagnostic_dest = "C:\APP\ARIVAV"
              Thu Mar 29 14:31:02 2012
              PMON started with pid=2, OS id=1516
              Thu Mar 29 14:31:02 2012
              VKTM started with pid=3, OS id=772 at elevated priority
              VKTM running at (20)ms precision
              Thu Mar 29 14:31:02 2012
              DIAG started with pid=4, OS id=7484
              Thu Mar 29 14:31:02 2012
              DBRM started with pid=5, OS id=2416
              Thu Mar 29 14:31:02 2012
              DSKM started with pid=7, OS id=7552
              Thu Mar 29 14:31:02 2012
              DIA0 started with pid=8, OS id=6608
              Thu Mar 29 14:31:02 2012
              MMAN started with pid=9, OS id=7872
              Thu Mar 29 14:31:02 2012
              DBW0 started with pid=7, OS id=8024
              Thu Mar 29 14:31:02 2012
              LGWR started with pid=10, OS id=7668
              Thu Mar 29 14:31:02 2012
              CKPT started with pid=11, OS id=8100
              Thu Mar 29 14:31:03 2012
              SMON started with pid=12, OS id=7788
              Thu Mar 29 14:31:03 2012
              RECO started with pid=13, OS id=5736
              Thu Mar 29 14:31:03 2012
              MMON started with pid=14, OS id=2860
              starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
              Thu Mar 29 14:31:03 2012
              MMNL started with pid=15, OS id=5692
              starting up 1 shared server(s) ...
              ORACLE_BASE from environment = C:\app\arivav
              Thu Mar 29 14:31:02 2012
              PSP0 started with pid=6, OS id=7584
              Thu Mar 29 14:31:04 2012
              ALTER DATABASE MOUNT
              Setting recovery target incarnation to 2
              Successful mount of redo thread 1, with mount id 1306938282
              Database mounted in Exclusive Mode
              Lost write protection disabled
              Completed: ALTER DATABASE MOUNT
              Thu Mar 29 14:31:13 2012
              ALTER DATABASE OPEN
              Thu Mar 29 14:31:14 2012
              Errors in file c:\app\arivav\diag\rdbms\orcl\orcl\trace\orcl_dbw0_8024.trc:
              ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
              ORA-01110: data file 2: 'C:\APP\ARIVAV\ORADATA\ORCL\SYSAUX01.DBF'
              ORA-27047: unable to read the header block of file
              OSD-04006: ReadFile() failure, unable to read from file
              O/S-Error: (OS 38) Reached the end of the file.
              ORA-1157 signalled during: ALTER DATABASE OPEN...




              Do I need to set any environment variable to mention the path where the SYSAUX01.DBF file resides?
              • 4. Re: ORA-01033: ORACLE initialization or shutdown in progress
                NikolayIvankin
                924191 wrote:
                Hi,

                Thanks for your answer.

                The file SYSAUX01.DBF exists. But it is an empty file. It has no content in it.
                Errors in file c:\app\arivav\diag\rdbms\orcl\orcl\trace\orcl_dbw0_8024.trc:
                ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
                ORA-01110: data file 2: 'C:\APP\ARIVAV\ORADATA\ORCL\SYSAUX01.DBF'
                ORA-27047: unable to read the header block of file
                OSD-04006: ReadFile() failure, unable to read from file
                O/S-Error: (OS 38) Reached the end of the file.
                ORA-1157 signalled during: ALTER DATABASE OPEN...

                Do I need to set any environment variable to mention the path where the SYSAUX01.DBF file resides?
                That's too bad, I hope your DB is running in archivelog and you have a recent backups.
                You have to restore/recover your DB.
                • 5. Re: ORA-01033: ORACLE initialization or shutdown in progress
                  819493
                  Hi,
                  >
                  Thanks for your answer.

                  The file SYSAUX01.DBF exists. But it is an empty file. It has no content in it.
                  Then I hope you have a backup, since you need to restore the file.
                  Since the file is empty, Oracle cannot use it.
                  Errors in file c:\app\arivav\diag\rdbms\orcl\orcl\trace\orcl_dbw0_8024.trc:
                  ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
                  ORA-01110: data file 2: 'C:\APP\ARIVAV\ORADATA\ORCL\SYSAUX01.DBF'
                  ORA-27047: unable to read the header block of file
                  OSD-04006: ReadFile() failure, unable to read from file
                  O/S-Error: (OS 38) Reached the end of the file.
                  ORA-1157 signalled during: ALTER DATABASE OPEN...
                  The root error is the "ORA-27047: unable to read the header block of file"-error.
                  Do I need to set any environment variable to mention the path where the SYSAUX01.DBF file resides?
                  No, these are all set in the control-file. Have you manually moved the data file?

                  HtH
                  Johan
                  • 6. Re: ORA-01033: ORACLE initialization or shutdown in progress
                    927194
                    I haven't moved any files manually.

                    This is the first time I am trying to login. I did not make any backup earlier.

                    I couldn't understand why I am getting these errors.
                    • 7. Re: ORA-01033: ORACLE initialization or shutdown in progress
                      NikolayIvankin
                      How had this DB been created?
                      If by DBCA - check it's logs. Were there any errors during install?
                      • 8. Re: ORA-01033: ORACLE initialization or shutdown in progress
                        927194
                        Yes. The DB is created using DBCA.
                        But there were no errors during installation.
                        After installation I was able to login once yesterday.
                        I didn't do any changes.
                        But I am not able to login today.
                        • 9. Re: ORA-01033: ORACLE initialization or shutdown in progress
                          NikolayIvankin
                          924191 wrote:
                          Yes. The DB is created using DBCA.
                          But there were no errors during installation.
                          After installation I was able to login once yesterday.
                          I didn't do any changes.
                          But I am not able to login today.
                          So there could be a viral activity or HDD bad blocks.
                          Recreate DB
                          • 10. Re: ORA-01033: ORACLE initialization or shutdown in progress
                            927194
                            I'll check for it and try to recreate the DB.
                            Thank You.