Installation of PSU 11.2.0.3.8 – patch 17272731 – on top of OEL 6.4

Install newest Opatch version

Install Opatch for RDBMS instance
$id  
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),506(asmdba),54322(dba)
$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11203/racdb
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.

Install Opatch for GRID instance
$ id
uid=501(grid) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),504(asmadmin),506(asmdba),507(asmoper),54322(dba)
$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d /u01/app/11203/grid
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.
--> Repeat opatch installation for all remaining  instances

Create and verify OCM Installation Response file

$  cd $GRID_HOME/OPatch
$ $GRID_HOME/OPatch/ocm/bin/emocmrsp
OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates.  All rights reserved.
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
The OCM configuration response file (ocm.rsp) was successfully created.
$ ls -l $GRID_HOME/OPatch/ocm.rsp
-rw-r--r-- 1 grid oinstall 621 Jan 10 18:57 /u01/app/11203/grid/OPatch/ocm.rsp
--> Repeat OCM configuration  for all remaining  instances

Validation of Oracle Inventory

Before beginning patch application, check the consistency of inventory information for GI home and each database home to be patched.
Run the following command as respective Oracle home owner to check the consistency.

Validate GI home:
$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/11203/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11203/grid/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
..
Rac system comprising of multiple nodes
  local node = grac33
  Remote node = grac31
  Remote node = grac32
--------------------------------------------------------------------------------
OPatch succeeded.

Validate RDBMS home:
$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),500(vboxsf),506(asmdba),54322(dba)
$  $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME 
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11203/racdb
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11203/racdb/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.3.0
..
Rac system comprising of multiple nodes
  Local node = grac33
  Remote node = grac31
  Remote node = grac32
--------------------------------------------------------------------------------
OPatch succeeded.
--> Repeat OPatch  validation for GI and RDBMS on all remaining instances

Stop EM console

$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://grac31.example.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
...  Stopped.

One-off Patch Conflict Detection and Resolution

If you are installing DB PSU version 11.2.0.2.7 or later, including all 11.2.0.3, 11.2.0.4 and 12.1.0.1 onwards, 
then these PSU releases use composite patching. With composite patching the patch version that you need to resolve 
a conflict may be lower than the DB PSU version that you are installing. You are advised to read Note:1376691.1 for 
details of composite patches before investigating conflicts on these releases in order to understand why a lower version 
patch might be applicable. 
-->For further details check PSU readme

Patching Oracle RAC Database Homes and GI Together

Verify database status
$  srvctl  status database -d grac3
Instance grac31 is running on node grac31
Instance grac32 is running on node grac32
Instance grac33 is running on node grac33

Case 1: GI Home and the Database Homes that are not shared and ACFS file system is not configured.
As root user, execute the following command on each node of the cluster:
# /u01/app/11203/grid/OPatch/opatch auto  /media/sf_patches/p17272731_112030_Linux-x86-64 
  -ocmrf  /u01/app/11203/grid/OPatch/ocm.rsp
Executing /u01/app/11203/grid/perl/bin/perl /u01/app/11203/grid/OPatch/crs/patch11203.pl 
   -patchdir /media/sf_patches -patchn p17272731_112030_Linux-x86-64 -ocmrf /u01/app/11203/grid/OPatch/ocm.rsp 
   -paramfile /u01/app/11203/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11203/grid/cfgtoollogs/opatchauto2014-01-10_19-07-50.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11203/grid/cfgtoollogs/opatchauto2014-01-10_19-07-50.report.log
2014-01-10 19:07:50: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11203/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11203/racdb ...
Stopped RAC /u01/app/oracle/product/11203/racdb successfully
patch /media/sf_patches/p17272731_112030_Linux-x86-64/17076717/custom/server/17076717  apply successful for home  /u01/app/oracle/product/11203/racdb 
patch /media/sf_patches/p17272731_112030_Linux-x86-64/16902043  apply successful for home  /u01/app/oracle/product/11203/racdb 
Stopping CRS...
Stopped CRS successfully
patch /media/sf_patches/p17272731_112030_Linux-x86-64/17076717  apply successful for home  /u01/app/11203/grid 
patch /media/sf_patches/p17272731_112030_Linux-x86-64/16902043  apply successful for home  /u01/app/11203/grid 
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11203/racdb ...
Started RAC /u01/app/oracle/product/11203/racdb successfully

--> Repeat the above opatch auto command on the remaining notes

Applying Conflict Resolution Patches

Apply the patch conflict resolution one-off patches that were determined to be needed when you performed the steps 
 "One-off Patch Conflict Detection and Resolution".

Loading Modified SQL Files into the Database

 The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node.
For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. 
Connect as SYSDBA and run the catbundle.sql script as follows:
    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 in the dba_registry_history view by a row associated with bundle series PSU.
    For information about the catbundle.sql script, see My Oracle Support 
       Document 605795.1 Introduction to Oracle Database catbundle.sql.
    Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
    catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
    catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log
    where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, see Section 3, "Known Issues".

Upgrade Oracle Recovery Manager Catalog

If you are using the Oracle Recovery Manager, the catalog needs to be upgraded. Enter the following command to upgrade it:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

Verify PSU patch installations

 
Grid Home:
$ $GRID_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
...
Interim patches (2) :
Patch  16902043     : applied on Fri Jan 10 19:35:05 CET 2014
Unique Patch ID:  16676143
Patch description:  "Database Patch Set Update : 11.2.0.3.8 (16902043)"
   Created on 24 Sep 2013, 23:20:58 hrs PST8PDT
Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
...
Patch  17076717     : applied on Fri Jan 10 19:28:29 CET 2014
Unique Patch ID:  16721032
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components)"
   Created on 11 Oct 2013, 02:52:50 hrs PST8PDT
   Bugs fixedd
..
Rac system comprising of multiple nodes
  Local node = grac31
  Remote node = grac32
  Remote node = grac33

RDBMS Home:
$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
...
Interim patches (2) :
 16902043     : applied on Sat Jan 11 09:42:17 CET 2014
Unique Patch ID:  16676143
Patch description:  "Database Patch Set Update : 11.2.0.3.8 (16902043)"
   Created on 24 Sep 2013, 23:20:58 hrs PST8PDT
Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
...
Patch  17076717     : applied on Sat Jan 11 09:27:39 CET 2014
Unique Patch ID:  16721032
Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components)"
..
Rac system comprising of multiple nodes
  Local node = grac33
  Remote node = grac31
  Remote node = grac32

Opatch auto to generating a Report file with 30 steps to install PSU 11.2.0.3.8.
The log file shows even more details.

One thought on “Installation of PSU 11.2.0.3.8 – patch 17272731 – on top of OEL 6.4”

Leave a Reply

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