如何升级ORACLE GI 12.1.0.1到12.1.0.2

3440阅读 0评论2016-05-20 oracle狂热分子
分类:Oracle

                              如何升级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
**************************************************************


上一篇: ORACLE 12C DataGuard最大保护模式不需要终止主库
下一篇:使用Oracle Dataguard实现从单机到RAC转换