Shulou(Shulou.com)06/01 Report--

Patching the RHEL6.6+11gR2RAC platform (11.2.0.4.8) and patching Patch 22646198-Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016) (IncludesDatabase PSU 11.2.0.4.160419) both require that the opatch tool version be updated to OPatch utility version 11.2.0.3.6 or later. After the following tests:

Use the OPatchVersion: 11.2.0.3.10 upgrade patch (11.2.0.4.8) to see the article that Oracle11g RAC automatically patches GIPSU (11.2.0.4.8).

Upgrade the patch Patch32646198-Oracle Grid Infrastructure Patch Set Update 11.2.0.4.160419 (Apr2016) (Includes Database PSU 11.2.0.4.160419) with OPatchVersion: 11.2.0.3.13. Refer to Oracle11g RAC to automatically patch GIPSU (11.2.0.4.8). The execution result of this article is as follows:

[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: opatchauto 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-26mm 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/opatch3016-05-26mm 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/opatch3016-05-26mm 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/opatch3016-05-26mm 23-12-13PM_1.log

Patch:/tmp/21523375/21352649

Log:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-05-26mm 23-12-13PM_1.log

Patch:/tmp/21523375/21352642

Log:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch3016-05-26mm 23-12-13PM_1.log

OPatchAutosuccessful.

[root@cluster1 OPatch] #

The above information is a patch message, and the red message is a warning message, which does not affect the success of the patch. However, it is concluded from the red message that the upgrade command has changed in OPatch Version: 11.2.0.3.13. Opatchauto will be abandoned and replaced with opatchauto, and-ocmrf will no longer be needed.

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

Oracle OPatchAuto Version 13.9.0.0.0

Copyright (c) 2015, Oracle Corporation. All rights reserved.

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

: =-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

Copyright (c) 2015, Oracle Corporation. All rights reserved.

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

Copyright (c) 2015, Oracle Corporation. All rights reserved.

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 []

[- phBaseDir]

[- oh] [- log]

[- logLevel] [- binary]

[- analyze]

[- invPtrLoc]

[- host] [- wallet] [- rolling]

[- database] [- generatesteps]

[- norestart] [- ocmrf] [- sdb]

[- remote] [- nonrolling]

OPTIONS

-phBaseDir

The location of base patch directory.

-oh

The location of the oracle home.

-log

The log location.

-logLevel

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

The central inventory pointer file location.

-host

The remote host or host:port.

-wallet

The location of the wallet file.

-rolling

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

-database

List of databases to be patched.

-generatesteps

Enables generation of steps.

-norestart

The no restart option during execution.

-ocmrf

Location of ocmrf file.

-sdb

To signify patching sharded database. Run 'opatchauto-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:

'/ OPatch/opatchauto apply'

To patch multiple homes:

'/ OPatch/opatchauto apply-oh,'

To patch databases running only from RAC homes:

'/ OPatch/opatchauto apply-database db1,db2...dbn'

To patch software-only installation:

'/ OPatch/opatchauto apply-oh' OR

'/ OPatch/opatchauto apply-oh'

Refer to the warning message and Opatch tool help to perform a patching upgrade on Node 2 using the new method as follows:

[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/opatch3016-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/opatch3016-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/opatch3016-05-30 23-25-27PM_1.log

Patch: / tmp/22646198/22502549

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

Patch: / tmp/22646198/22502505

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

OPatchAuto successful.

[root@cluster2 OPatch] #

The Node 2 patch was upgraded successfully. Using the new method to upgrade again on Node 1 displays the following information:

[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

[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 CRS Home.

Executing OPatch prereq operations to verify patch applicability on RAC 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 CRS Home.

Executing prereq 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

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.

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

[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_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_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

No step execution required.

[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

No step execution required.

[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:cluster1

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"

Patch: / tmp/22646198/22502456

Reason: This patch is already been applied, so not going to apply again.

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

Reason: This patch is already been applied, so not going to apply again.

Host:cluster1

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"

Patch: / tmp/22646198/22502456

Reason: This patch is already been applied, so not going to apply again.

Patch: / tmp/22646198/22502549

Reason: This patch is already been applied, so not going to apply again.

Patch: / tmp/22646198/22502505

Reason: This patch is already been applied, so not going to apply again.

# shows that it has been applied

OPatchAuto successful.

[root@cluster1 OPatch] #

View upgrade results

[grid@cluster1 OPatch] $. / opatch isinventory

Oracle Interim Patch Installer version 11.2.0.3.13

Copyright (c) 2016, Oracle Corporation. All rights reserved.

Syntax Error... Unrecognized Command or Option (isinventory): 1st argument must be one of the following:

Apply

Napply

Rollback

Nrollback

Lsinventory

Lsinv

Lspatches

Query

Util

Prereq

Version

-help

-help-fmw

Please use the option 'opatch-help' to get correct syntax

OPatch failed with error code 14

[grid@cluster1 OPatch] $. / opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.13

Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home: / u01/app/11.2.0/grid

Central Inventory: / u01/app/oraInventory

From: / u01/app/11.2.0/grid/oraInst.loc

OPatch version: 11.2.0.3.13

OUI version: 11.2.0.4.0

Log file location: / u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch3016-05-31: 00-39-56AM_1.log

Lsinventory Output file location: / u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-05-31: 00-39-56AM.txt

Local Machine Information::

Hostname: cluster1

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0

There are 1 products installed in this Oracle Home.

Interim patches (5):

Patch 22502505: applied on Mon May 30 20:47:23 CST 2016

Unique Patch ID: 19880366

Patch description: "ACFS Patch Set Update: 11.2.0.4.160419 (22502505)"

Created on 17 Feb 2016, 00:12:23 hrs PST8PDT

Bugs fixed:

21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148

17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796

18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303

18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334

18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946

Patch 22502549: applied on Mon May 30 20:41:38 CST 2016

Unique Patch ID: 19880366

Patch description: "OCW Patch Set Update: 11.2.0.4.160419 (22502549)"

Created on 11 Mar 2016, 01:34:48 hrs PST8PDT

Bugs fixed:

19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394

20365005, 17750548, 17387214, 17617807, 14497275, 20219458, 17733927

18180541, 18962892, 17292250, 17378618, 16759171, 20110156, 17843489

17065496, 13991403, 17273020, 17155238, 20012766, 21245437, 18261183

18053580, 20218012, 17013634, 17886392, 20995001, 17039197, 17947785

16317771, 10052729, 22353346, 20340620, 16237657, 20317221, 15917869

18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251

20246071, 14270845, 20552947, 18882642, 18414137, 17001914, 17927970

14378120, 16346413, 15986647, 18068871, 21222147, 18143836, 16206997

21982225, 19168690, 20235511, 18343490, 21875360, 16613232, 19276791

17722664, 20440643, 12928658, 18952577, 18520351, 16249829, 18226143

16076412, 18265482, 18229842, 17172091, 20676340, 17818075, 20091753

18231837, 14373486, 20136892, 17483479, 20551654, 18120545, 18729166

13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 17087371

20531190, 14525998, 18187697, 20598625, 14385860, 18348155, 19479503

12928592, 17516024, 18370031, 17764053, 19272663, 17551223, 14671408

18272135, 14207615, 21255373, 17500165, 18875012, 14769643, 18464784

19558324, 18848125, 19241857, 14851828, 17955615, 20315294, 14693336

16284825, 17352230, 20014326, 17238586, 17089344, 17405605, 21327402

17531342, 19398098, 17159489, 17640316, 13823394, 16543190, 22024217

17983675, 20795241, 17598201, 17481314, 16281493, 18346135, 15986311

19601468, 17208793, 18700935, 18999857, 14076173, 18428146, 18352845

17435488, 20408163, 17592037, 18352846, 19616601, 17391726, 17387779

14777968, 15851860, 16206882, 20141091, 21113068, 20175174, 17305100

15832129, 19885321, 16901346, 17985714, 18536826, 17780903, 18752378

18946768, 16876500, 16875342, 17769597, 19955755, 16429265, 18336452

17273003, 17209968, 16988311, 20094984, 19319357, 17059927, 17046460

18053631, 16867761, 18774591, 21442094, 20235486, 19359787, 15869775

19642566, 17447588, 16798862, 15920201

Patch 22502456: applied on Mon May 30 20:38:44 CST 2016

Unique Patch ID: 19856194

Patch description: "Database Patch Set Update: 11.2.0.4.160419 (22502456)"

Created on 21 Mar 2016, 11:49:22 hrs

Sub-patch 21948347; "Database Patch Set Update: 11.2.0.4.160119 (21948347)"

Sub-patch 21352635; "Database Patch Set Update: 11.2.0.4.8 (21352635)"

Sub-patch 20760982; "Database Patch Set Update: 11.2.0.4.7 (20760982)"

Sub-patch 20299013; "Database Patch Set Update: 11.2.0.4.6 (20299013)"

Sub-patch 19769489; "Database Patch Set Update: 11.2.0.4.5 (19769489)"

Sub-patch 19121551; "Database Patch Set Update: 11.2.0.4.4 (19121551)"

Sub-patch 18522509; "Database Patch Set Update: 11.2.0.4.3 (18522509)"

Sub-patch 18031668; "Database Patch Set Update: 11.2.0.4.2 (18031668)"

Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514)"

Bugs fixed:

22195448, 18619917, 19309466, 17655240, 18384391, 16992075, 18189036

13609098, 16285691, 22195441, 17025461, 18430495, 17323222, 16472716

19289642, 19915271, 14458214, 22195457, 22502493, 18331850, 17945983

13498382, 16494615, 21352646, 16901385, 16596890, 18673304, 17610798

18456514, 8322815, 18996843, 21387964, 17313525, 20334344, 17050888

17174582, 18317531, 11733603, 17798953, 18260550, 14015842, 18031668

17390160, 18316692, 19458377, 14368995, 17551063, 21343838, 16065166

12905058, 16855292, 16579084, 21179898, 15990359, 13364795, 18235390

18293054, 18673325, 19393542, 20142975, 14657740, 17393683, 17389192

16315398, 20861693, 17783588, 17852463, 17037130, 19358317, 17441661

17284817, 14034426, 20631274, 17891946, 17588480, 16731148, 22321741

17165204, 17891943, 18282562, 17265217, 17465741, 18191164, 16721594

18614015, 17348614, 19827973, 19769489, 17346671, 20596234, 18482502

16043574, 17360606, 22321756, 19211724, 19463893, 17477958, 17040764

18362222, 19463897, 17853456, 13853126, 18273830, 17816865, 13558557

21868720, 17951233, 18180390, 17040527, 14692762, 17027426, 17851160

16870214, 18009564, 18202441, 20803583, 17622427, 16903536, 19006849

20506699, 17865671, 17883081, 16228604, 17761775, 16306373, 17325413

17082359, 12747740, 16091637, 19680952, 16850630, 17694209, 17468141

17877323, 18230522, 17446237, 17889549, 16042673, 17437634, 17571039

19049453, 19972570, 21168487, 17016369, 16833527, 21343775, 17297939

16069901, 21343897, 18522509, 14285317, 21972320, 19972569, 18436647

19972568, 17716305, 19972566, 19972564, 21983325, 17394950, 17853498

20657441, 16542886, 17006570, 21286665, 17752995, 17296856, 18051556

12364061, 17546973, 18262334, 18783224, 19699191, 22353199, 17227277

18018515, 16180763, 16943711, 17982555, 18098207, 18436307, 19584068

18339044, 17282229, 14054676, 18228645, 19013183, 18856999, 17721717

17239687, 18471685, 17258090, 16344544, 17344412, 17011832, 18135678

18704244, 17786518, 17242746, 19197175, 17390431, 17835627, 17672719

17393915, 16777840, 17811456, 18765602, 19730508, 17385178, 10136473

20296213, 13955826, 18193833, 17545847, 16837842, 18964939, 17811447

18554763, 20004087, 17889583, 12816846, 19544839, 18868646, 18747196

17042658, 17824637, 14106803, 16524926, 13951456, 17343514, 18139690

18277454, 19271443, 18681862, 17186905, 17811438, 18554871, 17215560

16875449, 17274537, 17602269, 17184721, 19032867, 17762296, 14829250

18508861, 19466309, 16929165, 14602788, 17811429, 18441944, 17811789

17754782, 17752121, 20074391, 14852021, 17705023, 13645875, 17201159

16668584, 17786278, 16198143, 18828868, 17586955, 16692232, 17649265

16384983, 21756699, 17957017, 19121551, 17570240, 17787259, 19788842

21330264, 18094246, 14338435, 13944971, 17375354, 17156148, 17936109

21538567, 18762750, 22683212, 21526048, 16450169, 17478145, 18096714

17238511, 17311728, 17648596, 18244962, 17308789, 21756677, 18674047

14084247, 22683225, 18280813, 17614227, 17006183, 18092127, 19727057

17205719, 20004021, 17922254, 21756661, 13837378, 18084625, 17912217

11883252, 12982566, 14764829, 21847223, 15861775, 21668627, 17237521

16934803, 20925795, 17848897, 20441797, 19554106, 18199537, 16613964

18334586, 17288409, 17341326, 18091059, 17449815, 17299889, 15913355

16399083, 21538485, 17546761, 14565184, 21517440, 18155762, 17614134

16956380, 19854503, 14245531, 16194160, 18325460, 15979965, 19258504

18247991, 16314254, 16912439, 17246576, 17655634, 20067212, 22092979

19721304, 18203835, 20506715, 18203838, 18973907, 18203837, 19615136

17587063, 18000422, 20506706, 18641451, 17397545, 16785708, 21051862

18641461, 17346091, 13829543, 16220077, 18061914, 20448824, 18674024

17596908, 17036973, 17612828, 17892268, 21051858, 21051852, 17767676

17232014, 17501491, 12611721, 22893153, 14354737, 18356166, 17071721

17835048, 16863422, 21787056, 22195485, 21051840, 17267114, 17082983

21538558, 18641419, 16392068, 18744139, 16618694, 14133975, 22195492

18331812, 18093615, 14010183, 16595641, 17080436, 17332800, 20777150

21453153, 20299015, 18264060, 13866822, 21351877, 21051833, 18673342

17600719, 17842825, 20558005, 17088068, 9756271, 22195465, 18440047

16571443, 18328509, 20331945, 18384537, 18607546, 16422541, 18306996

18315328, 17443671, 17478514, 21067387, 16268425, 16360112, 17381384

22195477, 17726838, 18723434, 17235750, 17571306, 17302277, 17551709

17634921, 16538760

Patch 21352642: applied on Fri May 27 23:37:17 CST 2016

Unique Patch ID: 19203841

Patch description: "ACFS Patch Set Update: 11.2.0.4.8 (21352642)"

Created on 3 Sep 2015, 00:03:11 hrs PST8PDT

Bugs fixed:

17510275, 21369858, 17172303, 16318126, 19690653, 18610307, 17503605

17376318, 17203009, 20140148, 17721778, 17611362, 17164243, 19053182

17696547, 17699423, 17488768, 18915417, 18155334, 19919907, 18321597

18185024, 18168684, 17363999, 17636008, 18143006, 17428148, 20681968

17070158, 17475946

Patch 21352649: applied on Fri May 27 23:34:20 CST 2016

Unique Patch ID: 19203841

Patch description: "OCW Patch Set Update: 11.2.0.4.8 (21352649)"

Created on 2 Sep 2015, 23:43:49 hrs PST8PDT

Bugs fixed:

19270660, 18328800, 18508710, 18691572, 21251192, 20365005, 17750548

17387214, 17617807, 14497275, 20219458, 17733927, 18180541, 18962892

17292250, 17378618, 16759171, 20110156, 17843489, 17065496, 13991403

17273020, 17155238, 21245437, 18261183, 18053580, 20218012, 20995001

17039197, 17947785, 16317771, 10052729, 20340620, 20317221, 15917869

18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251

20246071, 14270845, 18882642, 18414137, 17001914, 17927970, 14378120

16346413, 15986647, 18068871, 21222147, 18143836, 16206997, 19168690

20235511, 18343490, 16613232, 19276791, 17722664, 20440643, 12928658

18952577, 18520351, 16249829, 18226143, 18265482, 18229842, 17172091

20676340, 17818075, 20091753, 18231837, 14373486, 17483479, 18120545

18729166, 13843841, 21225209, 17405302, 18709496, 18330979, 18744838

17087371, 20531190, 14525998, 18187697, 20598625, 14385860, 18348155

19479503, 12928592, 17516024, 18370031, 17764053, 19272663, 17551223

14671408, 18272135, 14207615, 17500165, 18875012, 18464784, 19558324

18848125, 19241857, 14851828, 17955615, 20315294, 14693336, 16284825

17352230, 20014326, 17238586, 17089344, 17405605, 17531342, 17159489

17640316, 13823394, 16543190, 17983675, 17598201, 17481314, 16281493

18346135, 15986311, 19601468, 17208793, 18700935, 18999857, 14076173

18428146, 18352845, 17435488, 18352846, 17391726, 17387779, 14777968

15851860, 16206882, 20141091, 20175174, 17305100, 15832129, 19885321

16901346, 17985714, 18536826, 17780903, 18752378, 18946768, 16876500

16875342, 17769597, 19955755, 16429265, 18336452, 17273003, 17209968

16988311, 20094984, 19319357, 17059927, 17046460, 18053631, 16867761

18774591, 21442094, 20235486, 19359787, 15869775, 19642566, 17447588

16798862, 15920201

Rac system comprising of multiple nodes

Local node = cluster1

Remote node = cluster2

OPatch succeeded.

[grid@cluster1 OPatch] $

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.