4 Replies Latest reply: Aug 24, 2012 10:02 AM by reddy1234 RSS

    Required upgrade assistance from 11.2.0.2 to 11.2.0.3

    reddy1234
      Hi

      Can some one tell me the upgrade paths available from 11.2.0.2 to 11.2.0.3 Rac 2 node database on RHEL 5.

      I would like to do inplace upgrade. (Please refer me a related documents)
      If its not a good idea out-place upgrade (Please refer me a related documents).


      Thanks in advance

      Edited by: reddy1234 on Aug 7, 2012 3:55 PM
        • 1. Re: Required upgrade assistance from 11.2.0.2 to 11.2.0.3
          damorgan
          Upgrade docs can be found at:
          https://support.oracle.com
          and
          http://docs.oracle.com
          • 2. Re: Required upgrade assistance from 11.2.0.2 to 11.2.0.3
            Srini Chavali-Oracle
            In-place upgrade is possible, but not recommended.

            Oracle Database Upgrade Path Reference List [ID 730365.1]
            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]
            Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]

            http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

            HTH
            Srini
            • 3. Re: Required upgrade assistance from 11.2.0.2 to 11.2.0.3
              Helios-GunesEROL
              Hi;

              Starting from 11.2.0.2, the binaries are released as a patch sets and that are full installation packages which needs to be installed on a separate ORACLE_HOME.

              Refer:-
              Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 (Doc ID 1189783.1)

              Before upgrading to 11.2.0.3, the recommended patches should be applied to the existing grid environment.

              Refer the below document for the recommended patches.

              Things to Consider Before Upgrading to 11.2.0.3 Grid Infrastructure/ASM (Doc ID 1363369.1)

              In order to install 11.2.0.3, you need to download the Patch 10404530 from MOS.

              Refer the below document for the link to download the patchset.

              11.2.0.3 Patchset Location For Grid Infrastructure And RDBMS (Doc ID 1362393.1)

              Once the patch 10404530 has been downloaded and extracted, start the runInstaller from the staging area and choose the third option "Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management" and choose the separate home.

              The rest of the proceess will be guieded by the OUI.

              Refer the online documentation for the ugprade steps:
              http://docs.oracle.com/cd/E11882_01/install.112/e24614/procstop.htm#CEGDFAEE

              Also review:
              Minimizing Downtime During Production Upgrade [ID 478308.1]
              Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]
              Different Upgrade Methods For Upgrading Your Database [ID 419550.1]


              Please check my blog

              http://heliosguneserol.wordpress.com/2010/06/17/move-to-oracle-database-11g-release-2-wiht-mike-dietrich/

              In this pdf you can see patch of to upgrade db from x to n wiht many senerios wiht all related metalinks notes which is created by Oracle worker Mike Dietrich

              PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding

              Regard
              Helios
              • 4. Re: Required upgrade assistance from 11.2.0.2 to 11.2.0.3
                reddy1234
                Thanks for the awesome reply.....