FAQ
Trying to plan an upgrade of DBMS & GRID from 11.2.0.2 to 11.2.0.3 on
AIX.
Reading through various Metalink documents including "Things to consider
before upgrading to 11.2.0.3" (#1363369.1)

If I am reading this stuff correctly, I need to do the following:

1) upgrade opatch to a minimum of 11.2.0.1.3 for all DB and GRID
oracle-homes
2) apply 11.2.0.2--PSU1 (10248523) to all DB and GRID oracle-homes
3) apply one-off patch 12539000 to DB and GRID oracle-homes
4) upgrade to 11.2.0.3

This seems like a lot of steps for a patch set upgrade.

Do I have this correct?
Has anybody done this yet?

Thanks........




Dan Hubler
Database Administrator
Aurora Healthcare
414-647-3257
daniel.hubler@aurora.org

Search Discussions

  • Martin Bach at Jan 20, 2012 at 9:37 pm
    Hi Daniel,

    yep, that's correct. If it helps, it wasn't too different from 11.2.0.1
    to 11.2.0.2 either, except that we only needed PSU 1 to be applied.

    Done it on Linux, although I decided to go from 11.2.0.2.0 to 11.2.0.2.3
    instead of 11.2.0.2.1 and it was pain free except for the lengthy
    procedure. Just ensure you get the correct one-off depending on the PSU
    you applied. It corrects a bug in asmca's rolling upgrade procedure
    which is executed on the last node in the cluster. OPatch auto is my friend!

    Regards,

    Martin
  • K R at Jan 20, 2012 at 9:56 pm
    do we need the PSU 1 to be applied on 11.2.0.2 if it is not a clustered
    database.
    I have 11.2.0.2 on ASM and single instance . and I was able to upgrade
    both ASM/GI and the DB to 11.2.0.3 without applying any PSU to the
    11.2.0.2 .

    did I miss anything .

    appreciate any suggestion.....

    On Fri, Jan 20, 2012 at 1:35 PM, Martin Bach
    wrote:
    Hi Daniel,

    yep, that's correct. If it helps, it wasn't too different from 11.2.0.1
    to 11.2.0.2 either, except that we only needed PSU 1 to be applied.

    Done it on Linux, although I decided to go from 11.2.0.2.0 to 11.2.0.2.3
    instead of 11.2.0.2.1 and it was pain free except for the lengthy
    procedure. Just ensure you get the correct one-off depending on the PSU
    you applied. It corrects a bug in asmca's rolling upgrade procedure
    which is executed on the last node in the cluster. OPatch auto is my
    friend!

    Regards,

    Martin
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 20, '12 at 9:27p
activeJan 20, '12 at 9:56p
posts3
users3
websiteoracle.com

3 users in discussion

Daniel Hubler: 1 post K R: 1 post Martin Bach: 1 post

People

Translate

site design / logo © 2022 Grokbase