This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Nov 14, 2012 1:22 AM by PavanKumar RSS

database not starting

870213 Newbie
Currently Being Moderated
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
    user296828 Expert
    Currently Being Moderated
    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
    973726 Newbie
    Currently Being Moderated
    take control files from rman backup for recovery.
  • 3. Re: database not starting
    Me_101 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Post
    show parameter control;

    http://ora-ssn.blogspot.com/2011/05/ora-00214-control-file-version.html
  • 5. Re: database not starting
    870213 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Could you please post 50 lines from the alert log .
  • 7. Re: database not starting
    user296828 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    user296828 Expert
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    user296828 Expert
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points