RAC rolling upgrade 11.2.0.3 to 11.2.0.4

Using GUI :   RAC rolling upgrade 11.2.0.3 to 11.2.0.4

GRID upgrade :

Patchset first 3 zip files may contain required files to upgrade our grid and database.
unzip under /oracle/patch/grid
unzip under /oracle/patch/database

1. Install the software in temp directory : /oracle/patch/grid

2. Pre-check the upgrade process :
     set ORACLE_TERM=xterm    and  unset ORACLE_BASE , ORACLE_HOME ,     ORACLE_HOSTNAME , ORACLE_SID , ORACLE_UNQNAME

    $ /oracle/patch/grid/runcluvfy.sh stage -pre crsinst -upgrade
                                        -n bedc-odb01,bedc-odb02 -rolling
                                        -src_crshome /oracle/grid
                                        -dest_crshome /oracle/11.2.0.4/grid/
                                        -dest_version  11.2.0.4.0
                                        -fixup
                                        -fixupdir /home/oracle/fixup
                                        -verbose

3. Execute runInstaller

oracle:> /oracle/patch/grid/runInstaller.sh
Skip Software updates.
Select Upgrade Oracle grid or ASM option
Select all node where cluster upgrade needs to be performed
dba:oinstall:oinstall
Software Location: /oracle/11.2.0.4/grid
....
....
....
Run “rootupgrade.sh” on all the nodes.
First node :  /oracle/11.2.0.4/grid/rootupgrade.sh   ASM Node 1 goes down for update...
Second Node :  /oracle/11.2.0.4/grid/rootupgrade.sh   ASM Node 2 goes down for update....
Done.


Verification Check :

sqlplus / as sysasm  ; SQL> select * from v$version;
/oracle/11.2.0.4/grid/bin/crsctl query crs activeversion
[root@ ~]# /oracle/11.2.0.4/grid/bin/crsctl stat res -t




Database Upgrade :
Use shared memory (temporary 10G ) instead of HugePages

oracle:> /oracle/patch/database/runInstaller
skip software update
  select Upgrade an existing database.
Oracle RAC installation and select all nodes
Give Oracle Base : /oracle/11.2.0.4/base
 Software Location : /oracle/11.2.0.4/base/db/dbhome_1
dba:oinstall
.....
.....
Run $OH/root.sh on all nodes
First node :  /oracle/11.2.0.4/base/db/dbhome_1/root.sh
Second node :  /oracle/11.2.0.4/base/db/dbhome_1/root.sh

Press Finish--> Pre upgrd ---> Oracle Server --> JVM --> XDK --> RAC

Done.


Verification Check :

SQL >select * from gv$version;


Post DB Upgrade :

set ORACLE_HOME and PATH  to new OH

Check /Alter  : cluster=true , c/u/b_dump_dest ,spfile and /etc/oratab  and ADR_BASE = $OB

Also check :
alter system set background_dump_dest='/oracle/11_4/base/diag/asm/+asm/+ASM1/trace' scope=spfile;
alter system set core_dump_dest='/oracle/11_4/base/diag/asm/+asm/+ASM1/cdump' scope=spfile;
alter system set diagnostic_dest='/oracle/11_4/base' scope=spfile;
alter system set user_dump_dest='/oracle/base/diag/asm/+asm/+ASM1/trace' scope=spfile;

cp ab_+ASM1.dat hc_+ASM1.dat /oracle/11_4/base/db_1/dbs/
cp ab_+ASM1.dat hc_+ASM1.dat /oracle/grid_11_4/dbs/













NOTE : https://gemsofprogramming.wordpress.com/2014/12/02/upgrade-oracle-rac-grid-database-from-11-2-0-3-0-to-11-2-0-4-0-or-lets-run-the-gauntlet/