Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC upgrade from 11.2.0.2 to 11.2.0.3

User321378Apr 30 2013 — edited Apr 30 2013
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 ?

Comments

FreddieEssex
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?
User321378
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?
FreddieEssex
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
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 28 2013
Added on Apr 30 2013
#performance-availability, #rac-asm-clusterware-installation
3 comments
1,090 views