Manually applying CW Patch ( 12.1.0.1.5 )

Overview

  • In this tutorial we will manually apply a CW patch [ 19849140 ] without using opatchauto.
  • For that we closely follow the patch README – chapter 5 [  patches/12105/19849140/README.html ]   ->  Manual Steps for Apply/Rollback Patch

Check for conflicts

[root@gract1 CLUVFY-JAN-2015]#  $GRID_HOME/OPatch/opatchauto apply /media/sf_kits/patches/12105/19849140 -analyze 
 OPatch Automation Tool
Copyright (c) 2015, Oracle Corporation.  All rights reserved.
OPatchauto version : 12.1.0.1.5
OUI version        : 12.1.0.1.0
Running from       : /u01/app/121/grid
opatchauto log file: /u01/app/121/grid/cfgtoollogs/opatchauto/19849140/opatch_gi_2015-01-22_18-25-48_analyze.log
NOTE: opatchauto is running in ANALYZE mode. There will be no change to your system.
Parameter Validation: Successful
Grid Infrastructure home:
/u01/app/121/grid
RAC home(s):
/u01/app/oracle/product/121/racdb
Configuration Validation: Successful
Patch Location: /media/sf_kits/patches/12105/19849140
Grid Infrastructure Patch(es): 19849140 
RAC Patch(es): 19849140 
Patch Validation: Successful
Analyzing patch(es) on "/u01/app/oracle/product/121/racdb" ...
[WARNING] The local database instance 'dw_2' from '/u01/app/oracle/product/121/racdb' is not running. 
SQL changes, if any,  will not be analyzed. Please refer to the log file for more details.
[WARNING] SQL changes, if any, could not be analyzed on the following database(s): ERP ... Please refer to the log 
file for more details. 
Apply Summary:
opatchauto ran into some warnings during analyze (Please see log file for details):
GI Home: /u01/app/121/grid: 19849140
RAC Home: /u01/app/oracle/product/121/racdb: 19849140
opatchauto completed with warnings.
You have new mail in /var/spool/mail/root

If this is a GI Home, as the root user execute:
Oracle Clusterware active version on the cluster is [12.1.0.1.0]. The cluster upgrade state is [NORMAL]. 
The cluster active 
patch level is [482231859].
..
--> As this is a clusterware patch ONLY ignore the WARNINGs 
    
  •  Note during the analyze step we get a first hint that all instances must run on all all server for applying the patch !

Run pre root script and apply the GRID patch

1) Stop all databases rununing out of this ORACLE_HOME and unmount ACFS filesystem

2) Run the pre root script
[grid@gract1 gract1]$ $GRID_HOME>/crs/install/rootcrs.pl -prepatch

3) Apply the CRS patch 
[grid@gract1 gract1]$   $GRID_HOME/OPatch/opatch apply -oh $GRID_HOME 
                          -local /media/sf_kits/patches/12105/19849140/19849140
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/121/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/121/grid/oraInst.loc
OPatch version    : 12.1.0.1.5
OUI version       : 12.1.0.1.0
Log file location : /u01/app/121/grid/cfgtoollogs/opatch/opatch2015-01-23_12-25-48PM_1.log

Applying interim patch '19849140' to OH '/u01/app/121/grid'
Verifying environment and performing prerequisite checks...
Interim patch 19849140 is a superset of the patch(es) [  17077442 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/121/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Rolling back interim patch '17077442' from OH '/u01/app/121/grid'
Patching component oracle.crs, 12.1.0.1.0...
Patching component oracle.has.db, 12.1.0.1.0...
Patching component oracle.has.common, 12.1.0.1.0...
RollbackSession removing interim patch '17077442' from inventory
OPatch back to application of the patch '19849140' after auto-rollback.
Patching component oracle.crs, 12.1.0.1.0...
Patching component oracle.has.db, 12.1.0.1.0...
Patching component oracle.has.common, 12.1.0.1.0...
Verifying the update...
Patch 19849140 successfully applied
Log file location: /u01/app/121/grid/cfgtoollogs/opatch/opatch2015-01-23_12-25-48PM_1.log
OPatch succeeded.

Verify OUI inventory
[grid@gract2 ~]$ $GRID_HOME//OPatch/opatch lsinventory
--------------------------------------------------------------------------------
Installed Top-level Products (1): 
Oracle Grid Infrastructure 12c                                       12.1.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch  19849140     : applied on Fri Jan 23 15:52:12 CET 2015
Unique Patch ID:  18183131
Patch description:  "Grid Infrastructure Patch Set Update : 12.1.0.1.1 (HAS Component)"
   Created on 23 Oct 2014, 08:32:20 hrs PST8PDT
   Bugs fixed:
     16505840, 16505255, 16505717, 16505617, 16399322, 16390989, 17486244
     16168869, 16444109, 16505361, 13866165, 16505763, 16208257, 16904822
     17299876, 16246222, 16505540, 16505214, 15936039, 16580269, 16838292
     16505449, 16801843, 16309853, 16505395, 17507349, 17475155, 16493242
     17039197, 16196609, 18045611, 17463260, 17263488, 16505667, 15970176
     16488665, 16670327, 17551223
...
Patch level status of Cluster nodes :
Patch level status of Cluster nodes :
 Patching Level              Nodes
 --------------              -----
 3174741718                  gract2,gract1
  482231859                   gract3
--> Here Node gract1 and gract2 are ready patched where gract3 still need to be patched !

 

Apply the DB patch

[oracle@gract2 ~]$  $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME 
                     -local /media/sf_kits/patches/12105/19849140/19849140
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121/racdb
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/121/racdb/oraInst.loc
OPatch version    : 12.1.0.1.5
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/121/racdb/cfgtoollogs/opatch/opatch2015-01-23_16-30-11PM_1.log

Applying interim patch '19849140' to OH '/u01/app/oracle/product/121/racdb'
Verifying environment and performing prerequisite checks...
Patch 19849140: Optional component(s) missing : [ oracle.crs, 12.1.0.1.0 ] 
Interim patch 19849140 is a superset of the patch(es) [  17077442 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/121/racdb')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Rolling back interim patch '17077442' from OH '/u01/app/oracle/product/121/racdb'
Patching component oracle.has.db, 12.1.0.1.0...
Patching component oracle.has.common, 12.1.0.1.0...
RollbackSession removing interim patch '17077442' from inventory
OPatch back to application of the patch '19849140' after auto-rollback.
Patching component oracle.has.db, 12.1.0.1.0...
Patching component oracle.has.common, 12.1.0.1.0...
Verifying the update...
Patch 19849140 successfully applied
Log file location: /u01/app/oracle/product/121/racdb/cfgtoollogs/opatch/opatch2015-01-23_16-30-11PM_1.log
OPatch succeeded.

Run the post script for GRID

As root user execute:
# $GRID_HOME/rdbms/install/rootadd_rdbms.sh
# $GRID_HOME/crs/install/rootcrs.pl -postpatch
Using configuration parameter file: /u01/app/121/grid/crs/install/crsconfig_params
..

Verify the  RAC Node patch level
[oracle@gract3 ~]$   $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.5
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/121/racdb
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/121/racdb/oraInst.loc
OPatch version    : 12.1.0.1.5
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/121/racdb/cfgtoollogs/opatch/opatch2015-01-23_17-59-49PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/121/racdb/cfgtoollogs/opatch/lsinv/lsinventory2015-01-23_17-59-49PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1): 
Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch  19849140     : applied on Fri Jan 23 17:41:28 CET 2015
Unique Patch ID:  18183131
Patch description:  "Grid Infrastructure Patch Set Update : 12.1.0.1.1 (HAS Component)"
   Created on 23 Oct 2014, 08:32:20 hrs PST8PDT
   Bugs fixed:
     16505840, 16505255, 16505717, 16505617, 16399322, 16390989, 17486244
     16168869, 16444109, 16505361, 13866165, 16505763, 16208257, 16904822
     17299876, 16246222, 16505540, 16505214, 15936039, 16580269, 16838292
     16505449, 16801843, 16309853, 16505395, 17507349, 17475155, 16493242
     17039197, 16196609, 18045611, 17463260, 17263488, 16505667, 15970176
     16488665, 16670327, 17551223
Using configuration parameter file: /u01/app/121/grid/crs/install/crsconfig_params

....
Rac system comprising of multiple nodes
  Local node = gract3
  Remote node = gract1
  Remote node = gract2


Restart the CRS / database and login into the local instance 
root@gract2 Desktop]# su - oracle
-> Active ORACLE_SID:   ERP_1
[oracle@gract2 ~]$ 
[oracle@gract2 ~]$ sqlplus / as sysdba
SQL>  select host_name, instance_name from v$instance;
HOST_NAME               INSTANCE_NAME
------------------------------ ----------------
gract2.example.com           ERP_1

Repeat now all above steps for each RAC node !!

Run the datapatch tool for each Oracle Database

  
ORACLE_SID=ERP_1    
[oracle@gract2 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@gract2 OPatch]$ ./datapatch -verbose

ORACLE_SID=dw_1
[oracle@gract2 OPatch]$ cd $ORACLE_HOME/OPatch
[oracle@gract2 OPatch]$ ./datapatch -verbose

For potential problems runing datapatch you may read the following article

Reference

One thought on “Manually applying CW Patch ( 12.1.0.1.5 )”

  1. Hi,

    I need to apply this patch on my rac standby but I don’t know how to do it, I don’t understand the documentation on how to run it on the standby server, can you give me a hint?
    Oracle Clusterware 18 Release (18.3.0.0.180717OCWRU)
    Patch for Bug# 28553832 for Linux-x86-64 platform

Leave a Reply

Your email address will not be published. Required fields are marked *