11.2 rac psu 补丁

   最近去客户打11.2rac psu p25476126_112040_Linux-x86-64，2017年4月18号发布的pus补丁

1、opatch下载及安装

   由于数据库本身自带的opatch版本为11.2.0.3.4,但是打p25476126_112040_Linux-x86-64需要11.2.0.3.6以后的，因此下载最新的opatch p6880880_112000_Linux-x86-64

  分别传输到grid_home 和oracle_home下面

备份原来的OPatch，然后解压 p6880880_112000_Linux-x86-64

 su - grid

$cd $ORACLE_HOME

$mv OPatch OPatch.old

$unzip p6880880_112000_Linux-x86-64

su - oracle

$cd $ORACLE_HOME

$mv OPatch OPatch.old

$unzip  p6880880_112000_Linux-x86-64

2、使用grid用户解压psu安装文件

cd /oraclelog/oracle_soft
unzip  p25476126_112040_Linux-x86-64

3、 生成OCM文件
su - grid
$cd $ORACLE_HOME/OPatch/ocm/bin

$./emocmrsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if  you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:


You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
The OCM configuration response file (/oracle/ocm.rsp) was successfully created.

把ocm.rsp文件拷贝到grid用户能读写的目录

cp ocm.rsp /tmp

3、 安装11.2.0.4.2 grid PSU
su - root
/oracle/app/11.2.0/grid/OPatch/opatch auto  /oraclelog/oracle_soft/25476126 -oh  /oracle/11.2/grid -ocmrf /tmp/ocm.rsp
4、生成oracle用户ocm.rsp文件

   可以使用一个，我也尝试了，一定要注意，生成的ocm.rsp文件 gird用户和oracle用户都要有权限读取，我最初只有grid用户能读取，结果升级oracle失败，因此，我还是grid和oracle分别升级了

su - oracle
$cd $ORACLE_HOME/OPatch/ocm/bin

$./emocmrsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if  you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:


You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
The OCM configuration response file (/oracle/ocm.rsp) was successfully created.

拷贝分文到oracle能读取的位置，可以直接放在源位置

cp ocm.rsp /oracle

升级oracle软件

su - root
/oracle/app/oracle/product/11.2/db/OPatch/opatch auto  /oraclelog/oracle_soft/25476126 -oh /oracle/app/oracle/product/11.2/db  -ocmrf /oracle/ocm.rsp

5.升级数据字典

SQL> @?/rdbms/admin/catbundle.sql psu apply