8 Replies Latest reply on Sep 25, 2012 1:54 AM by 964103

    oracle 10g update from to

      Hi all,

      I like to update oracle 10g database from to 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..