applying patch 9413827 before upgrading crs to 11.2.0.3.0

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也是以简洁为主，附表为辅助性过程带有注释！