ORA-00205: error in identifying control file,
- From: Nisha Mohan <NishaMohan_A@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Aug 2012 11:19:51 +0000
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
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 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
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***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
