ORACLE RAC 11Gr2 升级PSU 从11.2.0.3.0到11.2.0.3.8

11.2.0.3RAC 打PSU 11.2.0.3

软件包

PSU包p17272731_112030_Linux-x86-64.zip 此包包含GI和DATABASE的PSU

安装前准备

1、opatchshould 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包

[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

perl-Switch-2.16-7.el7.noarch.rpm/opt/soft/11g -patchn gi_psu_11.2.0.3.8 -ocmrf /home/oracle/ocm.rsp -paramfile /u01/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/cfgtoollogs/opatchauto2016-10-15_19-49-07.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/grid/cfgtoollogs/opatchauto2016-10-15_19-49-07.report.log

2016-10-15 19:49:07: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params

Unable to determine if /u01/app/oracle/product/11.2.0.3/db1 is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Unable to determine if /u01/app/grid is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Stopping RAC /u01/app/oracle/product/11.2.0.3/db1 ...

Stopped RAC /u01/app/oracle/product/11.2.0.3/db1 successfully

patch /opt/soft/11g/gi_psu_11.2.0.3.8/17076717/custom/server/17076717 apply successful for home /u01/app/oracle/product/11.2.0.3/db1

patch /opt/soft/11g/gi_psu_11.2.0.3.8/16902043 apply successful for home /u01/app/oracle/product/11.2.0.3/db1

Stopping CRS...

Stopped CRS successfully

patch /opt/soft/11g/gi_psu_11.2.0.3.8/17076717 apply successful for home /u01/app/grid patch /opt/soft/11g/gi_psu_11.2.0.3.8/16902043 apply successful for home /u01/app/grid

Starting CRS...

CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0.3/db1 ...

Started RAC /u01/app/oracle/product/11.2.0.3/db1 successfully

opatch auto succeeded. 节点2：

[root@rac2 ~]# /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 /opt/soft/11g -patchn gi_psu_11.2.0.3.8 -ocmrf /home/oracle/ocm.rsp -paramfile /u01/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/cfgtoollogs/opatchauto2016-10-15_20-54-32.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/grid/cfgtoollogs/opatchauto2016-10-15_20-54-32.report.log

2016-10-15 20:54:32: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params

Unable to determine if /u01/app/oracle/product/11.2.0.3/db1 is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Unable to determine if /u01/app/grid is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Stopping RAC /u01/app/oracle/product/11.2.0.3/db1 ...

Stopped RAC /u01/app/oracle/product/11.2.0.3/db1 successfully

patch /opt/soft/11g/gi_psu_11.2.0.3.8/17076717/custom/server/17076717 apply successful for home /u01/app/oracle/product/11.2.0.3/db1

patch /opt/soft/11g/gi_psu_11.2.0.3.8/16902043 apply failed for home /u01/app/oracle/product/11.2.0.3/db1

Stopping CRS...

Stopped CRS successfully

patch /opt/soft/11g/gi_psu_11.2.0.3.8/17076717 apply successful for home /u01/app/grid patch /opt/soft/11g/gi_psu_11.2.0.3.8/16902043 apply failed for home /u01/app/grid

Starting CRS...

CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0.3/db1 ...

Started RAC /u01/app/oracle/product/11.2.0.3/db1 successfully

opatch auto succeeded. 报错

Missing command :fuser UtilSession failed:

Prerequisite check \ Prerequisite check \ Prerequisite check \ Prerequisite check \ Prerequisite check \ Prerequisite check \ Prerequisite check \ Prerequisite check \

安装psmisc包

[root@rac2 ~]# /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 /opt/soft/11g -patchn gi_psu_11.2.0.3.8 -ocmrf /home/oracle/ocm.rsp -paramfile /u01/app/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/grid/cfgtoollogs/opatchauto2016-10-15_21-55-47.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/grid/cfgtoollogs/opatchauto2016-10-15_21-55-47.report.log

2016-10-15 21:55:47: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/grid/crs/install/crsconfig_params

Unable to determine if /u01/app/oracle/product/11.2.0.3/db1 is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Unable to determine if /u01/app/grid is shared oracle home

Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes

Stopping RAC /u01/app/oracle/product/11.2.0.3/db1 ...

Stopped RAC /u01/app/oracle/product/11.2.0.3/db1 successfully

patch /opt/soft/11g/gi_psu_11.2.0.3.8/17076717/custom/server/17076717 apply successful for home /u01/app/oracle/product/11.2.0.3/db1

patch /opt/soft/11g/gi_psu_11.2.0.3.8/16902043 apply successful for home /u01/app/oracle/product/11.2.0.3/db1

Stopping CRS...

Stopped CRS successfully