Re: ORA-00205: error in identifying control file,
Date: Fri, 24 Aug 2012 07:24:45 -0700 (PDT)
You should probably start the database nomount then create a new controlfile with the create controlfile command; from your 10.2.0.4 database you can generate a basic script to do this by issuing the following command at the SQL> prompt:
alter database backup controlfile to trace; Edit the resulting script to open the database resetlogs then run it after a startup nomount.
From: Nisha Mohan <NishaMohan_A_at_infosys.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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 184.108.40.206.
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 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 220.127.116.11.0 Production on Thu Aug 23 16:22:16 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 18.104.22.168.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
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,
- 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***