6 Replies Latest reply: Nov 21, 2012 10:54 AM by EdStevens RSS

    error in identifying control file, check alert log for more info

    ayadsufyan
      hi ,
      i have a problem when i try to login to oracle
      i found this messsage
      error
      ora-01033 oracle initialization or shutdown in progress
      after i logged on with / as sysdba
      i did the following

      SQL> shutdown immediate;
      ORA-01507: database not mounted
      ORACLE instance shut down.
      SQL> startup mount;
      ORACLE instance started.
      Total System Global Area 293601280 bytes
      Fixed Size 1248600 bytes
      Variable Size 79692456 bytes
      Database Buffers 205520896 bytes
      Redo Buffers 7139328 bytes
      ORA-00205: error in identifying control file, check alert log for more info
      ----------------------------------------------------------------
      O.S = Windows 7 Profissional
      Oracal release= 10 g release 10.2.0.1.0
      ------------------------------------------------------------------
      the last lines of the alert log file is
      Starting up ORACLE RDBMS Version: 10.2.0.1.0.
      System parameters with non-default values:
      processes = 150
      __shared_pool_size = 71303168
      __large_pool_size = 4194304
      __java_pool_size = 4194304
      __streams_pool_size = 0
      sga_target = 293601280
      control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, >E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
      db_block_size = 8192
      __db_cache_size = 205520896
      compatible = 10.2.0.1.0
      db_file_multiblock_read_count= 16
      db_recovery_file_dest = e:\oracle\product\10.2.0\db_1/flash_recovery_area
      db_recovery_file_dest_size= 2147483648
      undo_management = AUTO
      undo_tablespace = UNDOTBS1
      remote_login_passwordfile= EXCLUSIVE
      db_domain =
      dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
      job_queue_processes = 10
      audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\ADUMP
      background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\BDUMP
      user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\UDUMP
      core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\CDUMP
      db_name = orcl
      open_cursors = 15000
      pga_aggregate_target = 96468992
      PMON started with pid=2, OS id=1560
      PSP0 started with pid=3, OS id=208
      MMAN started with pid=4, OS id=972
      DBW0 started with pid=5, OS id=4092
      LGWR started with pid=6, OS id=3812
      CKPT started with pid=7, OS id=344
      SMON started with pid=8, OS id=3492
      RECO started with pid=9, OS id=2272
      CJQ0 started with pid=10, OS id=3276
      MMON started with pid=11, OS id=1832
      MMNL started with pid=12, OS id=1636
      Wed Nov 21 11:44:31 2012
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      starting up 1 shared server(s) ...
      Wed Nov 21 11:44:32 2012
      ALTER DATABASE MOUNT
      Wed Nov 21 11:44:32 2012
      ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
      ORA-27041: unable to open file
      OSD-04002: unable to open file
      O/S-Error: (OS 2) can not find the specified file
      Wed Nov 21 11:44:32 2012
      ORA-205 signalled during: ALTER DATABASE MOUNT...
      Please anyone has any info please share me
      thank you ,
      regards,

      Edited by: ayadsufyan on 21-Nov-2012 01:04

      Edited by: ayadsufyan on 21-Nov-2012 01:30
        • 1. Re: error in identifying control file, check alert log for more info
          EdStevens
          ayadsufyan wrote:
          hi ,
          i have a problem when i try to login to oracle
          i found this messsage
          error
          ora-01033 oracle initialization or shutdown in progress
          after i logged on with / as sysdba
          i did the following

          SQL> shutdown immediate;
          ORA-01507: database not mounted
          ORACLE instance shut down.
          SQL> startup mount;
          ORACLE instance started.
          Total System Global Area 293601280 bytes
          Fixed Size 1248600 bytes
          Variable Size 79692456 bytes
          Database Buffers 205520896 bytes
          Redo Buffers 7139328 bytes
          ORA-00205: error in identifying control file, check alert log for more info
          ----------------------------------------------------------------
          O.S = Windows 7 Profissional
          Oracal release= 10 g release 10.2.0.1.0
          ------------------------------------------------------------------
          the last lines of the alert log file is
          Starting up ORACLE RDBMS Version: 10.2.0.1.0.
          System parameters with non-default values:
          processes = 150
          __shared_pool_size = 71303168
          __large_pool_size = 4194304
          __java_pool_size = 4194304
          __streams_pool_size = 0
          sga_target = 293601280
          control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, >E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
          db_block_size = 8192
          __db_cache_size = 205520896
          compatible = 10.2.0.1.0
          db_file_multiblock_read_count= 16
          db_recovery_file_dest = e:\oracle\product\10.2.0\db_1/flash_recovery_area
          db_recovery_file_dest_size= 2147483648
          undo_management = AUTO
          undo_tablespace = UNDOTBS1
          remote_login_passwordfile= EXCLUSIVE
          db_domain =
          dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
          job_queue_processes = 10
          audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\ADUMP
          background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\BDUMP
          user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\UDUMP
          core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\ORCL\CDUMP
          db_name = orcl
          open_cursors = 15000
          pga_aggregate_target = 96468992
          PMON started with pid=2, OS id=1560
          PSP0 started with pid=3, OS id=208
          MMAN started with pid=4, OS id=972
          DBW0 started with pid=5, OS id=4092
          LGWR started with pid=6, OS id=3812
          CKPT started with pid=7, OS id=344
          SMON started with pid=8, OS id=3492
          RECO started with pid=9, OS id=2272
          CJQ0 started with pid=10, OS id=3276
          MMON started with pid=11, OS id=1832
          MMNL started with pid=12, OS id=1636
          Wed Nov 21 11:44:31 2012
          starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
          starting up 1 shared server(s) ...
          Wed Nov 21 11:44:32 2012
          ALTER DATABASE MOUNT
          Wed Nov 21 11:44:32 2012
          ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
          ORA-27041: unable to open file
          OSD-04002: unable to open file
          O/S-Error: (OS 2) can not find the specified file
          Wed Nov 21 11:44:32 2012
          ORA-205 signalled during: ALTER DATABASE MOUNT...
          Please anyone has any info please share me
          thank you ,
          regards,

          Edited by: ayadsufyan on 21-Nov-2012 01:04

          Edited by: ayadsufyan on 21-Nov-2012 01:30
          I'd say the error message is pretty self-evident:
          ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'
          ORA-27041: unable to open file
          OSD-04002: unable to open file
          O/S-Error: (OS 2) can not find the specified file
          What do you suppose "can not find the specified file" means?

          And what does this have to do with database security?
          • 2. Re: error in identifying control file, check alert log for more info
            Srini Chavali-Oracle
            >
            ...
            O.S = Windows 7 Profissional
            Oracal release= 10 g release 10.2.0.1.0
            ...
            >

            10.2.0.1 is not certified on Win 7 - you need at least 10.2.0.5 - so things may or may not work as advertised.

            http://docs.oracle.com/cd/B19306_01/relnotes.102/b15680/toc.htm#BABEBBJF

            HTH
            Srini
            • 3. Re: error in identifying control file, check alert log for more info
              vlethakula
              Is your control file present in the location

              E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL
              • 4. Re: error in identifying control file, check alert log for more info
                R Monga
                There are reason
                1. write ps -ef | grep pmon
                there will be some oracle process running with the name of our DB name at last & if ASM is there then +ASM also
                try to kill the process of oracle by
                kill -9 (PID no)

                then try to shutdown the db
                2. for ur control file error
                try this
                startup mount
                sql>show parameter controlfile;
                will give the contriol location & check whether control file is physically there are not if not place it there
                then try
                alter database open
                hope this will solve ur problem do inform ur execution
                • 5. Re: error in identifying control file, check alert log for more info
                  12cdb
                  As suggested earlier,

                  Control File "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL" is not available.

                  Find the control file and move it to the specified location and try.
                  • 6. Re: error in identifying control file, check alert log for more info
                    EdStevens
                    R Monga wrote:
                    There are reason
                    1. write ps -ef | grep pmon
                    there will be some oracle process running with the name of our DB name at last & if ASM is there then +ASM also
                    try to kill the process of oracle by
                    kill -9 (PID no)
                    What is to be gained by killing a process?
                    >
                    then try to shutdown the db
                    He can't start the db. Why would he try to shut it down? Especially since you just had him kill it (hope he got the right process) in the previous step. In fact, there is nothing TO shut down.
                    2. for ur control file error
                    try this
                    startup mount
                    He has already reported an error that the control file cannot be located. As such, the database will not mount. STARTUP MOUNT will fail with the error the OP is reporting.
                    sql>show parameter controlfile;
                    will give the contriol location & check whether control file is physically there are not if not place it there
                    then try
                    alter database open
                    hope this will solve ur problem do inform ur execution