1 2 Previous Next 17 Replies Latest reply: Jan 10, 2013 8:42 PM by sb92075 RSS

    ORA-01033: ORACLE initialization or shutdown in progress

    973295
      Hello ,

      I am using Oracle 11.2.0 on Window 7 and since yesterday I am unable to connect to my database . I am seeing this error on my EM console.

      ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

      I tried to manually shutdown and startup from the console but resulted in the same error.

      I was not able to connect from sqlplus as well.

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 11:58:58 2013

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

      Enter user-name: SYS
      Enter password:
      ERROR:
      ORA-12560: TNS:protocol adapter error

      Here is the lsnrctl status

      C:\windows\system32>lsnrctl status

      LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59
      :37

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

      Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
      ction
      Start Date 10-JAN-2013 10:39:08
      Uptime 0 days 1 hr. 20 min. 29 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
      rk\admin\listener.ora
      Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\<host>\list
      ener\alert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521
      )))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "orcl.us.oracle.com" has 1 instance(s).
      Instance "orcl", status READY, has 1 handler(s) for this service...
      The command completed successfully

      Could someone help me out in resolving this issue.

      Thank you,
      Lakshmi
        • 1. Re: ORA-01033: ORACLE initialization or shutdown in progress
          Mark Williams-Oracle
          970292 wrote:
          Hello ,

          I am using Oracle 11.2.0 on Window 7 and since yesterday I am unable to connect to my database . I am seeing this error on my EM console.

          ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

          I tried to manually shutdown and startup from the console but resulted in the same error.

          I was not able to connect from sqlplus as well.

          SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 11:58:58 2013

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

          Enter user-name: SYS
          Enter password:
          ERROR:
          ORA-12560: TNS:protocol adapter error

          Here is the lsnrctl status

          C:\windows\system32>lsnrctl status

          LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59
          :37

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

          Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
          STATUS of the LISTENER
          ------------------------
          Alias LISTENER
          Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
          ction
          Start Date 10-JAN-2013 10:39:08
          Uptime 0 days 1 hr. 20 min. 29 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
          rk\admin\listener.ora
          Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\<host>\list
          ener\alert\log.xml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521
          )))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
          Services Summary...
          Service "CLRExtProc" has 1 instance(s).
          Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
          Service "orcl.us.oracle.com" has 1 instance(s).
          Instance "orcl", status READY, has 1 handler(s) for this service...
          The command completed successfully

          Could someone help me out in resolving this issue.

          Thank you,
          Lakshmi
          Describe your environment.

          You say you are using 11.2 but both the sqlplus and lsnrctl output show 10.1.0.5.0 version.
          • 2. Re: ORA-01033: ORACLE initialization or shutdown in progress
            Shivananda Rao
            Hello Lakshmi,

            What does the alert log of the instance say ? Please post the last few lines of the alert log.

            Please check if the OracleService<SID> is started or not


            Regards,
            Shivananda
            • 3. Re: ORA-01033: ORACLE initialization or shutdown in progress
              sb92075
              at OS level the OS Service for both the database & the listener must be started & running.
              • 4. Re: ORA-01033: ORACLE initialization or shutdown in progress
                973295
                All services (OracleOraDb11g_home4TNSListener, OracleServiceORCL, DBconsoler service) are up.
                Please let me know if you are looking for anything else?
                • 5. Re: ORA-01033: ORACLE initialization or shutdown in progress
                  973295
                  Yes the SID service is started .

                  here is the trace of alert log for your reference

                  <msg time='2013-01-10T12:18:04.918-06:00' org_id='oracle' comp_id='tnslsnr'
                  type='UNKNOWN' level='16' host_id='LAPATTAB-US'
                  host_addr='10.141.23.68'>
                  <txt>10-JAN-2013 12:18:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=LAPATTAB-US$))(SERVICE_NAME=orcl.us.oracle.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.141.23.68)(PORT=56821)) * establish * orcl.us.oracle.com * 0
                  </txt>
                  </msg>
                  <msg time='2013-01-10T12:18:04.931-06:00' org_id='oracle' comp_id='tnslsnr'
                  type='UNKNOWN' level='16' host_id='LAPATTAB-US'
                  host_addr='10.141.23.68'>
                  <txt>10-JAN-2013 12:18:04 * service_update * orcl * 0
                  </txt>
                  </msg>

                  Please let me know if you need any further details.

                  Thanks!
                  • 6. Re: ORA-01033: ORACLE initialization or shutdown in progress
                    sb92075
                    970292 wrote:
                    All services (OracleOraDb11g_home4TNSListener, OracleServiceORCL, DBconsoler service) are up.
                    Please let me know if you are looking for anything else?
                    open Command Window & type line for line as shown below


                    sqlplus
                    / as sysdba
                    shutdown abort
                    startup


                    COPY commands & results; then PASTE all back here
                    • 7. Re: ORA-01033: ORACLE initialization or shutdown in progress
                      973295
                      The version is 11.2.0.1.0 only . I have highlighted the version printed on running the lsncrtl status. I am not sure this line "LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59:37"

                      c:\certs>lsnrctl status

                      LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 12:28
                      :29

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

                      Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
                      STATUS of the LISTENER
                      ------------------------
                      Alias LISTENER
                      Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                      Start Date 10-JAN-2013 10:39:08
                      Uptime 0 days 1 hr. 49 min. 21 sec
                      Trace Level off
                      Security ON: Local OS Authentication
                      SNMP OFF
                      Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
                      rk\admin\listener.ora
                      Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\<host>\list
                      ener\alert\log.xml
                      Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=1521
                      )))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                      Services Summary...
                      Service "CLRExtProc" has 1 instance(s).
                      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      Service "orcl.us.oracle.com" has 1 instance(s).
                      Instance "orcl", status READY, has 1 handler(s) for this service...
                      The command completed successfully

                      Edited by: 970292 on Jan 10, 2013 12:29 PM

                      Edited by: 970292 on Jan 10, 2013 12:50 PM
                      • 8. Re: ORA-01033: ORACLE initialization or shutdown in progress
                        Mark Williams-Oracle
                        970292 wrote:
                        The version is 11.2.0.1.0 only . I have highlighted the version printed on running the lsncrtl status. I am not sure this line "LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59:37"

                        c:\certs>lsnrctl status

                        LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 12:28
                        :29

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

                        Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
                        STATUS of the LISTENER
                        ------------------------
                        Alias LISTENER
                        Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                        Start Date 10-JAN-2013 10:39:08
                        Uptime 0 days 1 hr. 49 min. 21 sec
                        Trace Level off
                        Security ON: Local OS Authentication
                        SNMP OFF
                        Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
                        rk\admin\listener.ora
                        Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\lapattab-us\list
                        ener\alert\log.xml
                        Listening Endpoints Summary...
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lapattab-us.us.oracle.com)(PORT=1521
                        )))
                        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                        Services Summary...
                        Service "CLRExtProc" has 1 instance(s).
                        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        Service "orcl.us.oracle.com" has 1 instance(s).
                        Instance "orcl", status READY, has 1 handler(s) for this service...
                        The command completed successfully

                        Edited by: 970292 on Jan 10, 2013 12:29 PM
                        Something seems wrong with your environment which is why I was asking for a description.

                        You say, "The version is 11.2.0.1.0 only ." yet we can see this in the output:

                        SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 10 11:58:58 2013
                        LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 10-JAN-2013 11:59:37

                        That does not make sense if you have 11.2.0.1.0 only. Note also that the lsnrctl is "for 32-bit Windows".

                        Edited by: Mark Williams on Jan 10, 2013 1:43 PM
                        • 9. Re: ORA-01033: ORACLE initialization or shutdown in progress
                          973295
                          Hello,

                          Thank you for your response. From command line , sqlplus is pointing to my old DB (10.1.0.5.0) , hence I was getting that TNS:protocol adapter error

                          Now I tried to run the sqlplus from actually DB installation folder . Resulted in the following

                          C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\BIN>sqlplus / as sysdba

                          SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 10 12:41:42 2013

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


                          Connected to:
                          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                          With the Partitioning, OLAP, Data Mining and Real Application Testing options

                          SQL> shutdown abort
                          ORACLE instance shut down.
                          SQL> startup
                          ORACLE instance started.

                          Total System Global Area 1653518336 bytes
                          Fixed Size 2176288 bytes
                          Variable Size 1275071200 bytes
                          Database Buffers 369098752 bytes
                          Redo Buffers 7172096 bytes
                          Database mounted.
                          ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
                          [186], [75054], [75062], [], [], [], [], [], [], []

                          Please let me know thoughts.
                          Thank You,
                          Lakshmi
                          • 10. Re: ORA-01033: ORACLE initialization or shutdown in progress
                            sb92075
                            ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

                            additional feedback & clues will exist within alert_orcl.log file

                            It appears that this DB got corrupted.
                            • 11. Re: ORA-01033: ORACLE initialization or shutdown in progress
                              973295
                              Hi Mark ,

                              I overlooked that . Thanks for pointing out that.

                              Yes some prob with my environment setup which is still pointing to my old db (10.1.5) .

                              I just responded to a thread with the result of running sqlplus from the actually DB installation folder .

                              Sql plus:

                              C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\BIN>sqlplus.exe

                              SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 10 12:41:24 2013

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

                              Enter user-name:
                              C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\BIN>sqlplus / as sysdba

                              SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 10 12:41:42 2013

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


                              Connected to:
                              Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                              With the Partitioning, OLAP, Data Mining and Real Application Testing options

                              SQL> shutdown abort
                              ORACLE instance shut down.
                              SQL> startup
                              ORACLE instance started.

                              Total System Global Area 1653518336 bytes
                              Fixed Size 2176288 bytes
                              Variable Size 1275071200 bytes
                              Database Buffers 369098752 bytes
                              Redo Buffers 7172096 bytes
                              Database mounted.
                              ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
                              [186], [75054], [75062], [], [], [], [], [], [], []


                              here is the result of lsnrctl status command

                              C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\BIN>LSNRCTL status

                              LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 10-JAN-2013 12:46
                              :09

                              Copyright (c) 1991, 2010, Oracle. All rights reserved.

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))
                              STATUS of the LISTENER
                              ------------------------
                              Alias LISTENER
                              Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                              ction
                              Start Date 10-JAN-2013 10:39:08
                              Uptime 0 days 2 hr. 7 min. 1 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File C:\POSSuiteApps\OracleDB\product\11.2.0\dbhome_1\netwo
                              rk\admin\listener.ora
                              Listener Log File c:\possuiteapps\oracledb\diag\tnslsnr\<host>\list
                              ener\alert\log.xml
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>
                              )))
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                              Services Summary...
                              Service "CLRExtProc" has 1 instance(s).
                              Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                              Service "orcl.us.oracle.com" has 1 instance(s).
                              Instance "orcl", status READY, has 1 handler(s) for this service...
                              The command completed successfully

                              Please let me know your thoughts

                              Edited by: 970292 on Jan 10, 2013 12:49 PM
                              • 12. Re: ORA-01033: ORACLE initialization or shutdown in progress
                                Mark Williams-Oracle
                                Further to what SB has posted, you can review the following on My Oracle Support:

                                Alter database open fails with ORA-00600 kcratr_nab_less_than_odr [ID 1296264.1]
                                ORA-600 [kcratr_nab_less_than_odr] during Instance Recovery after Database Crash [ID 1299564.1]
                                • 13. Re: ORA-01033: ORACLE initialization or shutdown in progress
                                  973295
                                  Thank you for the responses .

                                  I found this on metalink but I am not able to access this document . Could you please share some details in this doc

                                  153788.1 - Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool

                                  Here is the alert log trace

                                  System parameters with non-default values:
                                  processes = 150
                                  memory_target = 1584M
                                  control_files = "C:\POSSUITEAPPS\ORACLEDB\ORADATA\ORCL\CONTROL01.CTL"
                                  control_files = "C:\POSSUITEAPPS\ORACLEDB\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL"
                                  db_block_size = 8192
                                  compatible = "11.2.0.0.0"
                                  db_recovery_file_dest = "C:\POSSuiteApps\OracleDB\flash_recovery_area"
                                  db_recovery_file_dest_size= 3912M
                                  undo_tablespace = "UNDOTBS1"
                                  remote_login_passwordfile= "EXCLUSIVE"
                                  db_domain = "us.oracle.com"
                                  dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
                                  audit_file_dest = "C:\POSSUITEAPPS\ORACLEDB\ADMIN\ORCL\ADUMP"
                                  audit_trail = "DB"
                                  db_name = "orcl"
                                  open_cursors = 300
                                  diagnostic_dest = "C:\POSSUITEAPPS\ORACLEDB"
                                  Thu Jan 10 13:03:55 2013
                                  PMON started with pid=2, OS id=6760
                                  Thu Jan 10 13:03:55 2013
                                  VKTM started with pid=3, OS id=5748 at elevated priority
                                  VKTM running at (10)millisec precision with DBRM quantum (100)ms
                                  Thu Jan 10 13:03:55 2013
                                  GEN0 started with pid=4, OS id=1916
                                  Thu Jan 10 13:03:55 2013
                                  DIAG started with pid=5, OS id=2972
                                  Thu Jan 10 13:03:55 2013
                                  DBRM started with pid=6, OS id=7112
                                  Thu Jan 10 13:03:55 2013
                                  PSP0 started with pid=7, OS id=8520
                                  Thu Jan 10 13:03:55 2013
                                  DIA0 started with pid=8, OS id=1852
                                  Thu Jan 10 13:03:55 2013
                                  MMAN started with pid=9, OS id=4448
                                  Thu Jan 10 13:03:55 2013
                                  DBW0 started with pid=10, OS id=7032
                                  Thu Jan 10 13:03:55 2013
                                  LGWR started with pid=11, OS id=5104
                                  Thu Jan 10 13:03:55 2013
                                  CKPT started with pid=12, OS id=7820
                                  Thu Jan 10 13:03:55 2013
                                  SMON started with pid=13, OS id=6860
                                  Thu Jan 10 13:03:55 2013
                                  RECO started with pid=14, OS id=2620
                                  Thu Jan 10 13:03:56 2013
                                  MMON started with pid=15, OS id=4288
                                  Thu Jan 10 13:03:56 2013
                                  MMNL started with pid=16, OS id=9100
                                  starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                                  starting up 1 shared server(s) ...
                                  ORACLE_BASE from environment = C:\POSSuiteApps\OracleDB
                                  Thu Jan 10 13:03:57 2013
                                  ALTER DATABASE MOUNT
                                  Successful mount of redo thread 1, with mount id 1332168637
                                  Database mounted in Exclusive Mode
                                  Lost write protection disabled
                                  Completed: ALTER DATABASE MOUNT
                                  Thu Jan 10 13:19:01 2013
                                  db_recovery_file_dest_size of 3912 MB is 0.00% used. This is a
                                  user-specified limit on the amount of space that will be used by this
                                  database for recovery-related files, and does not reflect the amount of
                                  space available in the underlying filesystem or ASM diskgroup.

                                  Edited by: 970292 on Jan 10, 2013 2:09 PM
                                  • 14. Re: ORA-01033: ORACLE initialization or shutdown in progress
                                    973295
                                    Hi ,

                                    I followed the steps mentioned in the Doc - 1296264.1 .. My issue got resolved and I am able to connect to the DB.

                                    Thank you all!

                                    Edited by: 970292 on Jan 10, 2013 8:29 PM
                                    1 2 Previous Next