1 2 Previous Next 25 Replies Latest reply on Aug 27, 2013 12:27 PM by Nicolas Gasparotto Go to original post
      • 15. Re: ORACLE Initialization or shutdown in progress
        632299
        Hi,

        I have the same problem and I followed the instruction mentioned above.... But no use.... Still I have the same prolem. Can anybody help to solve this problem...

        Here I posted what I had tried.


        SQL> shutdown
        ORA-01109: database not open


        Database dismounted.
        ORACLE instance shut down.
        SQL> startup
        ORACLE instance started.

        Total System Global Area 171966464 bytes
        Fixed Size 787988 bytes
        Variable Size 145488364 bytes
        Database Buffers 25165824 bytes
        Redo Buffers 524288 bytes
        Database mounted.
        ORA-00314: log 1 of thread 1, expected sequence# 179 doesn't match 176
        ORA-00312: online log 1 thread 1:
        'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG'


        Thanks in advance.
        • 16. Re: ORACLE Initialization or shutdown in progress
          Maran Viswarayar
          Issue

          Recover database using backup controlfile until cancel;

          When prompted

          Try one by one and enter cancel

          'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG'
          'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG'
          'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG'

          Alter database open resetlogs
          • 17. Re: ORACLE Initialization or shutdown in progress
            672022
            i have a problem in my database when i try to brows the console,it indites as Initialization or shutdown in progress.
            i have try to start it using below command but tread found in the last line.

            C:\>sqlplus/nolog

            SQL*Plus: Release 11.1.0.7.0 - Production on Mon Nov 24 07:28:10 2008

            Copyright (c) 1982, 2008, Oracle. All rights reserved.

            SQL> connect sys/systemicam as sysdba
            Connected.
            SQL> shutdown immediate
            ORA-01109: database not open


            Database dismounted.
            ORACLE instance shut down.
            SQL> startup mount
            ORACLE instance started.

            Total System Global Area 644468736 bytes
            Fixed Size 1349236 bytes
            Variable Size 385878412 bytes
            Database Buffers 251658240 bytes
            Redo Buffers 5582848 bytes
            Database mounted.
            SQL> alter database open;
            alter database open
            *
            ERROR at line 1:
            ORA-16014: log 1 sequence# 361 not archived, no available destinations
            ORA-00312: online log 1 thread 1:
            'D:\ORACLE11\ORADATA\ICAM\ONLINELOG\O1_MF_1_4KF0CF89_.LOG'
            ORA-00312: online log 1 thread 1:
            'D:\ORACLE11\FLASH_RECOVERY_AREA\ICAM\ONLINELOG\O1_MF_1_4KF0CHVC_.LOG'

            pls.help me to recover the problem.
            • 18. Re: ORACLE Initialization or shutdown in progress
              Maran Viswarayar
              As the error message states you need to some space on the Archive log destination

              If you have RMAN configure to use FLASH_RECOVER_AREA ,delete some files and make room for new archive logs
              if not using RMAN you backup and delete some archivelogs and make way for new archive logs
              • 19. Re: ORACLE Initialization or shutdown in progress
                672022
                thanks for your repley,

                i'm new comer to the oracle11g, can you let me know the steps doing your suggestion.

                thanks
                • 20. Re: ORACLE Initialization or shutdown in progress
                  Maran Viswarayar
                  This Blog link can help you

                  http://arjudba.blogspot.com/2008/07/database-startup-fails-with-error-ora.html
                  • 21. Re: ORACLE Initialization or shutdown in progress
                    732887
                    I have a similar problem.My OracleService on Control Panel-> Services shows status "Starting", instead of "Started".
                    I tried executing the steps outlined in this thread and here's what i have..Do let me know on how to resolve this problem.

                    C:\>sqlplus /nolog

                    SQL*Plus: Release 10.1.0.2.0 - Production on Mon Nov 9 11:34:32 2009

                    Copyright (c) 1982, 2004, Oracle. All rights reserved.

                    SQL> connect sys/manager as sysdba
                    Connected.
                    SQL> shutdown immediate
                    ORA-01109: database not open


                    Database dismounted.
                    ORACLE instance shut down.
                    SQL> startup
                    ORACLE instance started.

                    Total System Global Area 171966464 bytes
                    Fixed Size 787988 bytes
                    Variable Size 145488364 bytes
                    Database Buffers 25165824 bytes
                    Redo Buffers 524288 bytes
                    Database mounted.
                    ORA-00322: log 1 of thread 1 is not current copy
                    ORA-00312: online log 1 thread 1:
                    'D:\ORACLE\PRODUCT\10.0.1\ORADATA\STERLING\REDO01.LOG'
                    • 22. Re: ORACLE Initialization or shutdown in progress
                      AbubakrSaad

                      Dears,

                      I face same issue but

                      OS: Win 7 and oracle 11g R2 and when  I tried your suggested solution I got the following

                       

                      SQL> connect sys/sys as sysdba

                      Connected.

                      SQL> shutdown immediate

                      ORA-01109: database not open

                       

                       

                       

                       

                      Database dismounted.

                      ORACLE instance shut down.

                      SQL> startup

                      ORACLE instance started.

                       

                       

                      Total System Global Area  778387456 bytes

                      Fixed Size                  1374808 bytes

                      Variable Size             478152104 bytes

                      Database Buffers          293601280 bytes

                      Redo Buffers                5259264 bytes

                      Database mounted.

                      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],

                      [894], [128], [130], [], [], [], [], [], [], []

                       

                       

                       

                       

                      SQL>

                      • 23. Re: ORACLE Initialization or shutdown in progress
                        jgarry

                        Probably not a good idea to revivify old threads.  You should start your own thread, with a pointer to the old thread if relevant, and don't assume anyone from the old thread is still around.

                         

                        ORA-600 generally means you should contact Oracle support (MOS).  Search for the ora-600 tool there, sometimes it helps.

                        • 24. Re: ORACLE Initialization or shutdown in progress
                          1033428

                          Hello! Unfortunately I am encountering the same problem now. Same error. Initialization or shutdown in progress.....

                          I cannot login as sysdba. Neither could I before.

                          I have installed Oracle 11g, unlocked HR and SCOTT from the password management tool in the install.

                          I can use HR and SCOTT, but when I try to login with sys or sysdba.

                          "Insufficient privileges" is the message returned when I try to login.

                          Any ideas?

                          Thank you!

                          • 25. Re: ORACLE Initialization or shutdown in progress
                            Nicolas Gasparotto

                            Please, re-read the Joel's post, especially the first sentence.

                             

                            -- mod. action: locking that thtread --

                             

                            Nicolas.

                            1 2 Previous Next