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

发布时间：2020-07-22 04:50:22 作者：jason_125
来源：网络阅读：974

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

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...链接处理。

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

相关阅读