Table of Contents
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.
KID YOURE A BEAST