7 Replies Latest reply: Feb 11, 2013 9:16 AM by Srini Chavali-Oracle RSS

    Applying patch 11.2.0.1 to 11.2.0.3

    $phinx19
      Hi All,

      I need to upgrade my current version of oracle database 11.2.0.1 to 11.2.0.3 on windows 03 platform.
      I am doing patching for the first time. Appreciate if you can provide me some links, I know readme doc is also there along with the patch but still.

      Regards,
      Sphinx
        • 1. Re: Applying patch 11.2.0.1 to 11.2.0.3
          Srini Chavali-Oracle
          At a high level, you will need to

          1. Download and install 11.2.0.3 (which is a full install) into a new ORACLE_HOME

          2. Apply the latest PSU patch to 11.2.0.3

          3. Upgrade the database following the steps in the Upgrade Guide (using DBUA)

          11.2.0.3 Patch Set - Availability and Known Issues [ID 1348336.1]
          Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
          Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results [ID 1392633.1]
          Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1]
          Quick Reference To Patch Numbers For Database PSU, SPU(CPU) And Bundle Patches [ID 1454618.1]

          Install Guide - http://docs.oracle.com/cd/E11882_01/install.112/e24186/toc.htm
          Upgrade Guide - http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

          HTH
          Srini
          • 2. Re: Applying patch 11.2.0.1 to 11.2.0.3
            vlethakula
            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]

            Summary of steps using dbua


            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. export ORACLE_HOME=<11.2.0.3home>
            export PATH=$ORACLE_HOME/bin:$PATH
            type dbua ---------->It should pick from 11.2.0.3

            dbua -silent -sid <instancename>
            • 3. Re: Applying patch 11.2.0.1 to 11.2.0.3
              Krishna-Oracle
              Hi,
              Kindly refer the below documents
              Note 419550.1 : Different Upgrade Methods For Upgrading Your Database
              Note 837570.1 : Complete Checklist for Manual Upgrades to 11gR2
              Note 870814.1 : Complete checklist to upgrade the database to 11gR2 using DBUA

              Thanks,
              Krishna
              • 4. Re: Applying patch 11.2.0.1 to 11.2.0.3
                $phinx19
                Hi,

                I am following the steps that you have mentioned in here using DBUA. There is one more while upgrading the oracle database, Oracle is asking me to turn off the archive log mode of the database. Do I have to trun off the archive log mode or I have to keep it as it is.

                One more thing. which is the most preferred method for upgrading in case of a averages size of database.

                Regards,
                Sphinx
                • 5. Re: Applying patch 11.2.0.1 to 11.2.0.3
                  Srini Chavali-Oracle
                  It is recommended to turn off archivelog mode for the duration of the upgrade, but it is not required.

                  DBUA is the recommended/preferred method - what is your definition of 'average' ? 10Gb ? 10Tb ? 10Pb ?

                  HTH
                  Srini
                  • 6. Re: Applying patch 11.2.0.1 to 11.2.0.3
                    $phinx19
                    Hi Srini,

                    Thanks.

                    I agree average is a vague term to use as the DB size varies randomly.
                    • 7. Re: Applying patch 11.2.0.1 to 11.2.0.3
                      Srini Chavali-Oracle
                      BTW, the time taken to upgrade does not depend on the size of the database.

                      See page 7 in this Doc - http://www.oracle.com/technetwork/products/upgrade/11gr2-upgrade-bp-apr2012-1610082.pdf

                      HTH
                      Srini