Forum Stats

  • 3,854,257 Users
  • 2,264,344 Discussions
  • 7,905,623 Comments

Discussions

Upgrade primary and standby (physical) database from 11.2.0.2 to 11.2.0.4

user12263870
user12263870 Member Posts: 4 Blue Ribbon
edited May 12, 2020 2:10PM in Database Upgrade

Is there a technical document (step by step) that will tell me how to upgrade our Oracle databases from 11.2.0.2 to 11.2.0.4

I have a primary database and a physical standby database in each environment that will need upgraded.

Can I do a "rolling upgrade" using the Physical Standby database?

Also, after upgrading to 11.2.0.4, what PSU patch(es) will I need to apply?

Red Hat Linux OS

Thanks.

user12263870

Answers

  • Daniel Overby Hansen-Oracle
    Daniel Overby Hansen-Oracle Posts: 93 Employee
    edited Apr 14, 2020 3:25PM

    Hi,

    I suggest that you start off by reading the Upgrade Guide in the documentation:

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

    Also, I advise you to take a look at this MOS note:

    Complete Checklist for out-of-Place Manual Upgrade from Previous 11.2.0.N Version to the Latest 11.2.0.N Patchset (Doc ID 1276368.1)

    The standby databases get upgraded automatically via redo apply. You upgrade the primary database, and when you re-enable the redo apply the upgrade changes propagates to the standby database. The "rolling" upgrade option you have in 11.2 is the Transient Logical Standby which can be used to minimize downtime. In 12.1 (or is it 12.2) it is greatly enhanced with the DBMS_ROLLING package, but it requires an active data guard license.

    If you don't have any very restrict requirements for downtime I suggest that you do it the "normal" way.

    I suggest that you apply the newest PSU to the 11.2.0.4 Oracle Home BEFORE the upgrade. That way you don't have to patch afterwards and your downtime will be minimized.

    Bear in mind that 11.2.0.4 is already very old and running out of support. Consider already now planning your upgrade to a newer version - 19 is a good option. When upgrading from 11.2.0.4 you can take advantage of the new AutoUpgrade tool which simplies upgrading A LOT:

    https://www.oracle.com/a/otn/docs/database-upgrade-quick-start-guide.pdf

    Regards,

    Daniel

    user12263870user12263870
  • user12263870
    user12263870 Member Posts: 4 Blue Ribbon
    edited Apr 15, 2020 4:08PM

    Thank you for your quick response.

    I would like to upgrade the Databases but unfortunately we have to upgrade the Red Hat linux first. THese are old servers. I am upgrading to 11.2.0.4 from 11.2.0.2 in order to alleviate the SCN limit issue. I was told getting to 11.2.0.4 would accomplish that.

    How do I apply the Latest PSU patch in Oracle Home before I upgrade?

    Sorry for the questions. I am new to upgrading/patching Oracle. We don't have a more experienced DBA on the team.

    Thanks.

  • Daniel Overby Hansen-Oracle
    Daniel Overby Hansen-Oracle Posts: 93 Employee
    edited Apr 16, 2020 2:51AM

    Hi,

    Just install the 11.2.0.4 Oracle Home like you would normally do and then immediate apply the software patch to the Oracle Home. Next, you can start on the upgrade work.

    My fellow PM Mike Dietrich actually just did a blog post on how to apply the latest PSUs:

    https://mikedietrichde.com/2020/01/22/patching-all-my-environments-with-the-january-2020-patch-bundles/

    There is a chapter on 11.2.0.4. You can skip item #3 as you don't have a database yet. That should be done afterwards.

    Also, if you want to practice you can use the Hands-On-Labs from Mikes page as well. It is a virtualbox image that you can download and run anywhere. It has an 11.2.0.4 database so you can practice the patch apply.

    Regards,

    Daniel

    user12263870user12263870
  • user12263870
    user12263870 Member Posts: 4 Blue Ribbon
    edited May 12, 2020 2:10PM

    Thanks again for all of your help.