6 Replies Latest reply: May 7, 2012 10:39 AM by OldGuy RSS

    Upgrade from 11.2.0.1 to 11.2.0.3

    OldGuy
      We are currently running in production Oracle DBMS 11.2.0.1 on RHEL5.6. We have been looking at the CPUs (Critical Patch Update) for 11.2.0.1... but all we can find are CPUs for 11.2.0.2 or 3. This begs a few questions... 1) are there CPUs for 11.2.0.1? 2) if not, then how do we upgrade from 11.2.0.1 to 11.2.0.2 or 3?

      What I have found thus far indicates that the 11.2.0.2 and 3 are not patches but require a complete install with separate Oracle Homes, etc... This is not what we want.

      Has anyone upgraded to 11.2.0.3 from 11.2.0.1? If so, difficulty? Requirements? Steps? Docs? Does it really require a complete install and new Oracle home?
        • 1. Re: Upgrade from 11.2.0.1 to 11.2.0.3
          Srini Chavali-Oracle
          OldGuy wrote:
          We are currently running in production Oracle DBMS 11.2.0.1 on RHEL5.6. We have been looking at the CPUs (Critical Patch Update) for 11.2.0.1... but all we can find are CPUs for 11.2.0.2 or 3. This begs a few questions... 1) are there CPUs for 11.2.0.1? 2) if not, then how do we upgrade from 11.2.0.1 to 11.2.0.2 or 3?
          11.2.0.1 is a de-supported release, hence no CPUs are available. The last one was July 2011.
          What I have found thus far indicates that the 11.2.0.2 and 3 are not patches but require a complete install with separate Oracle Homes, etc... This is not what we want.

          Has anyone upgraded to 11.2.0.3 from 11.2.0.1? If so, difficulty? Requirements? Steps? Docs? Does it really require a complete install and new Oracle home?
          Yes, starting with 11.2.0.2, patches are not patches but complete installs that need to be installed in separate/new ORACLE_HOMEs. The upgrade process is documented in the 11gR2 upgrade guide

          Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.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]     
          Oracle Database Upgrade Path Reference List [ID 730365.1]     

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

          HTH
          Srini
          • 2. Re: Upgrade from 11.2.0.1 to 11.2.0.3
            OldGuy
            Thank you for the response...

            That's what I had read and was hoping it was "wrong" or at least not accurate. I would understand if it were upgrading from 11g to 12, but a 4th digit release? Doesn't make sense to have to create a whole new Oracle home everytime we would upgrade...
            • 3. Re: Upgrade from 11.2.0.1 to 11.2.0.3
              Srini Chavali-Oracle
              It is what it is - the rationale for this decision is described in MOS Doc 1189783.1 - I personally think this is a better approach, since installing a new version will no longer require downtime, only the upgrade portion will.

              HTH
              Srini
              • 4. Re: Upgrade from 11.2.0.1 to 11.2.0.3
                OldGuy
                So, there is no way to install/upgrade to 11.2.0.2/3 in place? Using the same oracle home?
                • 5. Re: Upgrade from 11.2.0.1 to 11.2.0.3
                  Srini Chavali-Oracle
                  Yes there is - pl see the Upgrade Guide - http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD52700


                  In-Place Upgrade on UNIX For Single Instance 11gR2 Database [ID 1377613.1]
                  In-Place Upgrade to 11.2.0.2 on Windows Platform [ID 1291682.1]     

                  HTH
                  Srini
                  • 6. Re: Upgrade from 11.2.0.1 to 11.2.0.3
                    OldGuy
                    Thanks... reading that -- although there are copious warnings -- sounds like it will work. Seeing that we are using VMs I can take a snapshot of the current setup and revert to it if the upgrade doesn't work properly...