Oracle 11.2.0.1 rac升级到11.2.0.4

升级过程分为三部分：

1、升级grid

2、升级rdbms

3、升级数据字典

前期准备：

新建grid_home和oracle_home

	升级前	升级后
版本	11.2.0.1	11.2.0.4
grid_base	/u01/app/grid	/u01/app/grid
grid_home	/u01/app/11.2.0/grid	/u01/app/11.2.0.4/grid
oracle_base	/u01/app/oracle	/u01/app/oracle
oracle_home	/u01/app/oracle/product/11.2.0/db_1	/u01/app/oracle/product/11.2.0.4/db_1

2、升级前检查：

./runcluvfy.sh stage -pre crsinst -upgrade -n zmkj1,zmkj2 -rolling -src_crshome /u01/app/11.2.0/grid -dest_crshome /u01/app/11.2.0.4/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /tmp -verbose

根据检查结果需要升级cuvqdisk、安装补丁9413827 或 9706490

Checking for Oracle patch "9413827 or 9706490" in home "/u01/app/11.2.0/grid".
  Node Name     Applied                   Required                  Comment   
  ------------  ------------------------  ------------------------  ----------
  zmkj2         missing                   9413827 or 9706490        failed    
  zmkj1         missing                   9413827 or 9706490        failed    
Result: Check for Oracle patch "9413827 or 9706490" in home "/u01/app/11.2.0/grid" failed

Check: Package existence for "cvuqdisk" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  zmkj2         cvuqdisk-1.0.7-1          cvuqdisk-1.0.9-1          failed    
  zmkj1         cvuqdisk-1.0.7-1          cvuqdisk-1.0.9-1          failed    
Result: Package existence check failed for "cvuqdisk"

根据提示在两个节点都执行/tmp/CVU_11.2.0.4.0_grid/runfixup.sh，进行配置：

Fixup information has been generated for following node(s):
zmkj2,zmkj1
Please run the following script on each node as "root" user to execute the fixups:
'/tmp/CVU_11.2.0.4.0_grid/runfixup.sh'

Pre-check for cluster services setup was unsuccessful on all the nodes. 

执行结果如下：

[root@zmkj1 ~]# /tmp/CVU_11.2.0.4.0_grid/runfixup.sh
Response file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.4.0_grid/fixup.enable
Log file location: /tmp/CVU_11.2.0.4.0_grid/orarun.log
Installing Package /tmp/CVU_11.2.0.4.0_grid//cvuqdisk-1.0.9-1.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:cvuqdisk-1.0.9-1                 ################################# [ 50%]
Cleaning up / removing...
   2:cvuqdisk-1.0.7-1                 ################################# [100%]
[root@zmkj1 ~]# 

Oracle补丁9413827 或 9706490需要手工进行安装，在两个几点都需要打补丁，打补丁的方法可以参考 9413827 或 9706490安装。

3、升级grid

将安装包p13390677_112040_Linux-x86-64_3of7.zip解压，使用grid用户进行升级

[grid@zmkj1 grid]$ cd /tmp
[grid@zmkj1 grid]$ unzip p13390677_112040_Linux-x86-64_3of7.zip
[grid@zmkj1 grid]$ cd /tmp/grid
[grid@zmkj1 grid]$ unset ORACLE_SID
[grid@zmkj1 grid]$ unset ORACLE_BASE
[grid@zmkj1 grid]$ unset ORACLE_HOME

export DISPLAY=192.168.10.143:0.0，执行runInstaller，开始升级