oracle 11g psu升级,ORACLE RAC 11Gr2 升级PSU 从11.2.0.3.0到11.2.0.3.8

11.2.0.3RAC 打PSU 11.2.0.3

软件包

PSU包p1*******_112030_Linux-x86-64.zip

此包包含GI和DATABASE的PSU

安装前准备

1、opatch should be 11.2.0.3.4 or later.

两个节点grid和oracle的版本都要最新

[grid@rac1 OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.12

2、生成ocm.rsp

两个节点都要执行

login as oracle

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner -output /home/oracle/ocm.rsp

3、Validation of Oracle Inventory

$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh

4、Stop EM Agent Processes Prior to Patching and Prior to Rolling Back the Patch

$ $ORACLE_HOME/bin/emctl stop dbconsole

安装

1、自动安装

login as root

安装前注意ORACLE_HOME的所属组不可以为root

opatch auto -ocmrf

节点1：

[root@rac1 OPatch]# /u01/app/grid/OPatch/opatch auto /opt/soft/11g/gi_psu_11.2.0.3.8 -ocmrf /home/oracle/ocm.rsp

Can't locate Switch.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /u01/app/grid/OPatch/crs/auto_patch.pl line 2734.

BEGIN failed--compilation aborted at /u01/app/grid/OPatch/crs/auto_patch.pl line 2734.

报错是因为少包，安装perl-Switch包

perl-Switch-2.16-7.el7.noarch.rpm

[root@rac1 ~]# /u01/app/grid/OPatch/opatch auto /opt/soft/11g/gi_psu_11.2.0.3.8 -ocmrf /home/oracle/ocm.rsp

Executing /u01/app/grid/perl/bin/perl /u01/app/grid/OPatch/crs/patch11203.pl -patchdir