ORA-00205: error in identifying control file,

From: Nisha Mohan <NishaMohan_A_at_infosys.com>
Date: Fri, 24 Aug 2012 11:19:51 +0000
Message-ID: <D2EF2C83C5C50B4CB202F0619D52874801883C_at_BLRKECMBX11.ad.infosys.com>

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 - 06:19:51 CDT

Original text of this message