8 Replies Latest reply: Sep 24, 2012 8:54 PM by 964103 RSS

    oracle 10g update from 10.2.0.1 to 10.2.0.4

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