This content has been marked as final. Show 11 replies
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>
if you run:
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
create a file X.env with your exports, and then running
./sqlplus / as sysdba
this will work.
but you still need to uncomment the control_files line.
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
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:
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:
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:
after creating it:
chmod a+x <file>
Edited by: Pinela on Aug 24, 2012 10:53 AM
Issue of sqlplus is solved after setting proper LD_LIBRARY_PATH.
But eve after that startup upgrade showing same error.
SQL> startup upgrade
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. Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.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
Your control file location does not change,
In summary you need to do:
1) Copy pfile from 10g to 11g home
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
type dbua----it should pick form 11g home
dbua -silent -sid <SIDNAME>
Pl post OS details
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