Installation Oracle11gR2 RAC---自动打GI PSU补丁(11.2.0.4.8)

Oracle 11g RAC自动打GI PSU补丁(11.2.0.4.8)

打补丁(11.2.0.4.8)，可以参考补丁p21523375_112040_linux-x86-64.zip中的reamme.html文件，文件中详细介绍了如何打补丁，以下为概要本实验的简单记录。

1、  下载补丁并上传至所有集群节点

上传补丁p21523375_112040_Linux-x86-64.zip到各节点/mnt目录，解压后赋权移至/tmp目录中。

#unzip p21523375_112040_Linux-x86-64.zip

#chown –R grid:oinstall  21523375

#mv /mnt/21523375  /tmp/

2、升级OPatch工具（所有节点grid与oracle用户均需执行）

grid:

grid@jason1:/u01/app/11.2.0/grid/OPatch> ./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

grid@jason1:/u01/app/11.2.0/grid/OPatch> cd /u01/app/11.2.0/grid/

grid@jason1:/u01/app/11.2.0/grid>mv OPatch  OPatch.bak

grid@jason1:/u01/app/11.2.0/grid> unzip  p6880880_112000_LINUX.zip

grid@jason1:/u01/app/11.2.0/grid> cdOPatch

grid@jason1:/u01/app/11.2.0/grid/OPatch>./opatch version

OPatch Version: 11.2.0.3.10

OPatch succeeded.

grid@jason1:/u01/app/11.2.0/grid/OPatch>

oracle:

oracle@jason1:~> cd/u01/app/oracle/product/11.2.0/dbhome_1/OPatch

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>./opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>cd..

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1> mv OPatch  OPatch.bak

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1>unzip p6880880_112000_LINUX.zip

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1> cd OPatch

oracle@jason1:~> cd/u01/app/oracle/product/11.2.0/dbhome_1/OPatch

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>./opatch version

OPatch Version: 11.2.0.3.10

OPatch succeeded.

oracle@jason1:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch>

3、创建OCM文件(所有节点均需执行)

OCM文件的创建可参考该链接Http://dreamsanqin.blog.51cto.com/845412/1736863

Jason1节点

grid@jason1:/u01/app/11.2.0/grid/OPatch/ocm/bin>./emocmrsp -no_banner -output /tmp/ocm.rsp

Provide your email address to be infORMedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]:  y

The OCM configuration response file(/tmp/ocm.rsp) was successfully created.

grid@jason1:/u01/app/11.2.0/grid/OPatch/ocm/bin>

Jason2节点

grid@jason2:/u01/app/11.2.0/grid/OPatch/ocm/bin>./emocmrsp -no_banner -output /tmp/ocm.rsp

Provide your email address to be informedof security issues, install and

initiate Oracle Configuration Manager.Easier for you if you use your My

Oracle Support Email address/User Name.

Visithttp://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address fornotification of security issues.

Do you wish to remain uninformed ofsecurity issues ([Y]es, [N]o) [N]:  y

The OCM configuration response file(/tmp/ocm.rsp) was successfully created.

grid@jason2:/u01/app/11.2.0/grid/OPatch/ocm/bin>

4、OPatch apply(所有节点均需执行)(无需关闭任何组件及资源)

Jason1：

jason1:/u01/app/11.2.0/grid/OPatch# /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp

Executing/u01/app/11.2.0/grid/perl/bin/perl/u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375-ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This isthe main log file:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-44-20.log

Thisfile will show your detected configuration and all the steps that opatchautoattempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-44-20.report.log

2016-01-2012:44:20: Starting Clusterware Patch Setup

UsinGConfiguration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

StoppingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StoppedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch/tmp/21523375/21352635  apply successfulfor home /u01/app/oracle/product/11.2.0/dbhome_1

patch/tmp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1

StoppingCRS...

StoppedCRS successfully

patch/tmp/21523375/21352635  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352649  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352642  apply successfulfor home  /u01/app/11.2.0/grid

StartingCRS...

InstallingTrace File Analyzer

ACFSdriver install actions failed

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

StartingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StartedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatchauto succeeded.

jason1:/u01/app/11.2.0/grid/OPatch#

Jason2:

jason2:/u01/app/11.2.0/grid/OPatch# /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp

Executing/u01/app/11.2.0/grid/perl/bin/perl/u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375-ocmrf /tmp/ocm.rsp -paramfile/u01/app/11.2.0/grid/crs/install/crsconfig_params

This isthe main log file:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_14-09-33.log

Thisfile will show your detected configuration and all the steps that opatchautoattempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_14-09-33.report.log

2016-01-2014:09:33: Starting Clusterware Patch Setup

Usingconfiguration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

StoppingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StoppedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

patch/tmp/21523375/21352635  apply successfulfor home /u01/app/oracle/product/11.2.0/dbhome_1

patch/tmp/21523375/21352649/custom/server/21352649 apply successful for home /u01/app/oracle/product/11.2.0/dbhome_1

StoppingCRS...

StoppedCRS successfully

patch/tmp/21523375/21352635  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352649  apply successfulfor home  /u01/app/11.2.0/grid

patch/tmp/21523375/21352642  apply successfulfor home  /u01/app/11.2.0/grid

StartingCRS...

InstallingTrace File Analyzer

ACFSdriver install actions failed

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

StartingRAC /u01/app/oracle/product/11.2.0/dbhome_1 ...

StartedRAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully

opatchauto succeeded.

jason2:/u01/app/11.2.0/grid/OPatch#

补丁安装完毕之后，查看集群资源状态

jason2:/u01/app/11.2.0/grid/bin# ./crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.FRA.dg

               ONLINE  ONLINE      jason1                                       

               ONLINE  ONLINE      jason2                                      

ora.LISTENER.lsnr

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                       

ora.OCR.dg

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.asm

               ONLINE  ONLINE      jason1                  Started            

               ONLINE  ONLINE      jason2                  Started            

ora.gsd

               OFFLINE OFFLINE      jason1                                      

               OFFLINE OFFLINE      jason2                                      

ora.net1.network

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.ons

               ONLINE  ONLINE      jason1                                      

               ONLINE  ONLINE      jason2                                      

ora.registry.acfs

               ONLINE  OFFLINE     jason1                                      

               ONLINE OFFLINE      jason2                                       

--------------------------------------------------------------------------------

ClusterResources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1       ONLINE  ONLINE       jason1                                      

ora.cvu

      1       ONLINE  ONLINE       jason1                                      

ora.jason1.vip

      1       ONLINE  ONLINE       jason1                                       

ora.jason2.vip

      1       ONLINE  ONLINE       jason2                                      

ora.oc4j

      1       ONLINE  ONLINE       jason1                                      

ora.oracle.db

      1       ONLINE  ONLINE       jason1                   Open               

      2       ONLINE  ONLINE       jason2                   Open               

ora.scan1.vip

      1       ONLINE  ONLINE       jason1                                      

jason2:/u01/app/11.2.0/grid/bin#

备注：1、根据输出结果可以观察到打补丁的顺序为：关闭RAC-->补丁RAC -->关闭CRS -->补丁CRS -->启动CRS-->启动RAC

      2、ACFS driver install actions failed，该报错查看日志显示为CRS-10001:20-Jan-1613:31 ACFS-9109: oracleacfs.ko driver failed to load.当初安装grid执行root.sh时也有过同样的报错，打过补丁p17475946_112040_Linux-x86-64.zip之后可以正常执行root.sh（参考该链接处理suse11sp3 执行root.sh失败bug处理）。现在不知道为什么打完补丁之后还会有同样的问题。

      3、集群资源中该资源为offline,是因为oracleacfs.kodriver failed to load加载失败导致。重启动各节点资源将恢复正常。

ora.registry.acfs

               ONLINE  OFFLINE     jason1                                      

               ONLINE  OFFLINE     jason2     

5、加载修改SQL文件到数据库修改数据字典

在RAC环境中仅需在一个节点执行以下sql。

（1）

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

SQL> QUIT

The catbundle.sql execution is reflected inthe dba_reGIStry_history view by a row associated with bundle series PSU.

（2）

If the OJVM PSU was applied for a previousGI PSU patch, you may see invalid Java classes after execution of the catbundle.sqlscript in the previous step. If this is the case, run utlrp.sql to re-validatethese Java classes.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

6、检查DB补丁版本

SQL> select * from dba_registry_history;

ACTION_TIME                       ACTION   NAMESPACE VERSION   ID BUNDLE_SERIESCOMMENTS

--------------------------------- -----------------------------------------------------------------------------------------------------------------------------

24-AUG-13 12.03.45.119862 PM      APPLY   SERVER     11.2.0.4   0 PSU          Patchset 11.2.0.2.0

07-JAN-16 11.04.29.479612 PM      APPLY   SERVER     11.2.0.4   0 PSU          Patchset 11.2.0.2.0

20-JAN-16 03.31.06.023073 PM      APPLY   SERVER     11.2.0.4   8 PSU           PSU 11.2.0.4.8

SQL>

7、报错处理

补丁自动升级时报如下错误

jason1:/u01/app/11.2.0/grid/OPatch # /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf /tmp/ocm.rsp 

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch21203.pl -patchdir /tmp -patchn 21523375 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.log

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

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.report.log

2016-01-20 12:38:42: Starting Clusterware Patch Setup

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

The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0/dbhome_1

The opatch Component check failed. This patch is not applicable for /u01/app/oracle/product/11.2.0/dbhome_1

Conflict check failed for oracle home  /u01/app/oracle/product/11.2.0/dbhome_1

Conflict check failed

ERROR: Conflict-Check has failed . Please refer to /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-01-20_12-38-42.log for details

opatch auto failed.

jason1:/u01/app/11.2.0/grid/OPatch #

该报错可以参考GI OPatch升级 The opatch Component check failed. This patch is not applicable for...链接处理。