如何升级ORACLE GI 12.1.0.1到12.1.0.2
原GI版本是12.1.0.1,安装目录为/u01/12.1.0.2/crs,现计划升级GI到12.1.0.2,目录为/u02/12.1.0.2/crs.
先停止数据库相关资源,但是不需要停GI
检查版本信息
[root@rac1 grid]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.1.0]
安装前检查
[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -src_crshome /u01/12.1.0.2/crs -dest_crshome /u02/12.1.0.2/crs -dest_version 12.1.0.2.0 -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "rac1"
Destination Node Reachable?
------------------------------------ ------------------------
rac1 yes
rac2 yes
Result: Node reachability check passed from node "rac1"
Checking user equivalence...
...............................................
输出长长的一串
升级过程中保证所有节点都在线,CRS的所有服务都不能停
[root@rac1 grid]# crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
在真正升级之前,需要消除GRID的ORACLE_HOME,ORACLE_BASE,两个节点都需要执行
[grid@rac1 grid]$ unset ORACLE_HOME
[grid@rac1 grid]$ unset ORACLE_BASE
运行安装程序,选择upgrade GI, 后续都是体力活
[grid@rac1 grid]$ ./runInstaller
根据安装提示在两个节点分别执行
[root@rac1 grid]# /u02/12.1.0.2/crs/rootupgrade.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
.........................................
当第一个节点跑rootupgrade.sh脚本后,软件版本情况,软件已经更新,不过活动版本没有更新.
[root@rac1 grid]# crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [12.1.0.2.0]
[root@rac1 grid]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.1.0]
第二个节点执行rootupgrade.sh后会执行活动版本更新
.......................................
Successfully taken the backup of node specific configuration in OCR.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2016/05/20 17:01:14 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2016/05/20 17:01:14 CLSRSC-482: Running command: '/u02/12.1.0.2/crs/bin/crsctl set crs activeversion'
........................................
等待脚本完成后,可以看出活动版本已经到最新版本了.
[root@rac1 grid]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.2.0]
[root@rac1 grid]# crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [12.1.0.2.0]
重新设置所有节点的GRID的ORACLE_HOME,ORACLE_BASE到新路径下,至此升级GI完成.
[root@rac1 grid]# crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************