This discussion is archived
3 Replies Latest reply: Apr 30, 2013 4:18 AM by FreddieEssex RSS

RAC upgrade from 11.2.0.2 to 11.2.0.3

User321378 Newbie
Currently Being Moderated
Dear Experts,

i have requirement to upgrade the DB from 11.2.0.2 to 11.2.0.3 and below is my setup.

1) we have three cluster database running in 3-node RAC and Two database are running in 11.2.0.3.
2) Only one DB is running in 11.2.0.2. so i already have 11.2.0.3 and 11.2.0.2 cluster installed in that server and two Database are running in 11.2.0.3.

i have been asked to upgrade from database 11.2.0.2 to 11.2.0.3

did anyone have come across such scenario where you have 11.2.0.2 and 11.2.0.3 cluster RAC binaries are in place, and we need to upgrade only the DB running in 11.2.0.2 to 11.2.0.3 ?
  • 1. Re: RAC upgrade from 11.2.0.2 to 11.2.0.3
    FreddieEssex Pro
    Currently Being Moderated
    Hi,

    This is a pretty straight forward upgrade from 11.2.0.2 to 11.2.0.3. You can use the same 11.2.0.3 binaries that are already there or if you want/need then create a separate ORACLE_HOME for your new database.

    The upgrade will be transparent to your other 11.2.0.3 databases on the cluster.

    What is your question..or did I miss it?
  • 2. Re: RAC upgrade from 11.2.0.2 to 11.2.0.3
    User321378 Newbie
    Currently Being Moderated
    Dear Freddie,

    Thanks for your comments.
    do we have any standard procedures, we need to follow for upgrading in 11.2.0.2 to 11.2.0.3?
    i have done many standalone DB upgrades , havent done any any cluster DB upgrade. so i dont want to miss out any steps?

    please let me know what steps i should follow?
  • 3. Re: RAC upgrade from 11.2.0.2 to 11.2.0.3
    FreddieEssex Pro
    Currently Being Moderated
    Hi,

    Use DBUA to make your life easier if you haven't done this before. Presumably your ASM and CRS are already at 11.2.0.3.

    From memory, if you are doing an manual upgrade then it's not much different to doing a standalone upgrade.

    You set cluster_database=false first, run through the steps and then set cluster_database=true at the end.

    You will also need to update the oracle_home for this database to the new home in CRS using:
    srvctl upgrade database -d <db_name> -o <oracle_home>
    You need to confirm the steps by reading the docs at http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

    Also see:
    http://docs.oracle.com/cd/E11882_01/install.112/e24660/racinstl.htm#BABJGBHB
    http://docs.oracle.com/cd/E11882_01/server.112/e10819/upgrade.htm#BABCEGBC

Legend

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