Upgrade from 10.2.0.1 SE to 10.2.0.4 EE -- What way to follow?
gcJun 23 2010 — edited Jun 23 2010Hi !!
I have a Database (10.2.0.1 SE) on Solaris 10 os. I need to upgrade the database to 10.2.0.4 EE.
As of now I have planed the upgrade procedure in the below manner ....
1)Take the database full backup (online backup with rman in archivelog mode) +archivelogs.
2)Install 10.2.0.1 EE software in a saperate ORACLE_HOME.
3)Patch the new ORACLE_HOME to 10.2.0.4 EE home.
4)Shutdown the db from 10.2.0.1 SE home.
5)Startup the db from new 10.2.0.4 EE home with 'startup upgrade' command.
6)Running the catupgrd.sql from new 10.0.2.4 EE home.
7)Run utlu102s.sql to display the results of the upgrade.
8)Run utlrp.sql to recompile any remaining stored PL/SQL and Java code.
Pls. suggest am I right or not? Am I missing something?
More on this ......
Now I have found from oracle document that to move from 10.2.0 SE to 10.2.0 EE I do not need to run catupgd.sql. Only I need to do is install 10.2.0 Base binaries and point the existing db to the new home and 'startup'. As it stated here ..
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/intro.htm#BABFBJCC
My question if i follow the steps as per the link suggest am I will be able to startup the 10.2.0.1 SE database with the 10.2.0.4 EE home?
Or in this senerio it has suggested that to use the base release 10.2.0.1 EE to 'startup' and then patch it to 10.2.0.4 EE ?
Pls. Help !!!
Thx.
GC