2 Replies Latest reply: Nov 3, 2012 5:35 AM by Srini Chavali-Oracle RSS

    upgrade from 11.2.0.1 to 11.2.0.3

    sachinpawan
      hi all,
      how can i upgrade my DB software from 11.2.0.1 to 11.2.0.3

      thanks in advance!
        • 1. Re: upgrade from 11.2.0.1 to 11.2.0.3
          Shivananda Rao
          Hello,

          You need to perform an out of place upgrade.
          1. Install 11.2.0.3 on a different home
          2. run the pre-upgrade tool on the existing 11.2.0.1 database
          3. peform the pre-requisities mentioned
          4. Bring down the database from 11.2.0.1 and start the database in upgrade mode from 11.2.0.3 home by copying the pfile/spfile of 11.2.0.1 database to $11.2.0.3_HOME/dbs path
          5. startup upgrade and run the catupgrd.sql

          Make sure you look out for the invalid objects.

          Refer *Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]*
          • 2. Re: upgrade from 11.2.0.1 to 11.2.0.3
            Srini Chavali-Oracle
            Follow the steps in the Upgrade Guide - http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

            Use DBUA to perform the upgrade

            HTH
            Srini