This discussion is archived
6 Replies Latest reply: May 7, 2012 8:39 AM by OldGuy RSS

Upgrade from 11.2.0.1 to 11.2.0.3

OldGuy Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points