11 Replies Latest reply: Aug 24, 2012 2:36 PM by Srini Chavali-Oracle RSS

    startup upgrade ORA-00205: error in identifying control file

    user10698496
      Hi,
      I am doing a manual upgrade from 10.2.04 to 11.2.03.

      I have installed 11.2.0.3.
      Ran utlu112i.sql
      Copied TNSNAMES and LISTENER.ora,init.ora from 10g home to 11g home respective directories.
      Commented all dump_dest paramteres in 11g init.ora and added diagnostic_dest parameter

      exported all the varaiables as follows.

      export ORACLE_HOME=/oracle/ora11203
      export PATH=$ORACLE_HOME/bin:$PATH
      export ORACLE_SID=OMIGTEST
      export TNS_ADMIN=$ORACLE_HOME/network/admin
      export ORACLE_BASE=/oracle/ora11203/app/ora11203

      Now when i try to start DB from the unix session where all of above variables are set,i am getting following issue.
      SQL> startup upgrade
      ORACLE instance started.
      
      Total System Global Area 1636892672 bytes
      Fixed Size                  2183056 bytes
      Variable Size            1090519152 bytes
      Database Buffers          536870912 bytes
      Redo Buffers                7319552 bytes
      ORA-00205: error in identifying control file, check alert log for more info
      
      Alert log says as below.
      
      ORACLE_BASE from environment = /oracle/ora11203/app/ora11203
      Thu Aug 23 15:03:36 2012
      ALTER DATABASE   MOUNT
      ORA-00210: cannot open the specified control file
      ORA-00202: control file: '/oracle/ora11203/dbs/cntrlOMIGTEST.dbf'
      ORA-27037: unable to obtain file status
      HPUX-ia64 Error: 2: No such file or directory
      Additional information: 3
      ORA-205 signalled during: ALTER DATABASE   MOUNT...
      In init.ora of 11g (which is copied from 10g) ,i have commented our control file path entry.

      Kindly assist me as i am doing upgrade for the first time.

      Thanks

      Edited by: user10698496 on Aug 24, 2012 2:47 AM
        • 1. Re: startup upgrade ORA-00205: error in identifying control file
          Pinela
          hi,

          why did you comment your control_file entry in init?
          you only do that when restoring cf to ASM.

          BR,
          Pinela.
          • 2. Re: startup upgrade ORA-00205: error in identifying control file
            user10698496
            I think the database is started from 10g home only even after setting variables.
            export ORACLE_HOME=/oracle/ora11203
            export PATH=$ORACLE_HOME/bin:$PATH
            export ORACLE_SID=OMIGTEST
            export TNS_ADMIN=$ORACLE_HOME/network/admin
            export ORACLE_BASE=/oracle/ora11203/app/ora11203
            export CLASSPATH=/oracle/ora11203/jdbc/lib/ojdbc5.jar:/opt/java6/jre/lib:/opt/java6/jre/lib/jsse.jar
            Even after setting these variables when i do sqlplus it is going to 10g.
             sqlplus '/as sysdba'
            
            SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 23 15:24:15 2012
            
            Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
            
            Connected to an idle instance.
            
            SQL>
            How do i resolve this?
            • 3. Re: startup upgrade ORA-00205: error in identifying control file
              Pinela
              if you run:
              which sqlplus
              it should show you the 10g home (because it is still in the path).
              setting the PATH is not so straightforward (the apply is not so immediate).
              you can either:
              set the PATH in you .bash_profile
              or
              create a file X.env with your exports, and then running
              . X.env
              or
              cd /oracle/ora11203/bin
              ./sqlplus / as sysdba

              this will work.

              but you still need to uncomment the control_files line.

              br,
              pinela.

              Edited by: Pinela on Aug 24, 2012 10:16 AM

              Edited by: Pinela on Aug 24, 2012 10:18 AM

              Edited by: Pinela on Aug 24, 2012 10:21 AM
              • 4. Re: startup upgrade ORA-00205: error in identifying control file
                user10698496
                which sqlplus is showing 11g path only.but sqlplus login is showing 10g path
                [OMIGTEST]/oracle/ora11203/network/admin> which sqlplus
                /oracle/ora11203/bin/sqlplus
                [OMIGTEST]/oracle/ora11203/network/admin> sqlplus
                
                SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 23 15:58:38 2012
                
                Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
                
                Enter user-name:
                • 5. Re: startup upgrade ORA-00205: error in identifying control file
                  Pinela
                  hum....
                  try setting your vars on the bash_profile, or use the file method and . <file>.

                  other than that, enter the bin directory for the new home, and run ./sqlplus / as sysdba
                  this last one, has to work (even though not be best answer).
                  usually, if I have more than one OH, I create different files with the right exports, and then set the envs:
                  . <fileenv1>.env
                  . <fileenv2>.env

                  if the oraenv file is not working for missing data in /etc/oratab.
                  this works for me.
                  PRD@/oracle\>sqlplus
                  SQL*Plus: Release 10.1.0.4.2 - Production on Fri Aug 24 11:50:37 2012
                  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                  Enter user-name:
                  PRD@/oracle\>. setPRD.env
                  PRD@/oracle\>sqlplus
                  SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 24 11:50:51 2012
                  Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
                  Enter user-name:
                  PRD@/oracle\>. setDEV10g.env
                  PRD@/oracle\>sqlplus
                  SQL*Plus: Release 10.1.0.4.2 - Production on Fri Aug 24 11:51:06 2012
                  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                  Enter user-name:
                  the files have:
                  export ORACLE_HOME=/oracle/product/dev10g
                  export PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin.:/usr/local/bin:$ORACLE_HOME/bin

                  after creating it:
                  chmod a+x <file>

                  Edited by: Pinela on Aug 24, 2012 10:53 AM
                  • 6. Re: startup upgrade ORA-00205: error in identifying control file
                    user10698496
                    Hi,
                    Issue of sqlplus is solved after setting proper LD_LIBRARY_PATH.

                    But eve after that startup upgrade showing same error.
                     sqlplus '/as sysdba'
                    
                    SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 23 16:22:16 2012
                    
                    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
                    
                    
                    Connected to:
                    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                    SQL> startup upgrade
                    ORACLE instance started.

                    Total System Global Area 1636892672 bytes
                    Fixed Size 2183056 bytes
                    Variable Size 1090519152 bytes
                    Database Buffers 536870912 bytes
                    Redo Buffers 7319552 bytes
                    ORA-00205: error in identifying control file, check alert log for more info
                    Do i copy control file from 10g home and place in in 11g path and mention it in init.ora before upgrade?
                    
                    Thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                    • 7. Re: startup upgrade ORA-00205: error in identifying control file
                      Pinela
                      hi,

                      you don't need to copy the CF.
                      you just need to keep it where it is, and mentioning it in the init.
                      you can't comment the control_files parameter. if you do that, the db won't find it.

                      just that. If the DB can find the CF, it will mount.

                      BR,
                      Pinela.
                      • 8. Re: startup upgrade ORA-00205: error in identifying control file
                        user10698496
                        So in new init.ora file of 11g home what shall i mention for control files?it shud point to 10g's control files?
                        • 10. Re: startup upgrade ORA-00205: error in identifying control file
                          vlethakula
                          Your control file location does not change,
                          In summary you need to do:

                          1) Copy pfile from 10g to 11g home

                          2)Start upgrade

                          3)@catupgrd.sql

                          and other post upgrade steps as per metalink note : Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

                          You can try dbua its quite simple:

                          1)Take backup of 10g database.

                          2) export ORACLE_HOME to 11g home
                          export PATH
                          type dbua----it should pick form 11g home

                          dbua -silent -sid <SIDNAME>
                          • 11. Re: startup upgrade ORA-00205: error in identifying control file
                            Srini Chavali-Oracle
                            Pl post OS details

                            >
                            export ORACLE_HOME=/oracle/ora11203
                            ...
                            export ORACLE_BASE=/oracle/ora11203/app/ora11203
                            >

                            You have these two definitions mixed-up - they should be switched - ORACLE_HOME is always a subdirectory under ORACLE_BASE. not the other way around

                            http://docs.oracle.com/cd/E11882_01/install.112/e24321/glossary.htm#g998168

                            HTH
                            Srini