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..
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