Oracle Rac11.2.0.1升级11.2.0.4
本文连接：http://www.noobyard.com/article/p-zaldkrtb-m.htmlcss
rac11.2.0.1升级至11.2.0.4须要p13390677_112040_Linux-x86-64_1of7.zip、p13390677_112040_Linux-x86-64_2of7.zip、p13390677_112040_Linux-x86-64_3of7.zip这3个安装包(一、2是oracle安装包，3是grid安装包)node
| 节点1bash |
节点2网络 |
|
| 主机名oracle |
wlrac01app |
wlrac02测试 |
| SIDui |
wlracdb1spa |
wlracdb2 |
| DB_NAME |
wlracdb |
|
| RAC当前版本 |
11.2.0.1 |
|
| 操做系统 |
Red Hat Enterprise Linux Server release 6.8 (Santiago) |
|
| ORACLE_HOME |
/u01/app/oracle/product/11.2.0/db_1 |
|
| GRID_HOME |
/u01/app/11.2.0/grid |
tar zcvf ora11.tar.gz /u01/app
[root@wlrac01 ~]# mkdir -p /u01/app/oracle/product/11.2.0.4/db_1
[root@wlrac01 ~]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0.4
[root@wlrac01 ~]# mkdir -p /u01/app/11.2.0.4/grid
[root@wlrac01 ~]# chown -R grid:oinstall /u01/app/11.2.0.4
[grid@wlrac01 grid]$ ./runcluvfy.sh stage -pre crsinst -upgrade -n wlrac01,wlrac02 -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
命令输出：
....省略
正在检查 Oracle 集群表决磁盘配置…
“ASM 运行”检查经过。ASM 正在全部指定节点上运行
Oracle 集群表决磁盘配置检查已经过
集群件版本一致性测试已经过
attention:其中最可能报错的地方是缺乏9413827或9706490补丁程序，安装其中一个就可，附上安装9413827补丁程序连接http://www.noobyard.com/article/p-hdolrhlu-bk.html
打完补丁后，在从新执行预检测命令，经过后就能够执行安装程序了。
3. Grid Infrastructure升级(在一个节点执行就行，会自动拷贝到其余节点)
将p13390677_112040_Linux-x86-64_3of7.zip解压到gird用户家目录
[root@wlrac01 ~]# su - grid
[grid@wlrac01 ~]$ unset ORACLE_HOME
[grid@wlrac01 ~]$ unset ORACLE_BASE
[grid@wlrac01 ~]$ unset ORACLE_SID
[grid@wlrac01 ~]$ export LANG=en_US
[grid@wlrac01 ~]$ cd grid
[grid@wlrac01 grid]$ ./runInstaller
attention:因为文章是升级完后整理的，因此图片是后来找的，图片里边的一些内容可能不对，你们参照本身原有环境配置
3.2 选择“升级Oracle Grid Infrastructure或Oracle自动存储管理”
3.6 制定新gird软件安装位置，参考上边新建目录(/u01/app/11.2.0.4/grid)
3.7 再次进行检查，如一些没必要要的检查报错能够选择ignore(例如缺乏i386包等)
执行到最后一步，按照提示在全部节点依次执行脚本
[root@wlrac01 src]# cd /u01/app/11.2.0.4/grid/
[root@wlrac01 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)
Copying oraenv to /usr/local/bin …
The file “coraenv” already exists in /usr/local/bin. Overwrite it? (y/n)
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 升级已在第一个节点上开始。
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘wlrac01’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.CRS.dg’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.FRA.dg’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.wlrac01.vip’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.wlrac01.vip’ on ‘wlrac01’ succeeded
CRS-2672: Attempting to start ‘ora.wlrac01.vip’ on ‘wlrac02’
CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.scan1.vip’ on ‘wlrac01’ succeeded
CRS-2672: Attempting to start ‘ora.scan1.vip’ on ‘wlrac02’
CRS-2676: Start of ‘ora.scan1.vip’ on ‘wlrac02’ succeeded
CRS-2672: Attempting to start ‘ora.LISTENER_SCAN1.lsnr’ on ‘wlrac02’
CRS-2676: Start of ‘ora.wlrac01.vip’ on ‘wlrac02’ succeeded
CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ‘wlrac02’ succeeded
CRS-2677: Stop of ‘ora.CRS.dg’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.DATA.dg’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.FRA.dg’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.asm’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.asm’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.eons’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.ons’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.ons’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.net1.network’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.net1.network’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.eons’ on ‘wlrac01’ succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘wlrac01’ has completed
CRS-2677: Stop of ‘ora.crsd’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.cssdmonitor’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.ctssd’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.evmd’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.asm’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.cssdmonitor’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.gpnpd’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.evmd’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.mdnsd’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.ctssd’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.asm’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.cssd’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.cssd’ on ‘wlrac01’ succeeded
CRS-2673: Attempting to stop ‘ora.diskmon’ on ‘wlrac01’
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘wlrac01’
CRS-2677: Stop of ‘ora.gipcd’ on ‘wlrac01’ succeeded
CRS-2677: Stop of ‘ora.diskmon’ on ‘wlrac01’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘wlrac01’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
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
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 升级已在最后一个节点上完成。
Configure Oracle Grid Infrastructure for a Cluster … succeeded
3.9 修改全部节点grid用户的bash_profile文件，将ORACLE_HOME改成ORACLE_HOME=/u01/app/11.2.0.4/grid
[grid@wlrac01 ~]$ source .bash_profile
[root@wlrac01 ~]# cd /u01/app/11.2.0.4/grid/bin/
[root@wlrac01 bin]# ./crsctl stop cluster -all
[root@wlrac01 bin]# ./crsctl start cluster -all
[root@wlrac01 bin]# ./crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.4.0]
[root@wlrac01 bin]# ./crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.4.0]
[root@wlrac01 bin]# ./crsctl query crs softwareversion
Oracle Clusterware version on node [wlrac01] is [11.2.0.4.0]
将p13390677_112040_Linux-x86-64_1of7.zip、p13390677_112040_Linux-x86-64_2of7.zip解压到oracle用户家目录
[root@wlrac01 bin]# su - oracle
[oracle@wlrac01 ~]$ unset ORACLE_HOME
[oracle@wlrac01 ~]$ unset ORACLE_BASE
[oracle@wlrac01 ~]$ unset ORACLE_SID
[oracle@wlrac01 ~]$ export LANG=en_US
[oracle@wlrac01 ~]$ cd database
[oracle@wlrac01 database]$ ./runInstaller
运行runInstaller进行升级，在出现“指定住目录详细信息”窗口，选择新ORACLE_HOME(/u01/app/oracle/product/11.2.0.4/db_1)，其它都点下一步
升级完数据库软件后，会自动弹出数据库升级窗口（若是没有，可使用dbua进行升级）
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
COMP_NAME VERSION STATUS
OWB 11.2.0.1.0 VALID
Oracle Application Express 3.2.1.00.10 VALID
Oracle Enterprise Manager 11.2.0.4.0 VALID
OLAP Catalog 11.2.0.4.0 VALID
Spatial 11.2.0.4.0 VALID
Oracle Multimedia 11.2.0.4.0 VALID
Oracle XML Database 11.2.0.4.0 VALID
Oracle Text 11.2.0.4.0 VALID
Oracle Expression Filter 11.2.0.4.0 VALID
Oracle Rules Manager 11.2.0.4.0 VALID
Oracle Workspace Manager 11.2.0.4.0 VALID
Oracle Database Catalog Views 11.2.0.4.0 VALID
Oracle Database Packages and Types 11.2.0.4.0 VALID
JServer JAVA Virtual Machine 11.2.0.4.0 VALID
Oracle XDK 11.2.0.4.0 VALID
Oracle Database Java Packages 11.2.0.4.0 VALID
OLAP Analytic Workspace 11.2.0.4.0 VALID
Oracle OLAP API 11.2.0.4.0 VALID
Oracle Real Application Clusters 11.2.0.4.0 VALID
19 rows selected.
SQL> select * from v$version;
BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production