I like to update oracle 10g database from 10.2.0.1 to 10.2.0.4 by applying patch sets, would one please suggest me the best way.
I am planning to do in the way explained below
# Install new Oracle Home
# Apply the patch to the new Home
# Shut down the database
# Change Oracle Home to the new location
# Start the database
Can you one suggest me how to do "Change Oracle Home of database to the new location" and back to older oracle_home incase if there are any issues, how to do and what changes requried to make database is run without any probs..
Thanks in advance..
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 188.8.131.52 or 184.108.40.206?
If you must stay with 10g for awhile at least go to 10.2.0.5.
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.
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