OPatch Version: 11.2.0.3.13版本与OPatch Version: 11.2.0.3.10版本升级补丁区别

原创

jason_125 2016-05-30 17:07:30 博主文章分类：Oracle故障处理 ©著作权

©著作权归作者所有：来自51CTO博客作者jason_125的原创作品，请联系作者获取转载授权，否则将追究法律责任

在RHEL6.6+11gR2RAC平台打补丁(11.2.0.4.8)与Patch 22646198 -Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016) (IncludesDatabase PSU 11.2.0.4.160419)补丁都要求更新opatch工具版本为 OPatch utility version 11.2.0.3.6 or later 。进行如下测试后：

使用OPatchVersion: 11.2.0.3.10升级补丁(11.2.0.4.8)，方法可查看Oracle11g RAC自动打GIPSU补丁(11.2.0.4.8)该篇文章。

使用OPatchVersion: 11.2.0.3.13版本升级Patch22646198 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016)(Includes Database PSU 11.2.0.4.160419)补丁。参照Oracle11g RAC自动打GIPSU补丁(11.2.0.4.8)该篇文章执行结果如下：

[root@cluster1dbhome_1]# /u01/app/11.2.0/grid/OPatch/opatch auto /tmp/21523375 -ocmrf/tmp/ocm.rsp

Executingsh /u01/app/11.2.0/grid/OPatch/crs/../auto/database/bin/opatchauto11.sh-patchdir /tmp -patchn 21523375 -ocmrf /tmp/ocm.rsp

Note: opatch auto is deprecated and opatchauto is available as replacement. Please use opatchauto -help for more details.

Systeminitialization log file is/u01/app/11.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-05-26_10-58-17PM.log.

Sessionlog file is/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/opatchauto2016-05-26_10-59-10PM.log

WARNING:the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration. It will be removed in a future release.

The idfor this session is QLIX

[init:init]Executing OPatchAutoBinaryAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

[init:init]Executing OPatchAutoBinaryAction action on home /u01/app/11.2.0/grid

ExecutingOPatch prereq operations to verify patch applicability on RAC Home........

ExecutingOPatch prereq operations to verify patch applicability on CRS Home........

[init:init]OPatchAutoBinaryAction action completed on home /u01/app/11.2.0/gridsuccessfully

[init:init]OPatchAutoBinaryAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[init:init]Executing GIRACPrereqAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

[init:init]Executing GIRACPrereqAction action on home /u01/app/11.2.0/grid

Executingprereq operations before applying on CRS Home........

Executingprereq operations before applying on RAC Home........

[init:init]GIRACPrereqAction action completed on home /u01/app/11.2.0/grid successfully

[init:init]GIRACPrereqAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[init:init]Executing RACDBPrereqAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Nostep execution required.........

[init:init]RACDBPrereqAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:prepare-shutdown]Executing RACPrepareShutDownAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

PreparingRAC Home to bring down database service........

[shutdown:prepare-shutdown]RACPrepareShutDownAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:shutdown]Executing RACShutDownAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Stoppingthe database service on RAC Home for patching........

Followingdatabase(s) and/or service(s) are stopped and will be restarted later duringthe session: oracle

[shutdown:shutdown]RACShutDownAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1successfully

[shutdown:shutdown]Executing RACOneAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

/u01/app/oracle/product/11.2.0/dbhome_1is not a RACOne database. No step execution required........

[shutdown:shutdown]RACOneAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1successfully

[shutdown:shutdown]Executing GIShutDownAction action on home /u01/app/11.2.0/grid

Performingprepatch operations on CRS Home........

[shutdown:shutdown]GIShutDownAction action completed on home /u01/app/11.2.0/grid successfully

[offline:prepare]Executing RACPatchingAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Performingprepatch operation on RAC Home........

[offline:prepare]RACPatchingAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:binary-patching]Executing OPatchAutoBinaryAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Startapplying binary patches on RAC Home........

[offline:binary-patching]OPatchAutoBinaryAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:finalize]Executing RACPatchingAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Performingpostpatch operation on RAC Home........

[offline:finalize]RACPatchingAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:binary-patching]Executing OPatchAutoBinaryAction action on home /u01/app/11.2.0/grid

Startapplying binary patches on CRS Home........

[offline:binary-patching]OPatchAutoBinaryAction action completed on home /u01/app/11.2.0/gridsuccessfully

[startup:startup]Executing GIStartupAction action on home /u01/app/11.2.0/grid

Performingpostpatch operations on CRS Home........

Postpatchoperation log file location:/u01/app/11.2.0/grid/cfgtoollogs/crsconfig/crspatch_cluster1.log

[startup:startup]GIStartupAction action completed on home /u01/app/11.2.0/grid successfully

[startup:startup]Executing RACOneAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

/u01/app/oracle/product/11.2.0/dbhome_1is not a RACOne database. No step execution required........

[startup:startup]RACOneAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1successfully

[startup:startup]Executing RACStartupAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Startingthe database service on RAC Home........

[startup:startup]RACStartupAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[startup:finalize]Executing RACFinalizeStartAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

PreparingRAC Home after database service restarted........

[startup:finalize]RACFinalizeStartAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[online:product-patching]Executing RACOnlineAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Nostep execution required.........

[online:product-patching]RACOnlineAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

[finalize:finalize]Executing OracleHomeLSInventoryGrepAction action on home /u01/app/11.2.0/grid

Verifyingpatches applied on CRS Home.

[finalize:finalize]OracleHomeLSInventoryGrepAction action completed on home /u01/app/11.2.0/gridsuccessfully

[finalize:finalize]Executing OracleHomeLSInventoryGrepAction action on home/u01/app/oracle/product/11.2.0/dbhome_1

Verifyingpatches applied on RAC Home.

[finalize:finalize]OracleHomeLSInventoryGrepAction action completed on home/u01/app/oracle/product/11.2.0/dbhome_1 successfully

--------------------------------Summary--------------------------------

Patchingis completed successfully. Please find the summary as follows:

Host:cluster1

RACHome:/u01/app/oracle/product/11.2.0/dbhome_1

Summary:

==Followingpatches were SKIPPED:

Patch:/tmp/21523375/21352649

Reason:This patch is not applicable to this specified target type -"rac_database"

Patch:/tmp/21523375/21352642

Reason:This patch is not applicable to this specified target type -"rac_database"

==Followingpatches were SUCCESSFULLY applied:

Patch:/tmp/21523375/21352635

Log:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-26_23-05-37PM_1.log

Patch:/tmp/21523375/21352649/custom/server/21352649

Log:/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-26_23-05-37PM_1.log

Host:cluster1

CRSHome:/u01/app/11.2.0/grid

Summary:

==Followingpatches were SKIPPED:

Patch:/tmp/21523375/21352649/custom/server/21352649

Reason:This patch is not applicable to this specified target type -"cluster"

==Followingpatches were SUCCESSFULLY applied:

Patch:/tmp/21523375/21352635

Log:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-26_23-12-13PM_1.log

Patch:/tmp/21523375/21352649

Log:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-26_23-12-13PM_1.log

Patch:/tmp/21523375/21352642

Log:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-26_23-12-13PM_1.log

OPatchAutosuccessful.

[root@cluster1 OPatch]#

以上信息为打补丁信息，红色信息为警告信息，不影响打补丁显示已成功。但是从红色信息中得出OPatch Version: 11.2.0.3.13版本中升级命令已发生变化。opatch auto 将被遗弃使用opatchauto代替，同时-ocmrf也将不再需要。

[root@cluster1 OPatch]# ./opatchauto -help

Oracle OPatchAuto Version 13.9.0.0.0

Usage: opatchauto [ command ] [ -help ]

Purpose:

A patch orchestration tool that generates patching instructions specific

to your target configuration and then uses OPatch to perform the patching

operations without user intervention. Specifically, OPatchauto can:

Perform pre-patch checks.

Apply the patch

Perform post-patch checks.

Roll back patches when patch de installation is required.

command := rollback

apply

resume

version

<global_arguments> := -help

example:

'opatchauto -help'

'opatchauto rollback -help'

'opatchauto apply -help'

'opatchauto resume -help'

'opatchauto version'

[root@cluster1 OPatch]# ./opatchauto version

Oracle OPatchAuto Version 13.9.0.0.0

1. OPatchAuto version 13.9.0.0.0

2. OpatchautoDB version 12.1.0.1.12

[root@cluster1 OPatch]# ./opatchauto apply -help

Oracle OPatchAuto Version 13.9.0.0.0

DESCRIPTION

This operation applies patch.

Purpose:

Apply a System Patch to Oracle Home. If patch location is not

specified, current directory will be taken as the patch location.

SYNTAX

opatchauto apply [ <patch-location> ]

[ -phBaseDir <patch.base.directory> ]

[ -oh <home> ] [ -log <log> ]

[ -logLevel <log_priority> ] [ -binary ]

[ -analyze ]

[ -invPtrLoc <inventory.pointer.location> ]

[ -host <host> ] [ -wallet <wallet> ] [ -rolling ]

[ -database <database> ] [ -generatesteps ]

[ -norestart ] [ -ocmrf <ocmrf> ] [ -sdb ]

[ -remote ] [ -nonrolling ]

OPTIONS

-phBaseDir <patch.base.directory>

The location of base patch directory.

-oh <home>

The location of the oracle home.

-log <log>

The log location.

-logLevel <log_priority>

The log level (defaults to "INFO").

Supported values:

[SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL, OFF]

-binary

Forces execution of "-phases offline:binary-patching".

-analyze

If this option is selected, the environment will be analysed for suitability of the patch on each home, without affecting the home.

The patch will not be applied or rolled back, and targets will not be shut down.

-invPtrLoc <inventory.pointer.location>

The central inventory pointer file location.

-host <host>

The remote host or host:port.

-wallet <wallet>

The location of the wallet file.

-rolling

Enables sdb rolling mode where database(s) are patched one after the other.

-database <database>

List of databases to be patched.

-generatesteps

Enables generation of steps.

-norestart

The no restart option during execution.

-ocmrf <ocmrf>

Location of ocmrf file.

-sdb

To signify patching sharded database. Run 'opatchauto <apply|rollback> -sdb -help' to get more help on patching a sharded database.

-remote

Enables remote node patching. This is supported only for Grid setup and it should be up and running.

-nonrolling

Enables non-rolling mode.

PARAMETERS

patch-location

The patch location.

EXAMPLES

To patch GI home and all RAC homes:

'<GI_HOME>/OPatch/opatchauto apply <Patch_Location>'

To patch multiple homes:

'<GI_HOME>/OPatch/opatchauto apply <Patch_Location> -oh <GI_HOME>,<RAC_HOME1>,<RAC_HOME2>'

To patch databases running only from RAC homes:

'<RAC_HOME>/OPatch/opatchauto apply <Patch_Location>-database db1,db2...dbn'

To patch software-only installation:

'<RAC_HOME>/OPatch/opatchauto apply <Patch_Location> -oh <RAC_HOME>' OR

'<GI_HOME>/OPatch/opatchauto apply <Patch_Location>-oh <GI_HOME>'

参考警告信息及Opatch工具帮助信息使用新方法在节点2上执行打补丁升级如下：

[root@cluster2 OPatch]# ./opatchauto apply /tmp/22646198/

System initialization log file is /u01/app/11.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-05-30_11-12-58PM.log.

Session log file is /u01/app/11.2.0/grid/cfgtoollogs/opatchauto/opatchauto2016-05-30_11-14-51PM.log

The id for this session is 1F9H

[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/11.2.0/grid

Executing OPatch prereq operations to verify patch applicability on RAC Home........

Executing OPatch prereq operations to verify patch applicability on CRS Home........

[init:init] OPatchAutoBinaryAction action completed on home /u01/app/11.2.0/grid successfully

[init:init] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[init:init] Executing GIRACPrereqAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

[init:init] Executing GIRACPrereqAction action on home /u01/app/11.2.0/grid

Executing prereq operations before applying on RAC Home........

Executing prereq operations before applying on CRS Home........

[init:init] GIRACPrereqAction action completed on home /u01/app/11.2.0/grid successfully

[init:init] GIRACPrereqAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[init:init] Executing RACDBPrereqAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

No step execution required.........

[init:init] RACDBPrereqAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:prepare-shutdown] Executing RACPrepareShutDownAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Preparing RAC Home to bring down database service........

[shutdown:prepare-shutdown] RACPrepareShutDownAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:shutdown] Executing RACShutDownAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Stopping the database service on RAC Home for patching........

Following database(s) and/or service(s) are stopped and will be restarted later during the session: cluster

[shutdown:shutdown] RACShutDownAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:shutdown] Executing RACOneAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

/u01/app/oracle/product/11.2.0/dbhome_1 is not a RACOne database. No step execution required........

[shutdown:shutdown] RACOneAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[shutdown:shutdown] Executing GIShutDownAction action on home /u01/app/11.2.0/grid

Performing prepatch operations on CRS Home........

[shutdown:shutdown] GIShutDownAction action completed on home /u01/app/11.2.0/grid successfully

[offline:prepare] Executing RACPatchingAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Performing prepatch operation on RAC Home........

[offline:prepare] RACPatchingAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Start applying binary patches on RAC Home........

[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:finalize] Executing RACPatchingAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Performing postpatch operation on RAC Home........

[offline:finalize] RACPatchingAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/11.2.0/grid

Start applying binary patches on CRS Home........

[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/11.2.0/grid successfully

[startup:startup] Executing GIStartupAction action on home /u01/app/11.2.0/grid

Performing postpatch operations on CRS Home........

Postpatch operation log file location: /u01/app/11.2.0/grid/cfgtoollogs/crsconfig/crspatch_cluster2.log

[startup:startup] GIStartupAction action completed on home /u01/app/11.2.0/grid successfully

[startup:startup] Executing RACOneAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

/u01/app/oracle/product/11.2.0/dbhome_1 is not a RACOne database. No step execution required........

[startup:startup] RACOneAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[startup:startup] Executing RACStartupAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Starting the database service on RAC Home........

[startup:startup] RACStartupAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[startup:finalize] Executing RACFinalizeStartAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Preparing RAC Home after database service restarted........

[startup:finalize] RACFinalizeStartAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[online:product-patching] Executing RACOnlineAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

No step execution required.........

[online:product-patching] RACOnlineAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/11.2.0/grid

Verifying patches applied on CRS Home.

[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/11.2.0/grid successfully

[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/oracle/product/11.2.0/dbhome_1

Verifying patches applied on RAC Home.

[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/oracle/product/11.2.0/dbhome_1 successfully

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:cluster2

RAC Home:/u01/app/oracle/product/11.2.0/dbhome_1

Summary:

==Following patches were SKIPPED:

Patch: /tmp/22646198/22502549

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /tmp/22646198/22502505

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY applied:

Patch: /tmp/22646198/22502456

Log: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-30_23-21-20PM_1.log

Patch: /tmp/22646198/22502549/custom/server/22502549

Log: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-30_23-21-20PM_1.log

Host:cluster2

CRS Home:/u01/app/11.2.0/grid

Summary:

==Following patches were SKIPPED:

Patch: /tmp/22646198/22502549/custom/server/22502549

Reason: This patch is not applicable to this specified target type - "cluster"

==Following patches were SUCCESSFULLY applied:

Patch: /tmp/22646198/22502456

Log: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-30_23-25-27PM_1.log

Patch: /tmp/22646198/22502549

Log: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-30_23-25-27PM_1.log

Patch: /tmp/22646198/22502505

Log: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-05-30_23-25-27PM_1.log

OPatchAuto successful.

[root@cluster2 OPatch]#

节点2补丁升级成功。使用新方法在节点1再次升级显示如下信息：

[root@cluster1 OPatch]# ./opatchauto apply /tmp/22646198/

System initialization log file is /u01/app/11.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-05-30_11-56-56PM.log.

Session log file is /u01/app/11.2.0/grid/cfgtoollogs/opatchauto/opatchauto2016-05-30_11-58-07PM.log

The id for this session is DLMU