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 ~]#
选择upgrade and existing database:
选择新的安装目录:
两节点分别执行root.sh。
3、升级数据字典
在节点1执行,shutdown节点2
升级完成