This discussion is archived
8 Replies Latest reply: Sep 24, 2012 6:54 PM by 964103 RSS

oracle 10g update from 10.2.0.1 to 10.2.0.4

knowledgespring Newbie
Currently Being Moderated
Hi all,

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

method:
# 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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points