The datafile location doesn't change.
You start the database in upgrade mode out of the new 11g ORACLE_HOME before you do the upgrade.
Please read the upgrade guide: http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
No no no....assuming you're doing a manual upgrade start the database in upgrade mode out of your 11g home and then run the catupgrd script.
you are making me confusion ..
start the database in upgrade mode out of your 11g home
10g $ORACLE_HOME : /u01/app/oracle/oracle/product/10.2.0
11g $ORACLE_HOME : /u02/app/oracle/oracle/product/11.2.0
Tell me , how can i start , which path do you recommend , what i mentioned above ?
please paste here ;
Which bit is confusing? Just to clarify, I'm not recommending a path...there is only one correct path to start your database out of should you wish to do the upgrade and that is your 11g ORACLE_HOME.
From the link I sent you:
Step 3 - Set your ORACLE_HOME to the 11.2 directory.
Step 9 - startup upgrade
Step 12 - Run catupgrd.sql
I think the question of the poster is more technical, and also it's a question that I also had
It seems to depend on the choice : DBUA versus Manual Upgrade
DBUA wants to know what is your CURRENT (OLD) Oracle Home, and along the process asks for the new Oracle Home.
The Manual Upgrade explicitally needs the environment to be set to the NEW Oracle Home, and doesn't do anything with the old Oracle Home (?), doesn't want to even know what it is.
There's a big impact in preparation, because ORATAB is involved here, and the above got me wondering, but what I described, seems to be the case, and it's rather confusing I think ...
Please confirm the above is correct or not
The fact that one Oracle Home is in one disk (mountpoint) and the other Oracle Home into another one is not relevant, since the Oracle software only beholds the paths themselves, mount points are just a technical thing in the background.
The Manual Upgrade explicitly needs the environment to be set to the NEW Oracle Home, and doesn't do anything with the old Oracle Home (?), doesn't want to even know what it is.
Well if you check MOS document Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1) you can see clearly that in the first preparation part there are quite a lot of task to work on the source database or "OLD oracle home" or source environment. But once you copied over initialization files and maybe some others form source to target the old home is not really needed anymore.
So you are almost correct.
Create a detailed plan in excel based on the oracle doc 837570.1, that pertain to your particular system and environment.
Basic steps are quite simple after all the prep work is completed (pre-upgrade utility etc)
- copy the initialization file (pfile) from source Oracle Home to <target 11GR2 home>/dbs
- Make sure the following environment variables point to the Oracle 11g Release 2 (11.2) directories:
- PATH, LD_LIBRARY_PATH etc
- Update the oratab entry to set the new ORACLE_HOME pointing to ORCL and disable automatic startup.
- At the operating system prompt, change to the $ORACLE_HOME/rdbms/admin directory of 11gR2 Oracle Home.
- Start the database in upgrade mode: startup upgrade
SQL> startup UPGRADE
- Run upgrade script