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，开始升级

software location 选择新版本所在的目录：

两个节点分别使用root用户执行脚本：/u01/app/11.2.0.4/grid/rootupgrade.sh


节点1：
[root@zmkj1 ~]# /u01/app/11.2.0.4/grid/rootupgrade.sh
Performing root user operation for Oracle 11g 
 
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0.4/grid
 
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
 
 
ASM upgrade has started on first node.
 
 
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zmkj1'
CRS-2673: Attempting to stop 'ora.crsd' on 'zmkj1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'zmkj1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.zmkj.db' on 'zmkj1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.zmkj1.vip' on 'zmkj1'
CRS-2677: Stop of 'ora.zmkj1.vip' on 'zmkj1' succeeded
CRS-2672: Attempting to start 'ora.zmkj1.vip' on 'zmkj2'
CRS-2676: Start of 'ora.zmkj1.vip' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.zmkj.db' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'zmkj1'
CRS-2677: Stop of 'ora.DATADG.dg' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zmkj1'
CRS-2677: Stop of 'ora.asm' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.eons' on 'zmkj1'
CRS-2677: Stop of 'ora.ons' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'zmkj1'
CRS-2677: Stop of 'ora.net1.network' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.eons' on 'zmkj1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'zmkj1' has completed
CRS-2677: Stop of 'ora.crsd' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.evmd' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.asm' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'zmkj1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.asm' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zmkj1'
CRS-2677: Stop of 'ora.cssd' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'zmkj1'
CRS-2673: Attempting to stop 'ora.diskmon' on 'zmkj1'
CRS-2677: Stop of 'ora.gpnpd' on 'zmkj1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'zmkj1'
CRS-2677: Stop of 'ora.gipcd' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.diskmon' on 'zmkj1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zmkj1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
 
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@zmkj1 ~]# 
 
 
 
节点2：
[root@zmkj2 ~]# /u01/app/11.2.0.4/grid/rootupgrade.sh
Performing root user operation for Oracle 11g 
 
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0.4/grid
 
Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: y
   Copying coraenv to /usr/local/bin ...
 
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zmkj2'
CRS-2673: Attempting to stop 'ora.crsd' on 'zmkj2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'zmkj2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.zmkj.db' on 'zmkj2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'zmkj2'
CRS-2677: Stop of 'ora.scan1.vip' on 'zmkj2' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'zmkj1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.zmkj2.vip' on 'zmkj2'
CRS-2677: Stop of 'ora.zmkj2.vip' on 'zmkj2' succeeded
CRS-2672: Attempting to start 'ora.zmkj2.vip' on 'zmkj1'
CRS-2676: Start of 'ora.scan1.vip' on 'zmkj1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'zmkj1'
CRS-2676: Start of 'ora.zmkj2.vip' on 'zmkj1' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'zmkj1' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.zmkj.db' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'zmkj2'
CRS-2677: Stop of 'ora.DATADG.dg' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'zmkj2'
CRS-2677: Stop of 'ora.asm' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.eons' on 'zmkj2'
CRS-2677: Stop of 'ora.ons' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'zmkj2'
CRS-2677: Stop of 'ora.net1.network' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.eons' on 'zmkj2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'zmkj2' has completed
CRS-2677: Stop of 'ora.crsd' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.evmd' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.asm' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'zmkj2'
CRS-2677: Stop of 'ora.cssdmonitor' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.asm' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'zmkj2'
CRS-2677: Stop of 'ora.cssd' on 'zmkj2' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'zmkj2'
CRS-2673: Attempting to stop 'ora.gipcd' on 'zmkj2'
CRS-2677: Stop of 'ora.diskmon' on 'zmkj2' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'zmkj2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'zmkj2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in inittab
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. This operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Successfully upgraded the Oracle Clusterware.
Oracle Clusterware operating version was successfully set to 11.2.0.4.0
 
ASM upgrade has finished on last node.
 
 
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@zmkj2 ~]#

grid升级完成。

升级完成后检查grid的版本：


[grid@zmkj2 ~]$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[root@zmkj2 ~]# crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[root@zmkj2 ~]# crsctl query crs softwareversion
Oracle Clusterware version on node [zmkj2] is [11.2.0.4.0]
[grid@zmkj2 ~]$

2、升级rdbms


[oracle@zmkj1 database]$ unset ORACLE_SID
[oracle@zmkj1 database]$ unset ORACLE_BASE
[oracle@zmkj1 database]$ unset ORACLE_HOME
 
[oracle@zmkj1 database]$ ./runInstaller 
Starting Oracle Universal Installer...
 
Checking Temp space: must be greater than 120 MB.   Actual 3736 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 12266 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-11-01_02-09-00PM. Please wait ...[oracle@zmkj1 database]$ 
 
[root@zmkj1 ~]#