Patch Set Notes
11g Release 2 (18.104.22.168) Patch Set 1
1 Patch Set Overview
Starting with the 22.214.171.124 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install Oracle Database 11g Release 2 (126.96.36.199) before installing Oracle Database 11g Release 2 (188.8.131.52).
Note the following changes with the new patch set packaging:
New installations consist of installing the most recent patch set, rather than installing a base release and then upgrading to a patch release.
Direct upgrades from previous releases to the most recent patch set are supported.
Out-of-place patch set upgrades recommended, in which you install the patch set into a new, separate Oracle home. In-place upgrades are supported, but not recommended.
This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 (184.108.40.206) into the same Oracle home directory by replacing the existing database files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.
If you select In-place upgrade to upgrade Oracle database to the latest version, then you must:
This feature enables you to install Oracle Database 11g Release 2 (220.127.116.11) in a new, separate Oracle home directory. After the installation is complete, the data from the database in the old Oracle home directory is migrated to the database in the new Oracle home directory.
Out-of-place upgrade process is similar to Oracle database upgrade from one version to another and is the recommended type. The benefits of this upgrade type is that the patch set application requires much less downtime, and is safer when the patch set application must be aborted. This upgrade type requires more disk space to accommodate two Oracle home directories simultaneously.
2 Critical Patch Updates and Patch Set Updates
Critical Patch Updates (CPU) and Patch Set Updates (PSU) are proactive quarterly patch releases.
To review the latest Critical Patch Update information for Oracle Database 11g Release 2 (18.104.22.168), visit the Oracle Technology Network Web site at:
To review the latest Patch Set Updates for Oracle Database 11g Release 2 (22.214.171.124), see document 854428.1, Patch Set Updates for Oracle Products on the My Oracle Support (formerly OracleMetaLink) Web site:
To locate document 854428.1:
Log on to My Oracle Support (formerly OracleMetaLink).
Set Article ID as the search source.
Enter 854428.1 in the search field, then click the Search icon.
3 System Requirements
Check your platform-specific installation guide for a list of supported operating systems. Check Certifications on the My Oracle Support (formerly OracleMetaLink) Web site for the latest certification information.
4 Accessing the Latest Version of this Document
This document may be updated after release. To check for updates to this document, see document 880782.1, ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts, on the My Oracle Support (formerly OracleMetaLink) Web site:
To locate document 880782.1:
5 Software Availability
Oracle Database 11g Release 2 (126.96.36.199) is available in the latest media pack. You can also download the software from My Oracle Support (formerly OracleMetaLink) Web site:
To download the software from My Oracle Support:
Installation Type Zip File
Oracle Database (includes Oracle Database and Oracle RAC)
Note: you must download both zip files to install Oracle Database.
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart):
Oracle Database Client :
6 Database Documentation
The latest documentation for Oracle Database 11g Release 2 (11.2) is available on the Oracle Technology Network Web site at
7 Installation and Upgrade
Review Oracle Database Readme and your platform-specific Oracle Database Release Notes before installing Oracle software. For new installations, refer to the appropriate installation guide for the product you are installing.
See "How to Upgrade to Oracle Grid Infrastructure 11g Release 2" in Oracle Grid Infrastructure Installation Guide for details about performing Oracle Clusterware and Oracle Automatic Storage Management upgrades. See Oracle Database Upgrade Guide for complete information about planning and executing Oracle Database upgrades.
Oracle installation guides and release notes for each platform, the readme, and the upgrade guide are available at
8 Known Issues
To review known issues for Oracle Database 11g Release 2 (188.8.131.52), see document 1179474.1, Availability and Known Issues on the My Oracle Support (formerly OracleMetaLink) Web site:
To locate document 1179474.1:
9 List of Bugs Fixed
To check the list of bugs fixed for Oracle Database 11g Release 2 (184.108.40.206), see document 1179583.1, List of Bug Fixes by Problem Type on the My Oracle Support (formerly OracleMetaLink) Web site:
To locate document 1179583.1:
Praparation for database patching
mjbdb01:DEVDB1:/u01/home/oracle $opatch version
Invoking OPatch 220.127.116.11.2
OPatch Version: 18.104.22.168.2
mjbdb01:DEVDB1:/u01/home/oracle $opatch lsinventory
Invoking OPatch 22.214.171.124.2
Oracle Interim Patch Installer version 126.96.36.199.2
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 188.8.131.52.2
OUI version : 184.108.40.206.0
OUI location : /u01/app/oracle/product/11.2.0/dbhome_1/oui
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2011-02-09_18-58-27PM.log
Patch history file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2011-02-09_18-58-27PM.txt
Installed Top-level Products (1):
Oracle Database 11g 220.127.116.11.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 9352237 : applied on Tue Apr 20 20:35:50 GMT 2010
Unique Patch ID: 12345730
Created on 30 Mar 2010, 06:40:56 hrs PST8PDT
8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548
8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974
7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983
9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535
8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705
8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784
8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202
8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328
8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358
9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385
8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237
8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736
Patch Installation instruction
1.shut down all instances and listeners associated with the Oracle home that you are updating.
2.Ensure that the $PATH has the following executables: make, ar, ld, and nm.
3.Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
6.opatch napply -skip_subset -skip_duplicate
Patch post installation instruction
After installing the patch, load modified SQL files into the database
1.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:
4.SQL> CONNECT / AS SYSDBA
6.SQL> @catbundle.sql cpu apply (or run '@?/rdbms/admin/catbundle.sql cpu apply' )
The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series CPU.
For information about the catbundle.sql script, see My Oracle Support Note 605795.1 Introduction to Oracle Database catbundle.sql.
8. Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle for any errors:
9. catbundle_CPU_<database SID>_APPLY_<TIMESTAMP>.log
10. catbundle_CPU_<database SID>_GENERATE_<TIMESTAMP>.log
Oracle database patching
Critical Patch Updates are the primary means of releasing security fixes for Oracle products to customers with valid support contracts. They are released on the Tuesday closest to the 15th day of January, April, July and October. Starting 2011, the scheduled dates for the release of Critical Patch Updates will be on the Tuesday closest to the 17th day of January, April, July and October. The next four dates are:
For this calendar year, Oracle Java SE and Java for Business Critical Patch Updates will be released on the following dates:
A pre-release announcement will be published on the Thursday preceding each CPU release.