环境:
OS:Oracle Enterprise Linux 5.7 x86_64
Grid Infrastructure:11.2.0.2.0
Oracle Database:11.2.0.2.0
Oracle RAC:Two-nodes.
MOS下载补丁程序Patch:14192201
This GridInfrastructure Patch Set Update includes:
- The 11.2.0.2.7 Database Patch Set Update(see bug 13923804)
- Plus all fixes which are included in theCritical Patch Update for
July 2012 (CPUJul2012) - for details seeNote:1455387.1
- Plus a number of other fixes related to GridInfrastructure
including all fixed from the 11.2.0.2.6 GIPSU (Bug 13696242)
执行步骤:
1.安装opatch 11.2.0.3.0 ,opatch需要11.2.0.3或以上的版本才可以应用此PSU。
grid用户
$unzip /u01/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
oracle用户
$unzip /u01/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
2.解压GI PSU
切换至/u01目录
$unzip p14192201_112020_Linux-x86-64.zip
解压出来13696242、1392384两个目录,以及bundle.xml、README文件(grid和oracle用户必须对以上目录具有可读权限)。
3.创建OCM (Oracle Configuration Manager) response file
grid用户执行
$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp,在工作目录下面生成,并确保该文件可被oracle用户读取。
4.该PSU包含Database PSU,GI HOME和Oracle RAC HOME可以一起应用此Patch
root用户执行,集群可以关闭也可以不关闭,应用补丁完成集群会自动启动。
#/u01/11.2.0/grid/Opatch/opatch auto /u01 -ocmrf /u01/ocm.rsp
5.执行catbundle.sql
oracle用户
$cd $ORACLE_HOME/rdbms/admin
$sqlplus '/as sysdba'
SQL>@catbundle.sql psu apply
6.查询应用情况
grid用户
[grid@racdb1~]$ /u01/11.2.0/grid/OPatch/opatch lsinventory|grep -i "PATCH SETUPDATE"
Patchdescription: "Database Patch SetUpdate : 11.2.0.2.7 (13923804)"
Sub-patch 13696224; "Database Patch Set Update :11.2.0.2.6 (13696224)"
Patchdescription: "Grid InfrastructurePatch Set Update : 11.2.0.2.6 (13696242)"
oracle用户
[oracle@racdb1~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory|grep -i "PATCH SET UPDATE"
Patchdescription: "Database Patch SetUpdate : 11.2.0.2.7 (13923804)"
Sub-patch 13696224; "Database Patch Set Update :11.2.0.2.6 (13696224)"
Patchdescription: "Grid InfrastructurePatch Set Update : 11.2.0.2.6 (13696242)"