askMLabs

In this article, i am going to show you the simplest way to upgrade a 11202 RAC to 12c cluster. I am using runInstaller for both grid infrastructure and oracle home upgrade. I am writing other articles for RAC upgrade to give you detailed understanding of the upgrade process of RAC. This is the simplest and easiest method to upgrade rac and most of the tasks in this process are automated.

Present environment where i am upgrading rac is a three node rac cluster with 11202 installed and configured.



1. Record Status Before Upgrade :

[root@askmrac1 ~]# /u01/app/11.2.0/grid/bin/crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.2.0]
[root@askmrac1 ~]# /u01/app/11.2.0/grid/bin/crsctl query crs softwareversion
Oracle Clusterware version on node [askmrac1] is [11.2.0.2.0]
[root@askmrac1 ~]# /u01/app/11.2.0/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2784
         Available space (kbytes) :     259336
         ID                       : 2080220530
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check succeeded
[root@askmrac1 ~]# /u01/app/11.2.0/grid/bin/crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   a6aeac6ed4274f91bfe7e12d4592e4f0 (/dev/xvdc1) [OCR_VOTE]
Located 1 voting disk(s).
[root@askmrac1 ~]#

2. Download and Unzip the 12c database software.
I have downloaded and unzipped 12c database to the location /mnt/software/RAC/db12101.

3. Verify the nodes are ready for upgrading using the following command. You will find runcluvfy.sh script in the extracted software location  /mnt/software/RAC/db12101/grid.

runcluvfy.sh stage -pre crsinst -upgrade -n askmrac1,askmrac2,askmrac3 -rolling -src_crshome /u01/app/11.2.0/grid -dest_crshome /u01/app/12.1.0/grid -dest_version 12.1.0.1.0 -fixup -verbose

[grid@askmrac1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n askmrac1,askmrac2,askmrac3 -rolling -src_crshome /u01/app/11.2.0/grid -dest_crshome /u01/app/12.1.0/grid -dest_version 12.1.0.1.0 -fixup -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
..
..
Execute "/tmp/CVU_12.1.0.1.0_grid/runfixup.sh" as root user on nodes "askmrac3,askmrac2,askmrac1" to perform the fix up operations manually
Press ENTER key to continue after execution of "/tmp/CVU_12.1.0.1.0_grid/runfixup.sh" has completed on nodes "askmrac3,askmrac2,askmrac1"

Fix: Group Membership: dba
  Node Name                             Status
  ------------------------------------  ------------------------
  askmrac3                              successful
  askmrac2                              successful
  askmrac1                              successful
Result: "Group Membership: dba" was successfully fixed on all the applicable nodes
Fix up operations were successfully completed on all the applicable nodes
Pre-check for cluster services setup was unsuccessful on all the nodes.
[grid@askmrac1 grid]$

[root@askmrac3 ~]# /tmp/CVU_12.1.0.1.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@askmrac3 ~]#
[root@askmrac2 ~]# /tmp/CVU_12.1.0.1.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@askmrac2 ~]#
[root@askmrac1 ~]# /tmp/CVU_12.1.0.1.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@askmrac1 ~]#

4. Start runInstaller from grid software directory and follow the screen shots.



















5. Start runInstaller from oracle software directory and follow the screen shots.
Create new OS groups required for database 12c

[root@askmrac1 app]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1031(dba),1021(asmdba) context=root:system_r:unconfined_t:s0-s0:c0.c1023
[root@askmrac1 app]# groupadd backupdba
[root@askmrac1 app]# groupadd dgdba
[root@askmrac1 app]# groupadd kmdba
[root@askmrac1 app]# usermod -g oinstall -G dba,oper,asmdba,backupdba,dgdba,kmdba oracle
[root@askmrac1 app]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1031(dba),1032(oper),1021(asmdba),1033(backupdba),1034(dgdba),1035(kmdba) context=root:system_r:unconfined_t:s0-s0:c0.c1023
[root@askmrac1 app]# ssh 192.168.1.232
root@192.168.1.232's password:
Permission denied, please try again.
root@192.168.1.232's password:
Last login: Thu Mar  6 01:22:17 2014 from askmrac1.localdomain
[root@askmrac2 ~]# groupadd backupdba
[root@askmrac2 ~]# groupadd dgdba
[root@askmrac2 ~]# groupadd kmdba
[root@askmrac2 ~]# usermod -g oinstall -G dba,oper,asmdba,backupdba,dgdba,kmdba oracle
[root@askmrac2 ~]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1031(dba),1032(oper),1021(asmdba),1033(backupdba),1034(dgdba),1035(kmdba) context=root:system_r:unconfined_t:s0-s0:c0.c1023
[root@askmrac2 ~]# exit
logout
Connection to 192.168.1.232 closed.
[root@askmrac1 app]# ssh 192.168.1.233
root@192.168.1.233's password:
Last login: Thu Mar  6 01:22:41 2014 from askmrac1.localdomain
[root@askmrac3 ~]# groupadd backupdba
[root@askmrac3 ~]# groupadd dgdba
[root@askmrac3 ~]# groupadd kmdba
[root@askmrac3 ~]# usermod -g oinstall -G dba,oper,asmdba,backupdba,dgdba,kmdba oracle
[root@askmrac3 ~]# id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1031(dba),1032(oper),1021(asmdba),1033(backupdba),1034(dgdba),1035(kmdba) context=root:system_r:unconfined_t:s0-s0:c0.c1023
[root@askmrac3 ~]#

6. Verify the upgrade.

7. Issues :

8. Logfile Location: