-
1. Re: startup upgrade ORA-00205: error in identifying control file
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
I think the database is started from 10g home only even after setting variables.
Even after setting these variables when i do sqlplus it is going to 10g.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
How do i resolve this?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> -
3. Re: startup upgrade ORA-00205: error in identifying control file
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
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
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.
the files have: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:
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
Hi,
Issue of sqlplus is solved after setting proper LD_LIBRARY_PATH.
But eve after that startup upgrade showing same error.
SQL> startup upgradesqlplus '/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
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
hi,1 person found this helpful
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
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
Your control file location does not change,1 person found this helpful
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
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
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.