This content has been marked as final. Show 8 replies
If you do it the best way is to read and follow the docs ... not ask strangers if they agree with a small number of bullet points.
But I disagree with your entire direction. 10gR2 goes into desupport mode at the end of this month. Why move to something that will be desupported before you get there? Why not 126.96.36.199 or 188.8.131.52?
If you must stay with 10g for awhile at least go to 10.2.0.5.
You do not need a new ORACLE_HOME. Just follow the steps in the 10.2.0.4 or 10.2.0.5 README file and make sure you have good cold backups before you start anything :-)
In addition to the points above, i would recommend testing out the upgrade on a clone of your production database before doing it for real for two reasons:
- to find out in advance any peculiar problems your particular database may run into during the upgrade
- to allow you to do some testing to make sure your applications work with the upgraded database.
See if this helps:
I hope this links http://www.oracleflash.com/29/Upgrade-Oracle-10g-Release-2-from-10201-to-10204.html and http://faruqueahmed.wordpress.com/2010/02/08/upgrade-oracle-10g-from-10-2-0-1-to-10-2-0-4-single-instance/ will be useful for you.
I have implemented it, it works!
Edited by: Ulfet Tanriverdiyev on Jul 8, 2010 1:25 AM
Can you please provide useful link for update from 10.2.0.3 to 10.2.0.5 with step by step process.?
Thanks in Advance.
All the information you need is in the README of the 10.2.0.5 patch.
This is very good!