1 2 Previous Next 15 Replies Latest reply: Nov 14, 2012 3:22 AM by Pavan Kumar RSS

    database not starting

    870213
      Hi Experts

      in My Oracle 9i Database Control File was not working
      SQL> startup
      ORACLE instance started.
      
      Total System Global Area  612368384 bytes
      Fixed Size                  1304728 bytes
      Variable Size             188745576 bytes
      Database Buffers          415236096 bytes
      Redo Buffers                7081984 bytes
      ORA-00214: control file ‘D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL’ version
       inconsistent with file ‘D:\ORACLE\ORADATA\ORCL\CONTROL02.CTL’
      I changes the Control File
      alter system set control_files=’D:\oracle\ORADATA\ORCL\CONTROL03.CTL’ scope=spfile;
      after that when I startup database giving an error

      ORA-01113: end-of-file on communication channel

      and in Log file
      starting up 1 shared server(s) ...
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      Mon Nov 12 14:54:44 2012
      ALTER DATABASE   MOUNT
      Mon Nov 12 14:54:48 2012
      Successful mount of redo thread 1, with mount id 1326936500.
      Mon Nov 12 14:54:48 2012
      Database mounted in Exclusive Mode.
      Completed: ALTER DATABASE   MOUNT
      Mon Nov 12 14:54:48 2012
      ALTER DATABASE OPEN
      Mon Nov 12 14:54:48 2012
      Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_3916.trc:
      ORA-00600: internal error code, arguments: [3700], [1], [15], [3], [3], [], [], []
      
      Mon Nov 12 14:54:52 2012
      Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_3916.trc:
      ORA-00600: internal error code, arguments: [3700], [1], [15], [3], [3], [], [], []
      
      Mon Nov 12 14:54:52 2012
      LGWR: terminating instance due to error 600
      Mon Nov 12 14:54:53 2012
      Errors in file d:\oracle\admin\orcl\bdump\orcl_pmon_3864.trc:
      ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
      
      Instance terminated by LGWR, pid = 3916
      any one help in this regard

      thanks in Advance
        • 1. Re: database not starting
          12cdb
          do it again.

          SQL>EXIT
          . .
          .$sqlplus / as sysdba

          SQL>
          SQL>STARTUP NOMOUNT;
          SQL>alter system set control_files=’D:\oracle\ORADATA\ORCL\CONTROL03.CTL’ scope=spfile;
          SQL> ALTER DATABASE MOUNT;

          SQL> ALTER DATABASE OPEN;
          • 2. Re: database not starting
            user12848343
            take control files from rman backup for recovery.
            • 3. Re: database not starting
              Me_101
              the error refered to controlfile 2, not 3. Try :

              alter system set control_files=’D:\oracle\ORADATA\ORCL\CONTROL02.CTL’ scope=spfile;
              • 4. Re: database not starting
                Osama_Mustafa
                Post
                show parameter control;

                http://ora-ssn.blogspot.com/2011/05/ora-00214-control-file-version.html
                • 5. Re: database not starting
                  870213
                  Thank you Expert

                  I have check with control file 2 and 3 also.
                  SQL> alter system set control_files='D:\oracle\ORADATA\ORCL\CONTROL03.CTL' scope
                  =spfile;
                  
                  System altered.
                  
                  SQL> alter database mount;
                  
                  Database altered.
                  
                  SQL> alter database open;
                  alter database open
                  *
                  ERROR at line 1:
                  ORA-03113: end-of-file on communication channel
                  same error.
                  • 6. Re: database not starting
                    Osama_Mustafa
                    Could you please post 50 lines from the alert log .
                    • 7. Re: database not starting
                      12cdb
                      SQL> alter database open;
                      alter database open
                      *
                      ERROR at line 1:
                      ORA-03113: end-of-file on communication channel
                      Now go and look at the alert<SID>.log file. Copy and paste a few last lines from the file.
                      • 8. Re: database not starting
                        870213
                        now new error.
                        ORA-00205. error in identifying control file.
                        Mon Nov 12 17:11:38 2012
                        LGWR: terminating instance due to error 600
                        Instance terminated by LGWR, pid = 2160
                        Mon Nov 12 17:16:36 2012
                        Starting ORACLE instance (normal)
                        LICENSE_MAX_SESSION = 0
                        LICENSE_SESSIONS_WARNING = 0
                        SCN scheme 2
                        Using log_archive_dest parameter default value
                        LICENSE_MAX_USERS = 0
                        SYS auditing is disabled
                        Starting up ORACLE RDBMS Version: 9.2.0.1.0.
                        System parameters with non-default values:
                          processes                = 150
                          timed_statistics         = TRUE
                          shared_pool_size         = 50331648
                          large_pool_size          = 8388608
                          java_pool_size           = 33554432
                          control_files            = D:\oracle\ORADATA\ORCL\CONTROL02.CTL
                          db_block_size            = 8192
                          db_cache_size            = 25165824
                          compatible               = 9.2.0.0.0
                          db_file_multiblock_read_count= 16
                          fast_start_mttr_target   = 300
                          undo_management          = AUTO
                          undo_tablespace          = UNDOTBS1
                          undo_retention           = 10800
                          remote_login_passwordfile= EXCLUSIVE
                          db_domain                = 
                          instance_name            = ORCL
                          dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
                          job_queue_processes      = 10
                          hash_join_enabled        = TRUE
                          background_dump_dest     = D:\oracle\admin\ORCL\bdump
                          user_dump_dest           = D:\oracle\admin\ORCL\udump
                          core_dump_dest           = D:\oracle\admin\ORCL\cdump
                          sort_area_size           = 524288
                          db_name                  = ORCL
                          open_cursors             = 300
                          star_transformation_enabled= FALSE
                          query_rewrite_enabled    = FALSE
                          pga_aggregate_target     = 25165824
                          aq_tm_processes          = 1
                        PMON started with pid=2
                        DBW0 started with pid=3
                        LGWR started with pid=4
                        CKPT started with pid=5
                        SMON started with pid=6
                        RECO started with pid=7
                        CJQ0 started with pid=8
                        QMN0 started with pid=9
                        Mon Nov 12 17:16:38 2012
                        starting up 1 shared server(s) ...
                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                        Mon Nov 12 17:16:39 2012
                        ALTER DATABASE   MOUNT
                        Mon Nov 12 17:16:39 2012
                        ORA-00202: controlfile: 'D:\oracle\ORADATA\ORCL\CONTROL02.CTL'
                        ORA-27041: unable to open file
                        OSD-04002: unable to open file
                        O/S-Error: (OS 2) The system cannot find the file specified.
                        
                        Mon Nov 12 17:16:42 2012
                        ORA-205 signalled during: ALTER DATABASE   MOUNT...
                        Mon Nov 12 17:23:30 2012
                        Shutting down instance: further logons disabled
                        Shutting down instance (normal)
                        License high water mark = 3
                        Waiting for dispatcher 'D000' to shutdown
                        All dispatchers and shared servers shutdown
                        Mon Nov 12 17:23:32 2012
                        ALTER DATABASE CLOSE NORMAL
                        ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
                        ARCH: Archiving is disabled
                        Shutting down archive processes
                        Archiving is disabled
                        Archive process shutdown avoided: 0 active
                        ARCH: Archiving is disabled
                        Shutting down archive processes
                        Archiving is disabled
                        Archive process shutdown avoided: 0 active
                        Mon Nov 12 17:24:40 2012
                        Starting ORACLE instance (normal)
                        LICENSE_MAX_SESSION = 0
                        LICENSE_SESSIONS_WARNING = 0
                        SCN scheme 2
                        Using log_archive_dest parameter default value
                        LICENSE_MAX_USERS = 0
                        SYS auditing is disabled
                        Starting up ORACLE RDBMS Version: 9.2.0.1.0.
                        System parameters with non-default values:
                          processes                = 150
                          timed_statistics         = TRUE
                          shared_pool_size         = 50331648
                          large_pool_size          = 8388608
                          java_pool_size           = 33554432
                          control_files            = D:\oracle\ORADATA\ORCL\CONTROL02.CTL
                          db_block_size            = 8192
                          db_cache_size            = 25165824
                          compatible               = 9.2.0.0.0
                          db_file_multiblock_read_count= 16
                          fast_start_mttr_target   = 300
                          undo_management          = AUTO
                          undo_tablespace          = UNDOTBS1
                          undo_retention           = 10800
                          remote_login_passwordfile= EXCLUSIVE
                          db_domain                = 
                          instance_name            = ORCL
                          dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
                          job_queue_processes      = 10
                          hash_join_enabled        = TRUE
                          background_dump_dest     = D:\oracle\admin\ORCL\bdump
                          user_dump_dest           = D:\oracle\admin\ORCL\udump
                          core_dump_dest           = D:\oracle\admin\ORCL\cdump
                          sort_area_size           = 524288
                          db_name                  = ORCL
                          open_cursors             = 300
                          star_transformation_enabled= FALSE
                          query_rewrite_enabled    = FALSE
                          pga_aggregate_target     = 25165824
                          aq_tm_processes          = 1
                        PMON started with pid=2
                        DBW0 started with pid=3
                        LGWR started with pid=4
                        CKPT started with pid=5
                        SMON started with pid=6
                        RECO started with pid=7
                        CJQ0 started with pid=8
                        QMN0 started with pid=9
                        Mon Nov 12 17:24:43 2012
                        starting up 1 shared server(s) ...
                        starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                        Mon Nov 12 17:24:59 2012
                        ALTER SYSTEM SET control_files='D:\oracle\ORADATA\ORCL\CONTROL03.CTL' SCOPE=SPFILE;
                        Mon Nov 12 17:25:08 2012
                        alter database mount
                        Mon Nov 12 17:25:08 2012
                        ORA-00202: controlfile: 'D:\oracle\ORADATA\ORCL\CONTROL02.CTL'
                        ORA-27041: unable to open file
                        OSD-04002: unable to open file
                        O/S-Error: (OS 2) The system cannot find the file specified.
                        
                        Mon Nov 12 17:25:11 2012
                        ORA-205 signalled during: alter database mount...
                        • 9. Re: database not starting
                          12cdb
                          Database is expecting controfile should be D:\oracle\ORADATA\ORCL\CONTROL02.CTL but you set control_files='D:\oracle\ORADATA\ORCL\CONTROL03.CTL' which is wrong.

                          Go back,

                          sql> shutdown immediate;

                          sql> startup nomount ;

                          SQL> alter system set control_files='D:\oracle\ORADATA\ORCL\CONTROL02.CTL' scope=spfile;


                          SQL> alter database mount;


                          Now copy & paste the result.
                          • 10. Re: database not starting
                            Osama_Mustafa
                            ORA-00202: controlfile: 'D:\oracle\ORADATA\ORCL\CONTROL02.CTL'
                            ORA-27041: unable to open file
                            OSD-04002: unable to open file
                            O/S-Error: (OS 2) The system cannot find the file specified.
                            is D:\oracle\ORADATA\ORCL\CONTROL02.CTL Found ? if not copy Control02.ctl on same location and change its name to Control02.ctl
                            • 11. Re: database not starting
                              Fran
                              control02.ctl doesn't exist in this path so you must copy another controlfile in this path and rename it like control02.ctl. follow this steps:

                              http://sulistyoas.wordpress.com/2007/04/19/ora-00202-oracle-problem-with-control-file/
                              • 12. Re: database not starting
                                870213
                                C:\>sqlplus
                                
                                SQL*Plus: Release 9.2.0.1.0 - Production on Mon Nov 12 17:50:08 2012
                                
                                Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
                                
                                Enter user-name: /as sysdba
                                Connected to an idle instance.
                                
                                SQL> shutdown immediate
                                ORA-01034: ORACLE not available
                                ORA-27101: shared memory realm does not exist
                                SQL> startup nomount
                                ORACLE instance started.
                                
                                Total System Global Area  135338868 bytes
                                Fixed Size                   453492 bytes
                                Variable Size             109051904 bytes
                                Database Buffers           25165824 bytes
                                Redo Buffers                 667648 bytes
                                SQL> alter system set control_files='D:\oracle\ORADATA\ORCL\CONTROL02.CTL' scope
                                =spfile;
                                
                                System altered.
                                
                                SQL> alter database mount;
                                
                                Database altered.
                                
                                SQL> alter database open;
                                alter database open
                                *
                                ERROR at line 1:
                                ORA-03113: end-of-file on communication channel
                                Log file
                                Mon Nov 12 17:32:21 2012
                                LGWR: terminating instance due to error 600
                                Instance terminated by LGWR, pid = 3424
                                Mon Nov 12 17:50:35 2012
                                Starting ORACLE instance (normal)
                                LICENSE_MAX_SESSION = 0
                                LICENSE_SESSIONS_WARNING = 0
                                SCN scheme 2
                                Using log_archive_dest parameter default value
                                LICENSE_MAX_USERS = 0
                                SYS auditing is disabled
                                Starting up ORACLE RDBMS Version: 9.2.0.1.0.
                                System parameters with non-default values:
                                  processes                = 150
                                  timed_statistics         = TRUE
                                  shared_pool_size         = 50331648
                                  large_pool_size          = 8388608
                                  java_pool_size           = 33554432
                                  control_files            = D:\oracle\ORADATA\ORCL\CONTROL03.CTL
                                  db_block_size            = 8192
                                  db_cache_size            = 25165824
                                  compatible               = 9.2.0.0.0
                                  db_file_multiblock_read_count= 16
                                  fast_start_mttr_target   = 300
                                  undo_management          = AUTO
                                  undo_tablespace          = UNDOTBS1
                                  undo_retention           = 10800
                                  remote_login_passwordfile= EXCLUSIVE
                                  db_domain                = 
                                  instance_name            = ORCL
                                  dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
                                  job_queue_processes      = 10
                                  hash_join_enabled        = TRUE
                                  background_dump_dest     = D:\oracle\admin\ORCL\bdump
                                  user_dump_dest           = D:\oracle\admin\ORCL\udump
                                  core_dump_dest           = D:\oracle\admin\ORCL\cdump
                                  sort_area_size           = 524288
                                  db_name                  = ORCL
                                  open_cursors             = 300
                                  star_transformation_enabled= FALSE
                                  query_rewrite_enabled    = FALSE
                                  pga_aggregate_target     = 25165824
                                  aq_tm_processes          = 1
                                PMON started with pid=2
                                DBW0 started with pid=3
                                LGWR started with pid=4
                                CKPT started with pid=5
                                SMON started with pid=6
                                RECO started with pid=7
                                CJQ0 started with pid=8
                                QMN0 started with pid=9
                                Mon Nov 12 17:50:38 2012
                                starting up 1 shared server(s) ...
                                starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                                Mon Nov 12 17:52:00 2012
                                ALTER SYSTEM SET control_files='D:\oracle\ORADATA\ORCL\CONTROL02.CTL' SCOPE=SPFILE;
                                Mon Nov 12 17:52:13 2012
                                alter database mount
                                Mon Nov 12 17:52:17 2012
                                Successful mount of redo thread 1, with mount id 1326931533.
                                Mon Nov 12 17:52:17 2012
                                Database mounted in Exclusive Mode.
                                Completed: alter database mount
                                Mon Nov 12 17:53:23 2012
                                alter database open
                                Mon Nov 12 17:53:24 2012
                                Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_1752.trc:
                                ORA-00600: internal error code, arguments: [3700], [1], [15], [3], [3], [], [], []
                                
                                Mon Nov 12 17:53:28 2012
                                Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_1752.trc:
                                ORA-00600: internal error code, arguments: [3700], [1], [15], [3], [3], [], [], []
                                
                                Mon Nov 12 17:53:28 2012
                                LGWR: terminating instance due to error 600
                                Mon Nov 12 17:53:28 2012
                                Errors in file d:\oracle\admin\orcl\bdump\orcl_pmon_3752.trc:
                                ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
                                
                                Instance terminated by LGWR, pid = 1752
                                • 13. Re: database not starting
                                  12cdb
                                  Errors in file d:\oracle\admin\orcl\bdump\orcl_lgwr_1752.trc:
                                  ORA-00600: internal error code, arguments: [3700], [1], [15], [3], [3], [], [], []
                                  Look at that trace file for more information and see what is causing the issue.

                                  For detailed information logon to Oracle Support (Metalink) site and look for possible solutions.
                                  • 14. Re: database not starting
                                    Osama_Mustafa
                                    go to http://support.oracle.com
                                    Use : ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]
                                    and OPEN SR
                                    1 2 Previous Next