5 Replies Latest reply: Aug 23, 2012 6:37 AM by Helios-GunesEROL RSS

    11.2.0.1 & 11.2.0.2 upgrade

    user640001
      Hi,

      Oracle 11.2.0.1 & 11.2.0.2
      Solaris10 64bit

      Want to upgrade two databases :

      1) from 11.2.0.1 to 11.2.0.3

      and

      2) from 11.2.0.2 to 11.2.0.3

      which is the best and reliable method for the above two upgrade ?
        • 1. Re: 11.2.0.1 & 11.2.0.2 upgrade
          kuljeet singh -
          To upgrade to Oracle Database release 11.2.0.3, you must have to install Oracle Grid Infrastructure and Oracle Database software into a new Oracle home .
          and before upgrade run Pre-Upgrade Script .
          complete guide is available
          http://www.oracle.com/technetwork/products/upgrade/best-practices-for-upgrade-11gr2v3-1502927.pdf
          • 2. Re: 11.2.0.1 & 11.2.0.2 upgrade
            Srini Chavali-Oracle
            Pl see the documents referenced in this MOS Doc

            Oracle Database Upgrade Path Reference List [ID 730365.1]

            HTH
            Srini
            • 3. Re: 11.2.0.1 & 11.2.0.2 upgrade
              vlethakula
              1)Download the 11.2.0.3 patchset and install oracle software into separate home
              2)Take a backup of existing databases.
              3) Run dbua
              export ORACLE_HOME=<new 11.2.0.3 path>
              dbua -silent -sid <sidname>

              Assuming there is no GI installed
              • 4. Re: 11.2.0.1 & 11.2.0.2 upgrade
                585179
                Hi,

                In 11g it is recommended to do out-of-place upgrade.

                Have a read http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm for details

                Hope it helps

                Cheers
                Fiedi
                • 5. Re: 11.2.0.1 & 11.2.0.2 upgrade
                  Helios-GunesEROL
                  Hi;

                  Your question is already documented. Please 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]

                  I strongly suggest toe 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

                  Regard
                  Helios