applying patch 9413827 before upgradingcrs to 11.2.0.3.0
环境:oracle 11.2.0.1 rac on redhat 5.8
11.2.0.1 RAC升级GI可以不停DB,直接升级GI;一个实例一个实例升级GI,使用保持有一个实例被DG使用
1、check patch 9413827、opatch version
su - grid
$CRS_HOME/OPatch/opatch lsinventory
su - oracle
$ORACLE_HOME/OPatch/opatch lsinventory
su - grid
$CRS_HOME/OPatch/opatch version
su - oracle
$ORACLE_HOME/OPatch/opatch version
2、installation p6880880_112000_LINUX.zip, upgrade opatch version(to 11.2.0.3.4 from 11.1.0.6.6)
su - root
cd $CRS_HOME
mv OPatch/ OPatch_bk
unzip p6880880_112000_LINUX.zip -d $CRS_HOME
chown grid:oinstall OPatch -R
$CRS_HOME/OPatch/opatch version
3、installation p9413827_112010_LINUX.zip (需要停止升级GI节点上的实例)
su–root
unzip p9413827_112010_LINUX.zip -d $CRS_HOME
chown grid:oinstall 9413827 -R
su–oracle
sh /u01/app/11.2.0/grid/9413827/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
su–root
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
su–grid
first applying patch for grid;
cd $CRS_HOME
$CRS_HOME/OPatch/opatch napply -local -oh /u01/app/11.2.0/grid -id 9413827
$CRS_HOME/OPatch/opatch lsinventory
the for database;
su - oracle
$ORACLE_HOME/OPatch/opatch napply /u01/app/11.2.0/grid/9413827/custom/server/ -local -oh $ORACLE_HOME -id 9413827
$ORACLE_HOME/OPatch/opatch lsinventory
su – root
chmod +w /u01/app/11.2.0/grid/log/dou_rac1/agent/
chmod +w /u01/app/11.2.0/grid/log/dou_rac1/agent/crsd/
su–oracle
sh /u01/app/11.2.0/grid/9413827/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
su–root
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
same setups of others node;
GI and Oracle software patch succeed !
附表
检查当前GI是否安装patch
[grid@dou_rac2 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
-------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Grid Infrastructure 11.2.0.1.0
此 Oracle 主目录中已安装 1 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
包含多个节点的 RAC 系统
Local node =dou_rac2
Remote node =dou_rac1
------------------------------------------------------------------------------
OPatch succeeded.
1、检查当前opatch version
[grid@dou_rac2 ~]$$ORACLE_HOME/OPatch/opatchversion
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
[oracle@dou_rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
2、安装p9413827_112010_LINUX.zip之前,需先安装p6880880_112000_LINUX.zip
使用grid用户解压p6880880_112000_LINUX.zip到$ORACLE_HOME目录
su - grid
cd $ORACLE_HOME
mv OPatch/ OPatch_bk
unzip /opt/opatch/p6880880_112000_LINUX.zip -d$ORACLE_HOME
检验新的optach
$ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4 --new opatch is applyed
OPatch succeeded.
[oracle@dou_rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
Invoking OPatch 11.1.0.6.6
OPatch Version: 11.1.0.6.6
OPatch succeeded.
3、安装补丁p9413827_112010_LINUX.zip
su –grid
unzip p9413827_112010_LINUX.zip -d $ORACLE_HOME
su–oracle
sh/u01/app/11.2.0/grid/9413827/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
su –grid
First applying patch for grid;
su –root
/u01/app/11.2.0/grid/crs/install/rootcrs.pl-unlock
cd $CRS_HOME
$CRS_HOME/OPatch/opatch napply -local -oh /u01/app/11.2.0/grid -id 9413827
$CRS_HOME/OPatch/opatch lsinventory
Bugs fixed:
9413827, 9706490 --GI补丁成功
the for database
su - oracle
$ORACLE_HOME/OPatch/opatch napply/u01/app/11.2.0/grid/9413827/custom/server/ -local -oh $ORACLE_HOME -id 9413827
$ORACLE_HOME/OPatch/opatch lsinventory
Bugs fixed:
9413827, 9706490 --Opatch成功
chmod +w /u01/app/11.2.0/grid/log/dou_rac1/agent/
chmod +w /u01/app/11.2.0/grid/log/dou_rac1/agent/crsd/
su –oracle
sh/u01/app/11.2.0/grid/9413827/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
su –root
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
总结:
希望我的BLOG也是以简洁为主,附表为辅助性过程带有注释!