Oracle RAC Upgrade 11.2.0.1 to 11.2.0.4

11.2.0.1 to 11.2.0.4 upgrade Oracle RAC

Stop database.
Stop crs

Pre Req Patch application

First apply patch 9706490

The above patch is a pre req for upgrade from 11.2.0.1 to 11.2.0.4

oracle:srvctl stop database -d cool
root:crsctl stop cluster -all

[root@rac1 9706490]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

Patching crs home first

[oracle@rac1 ~]$ export PATH=/u01/app/11.2.0/grid/OPatch:$PATH
[oracle@rac1 ~]$ which opatch
/u01/app/11.2.0/grid/OPatch/opatch
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/11.2.0/grid/
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/11.2.0/grid/
[oracle@rac1 ~]$ cd /u01
[oracle@rac1 u01]$ cd 9706490/
[oracle@rac1 9706490]$ opatch napply -local -oh /u01/app/11.2.0/grid/ -id 9706490

Once opatch is success.

Now patch db home

[oracle@rac1 9706490]$ cd custom/scripts
[oracle@rac1 scripts]$ . oraenv
ORACLE_SID = [orcl] ? cool1
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@rac1 scripts]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
[oracle@rac1 scripts]$ sh prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/dbhome_1
prepatch.sh completed successfully.
[oracle@rac1 scripts]$ cd ../..
[oracle@rac1 9706490]$ opatch napply custom/server/ -local -oh /u01/app/oracle/product/11.2.0/dbhome_1 -id 9706490

After success. Do similar steps in node 2 .


[oracle@rac2 9706490]$ cd custom/scripts
[oracle@rac2 scripts]$ sh postpatch.sh -dbhome /u01/app/oracle/product/11.2.0/dbhome_1
[root@rac1]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
[root@rac2]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch


***************************************************************************

GRID SOFTWARE UPGRADE

I did not shutdown crs or database on any node for the upgrade.. It may vary

unzip grid folder
runInstaller
select upgrade existing grid infrastructure
Create a new home folder on the 2 nodes.
Give the path in installer.. Follow on screen instructions..
Fix any prechecks or ignore
Run rootupgrade.sh on node1 and node2

Last message you should see is

Configure Oracle Grid Infrastructure for a Cluster ... succeeded


Thats it.

verify
[root@rac1 app]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
Enjoy new clusterware version 11.2.0.4 :)

********************************************************************************

DATABASE SOFTWARE UPGRADE

Now Upgrade the database version

Create a new oracle home for database

using gui

cd database
runInstaller

follow on screen instructions

install database software only

run root scripts.

This completes installation of oracle db software.

**************************************************************************

Existing DB Upgrade

Now upgrade existing db

Go to 11.2.0.4 oracle home/bin

Run dbua

Follow instructions.


After completion

Verify by

select banner from v$version;

Enjoy :)