RE: ORA-00205: error in identifying control file,

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Fri, 24 Aug 2012 11:15:40 -0400
Message-ID: <AD4532B304E00C4F9AEFA0D338DF7DD10D8F05D060_at_excnysm95banp.nysemail.nyenet>


I would simply reference the 10g controlfile in the 11g init.ora file and do your upgrade.

No reason to make a new copy of it.


From: Nisha Mohan <> To: "" <> Sent: Friday, August 24, 2012 5:19 AM
Subject: ORA-00205: error in identifying control file,

I am doing a manual upgrade from 10.2.04 to 11.2.03. I have installed
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 TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_BASE=/oracle/ora11203/app/ora11203 export LD_LIBRARY_PATH=/oracle/ora11203/lib:/usr/local/lib

Now when i try to start DB from the unix session where all of above variables are set,i am getting following issue.

sqlplus '/as sysdba'

SQL*Plus: Release 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 - 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

The following entry is present in init.ora.If I keep this entry or comment it out,Iam getting same issue.

control_files    = (/oracle/ora11203/dbs/ctrl_1_OMIGTEST.ctl)

Do i copy control file from 10g home and place in in 11g path and mention it in init.ora before upgrade?

Thanks and Regards,
Nisha Mohan.A

  • CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***


-- Received on Fri Aug 24 2012 - 10:15:40 CDT

Original text of this message