Oracle database patching

Patch Set Notes
11g Release 2 (11.2.0.2) Patch Set 1
E15732-03


1 Patch Set Overview

Starting with the 11.2.0.2 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 (11.2.0.1) before installing Oracle Database 11g Release 2 (11.2.0.2).


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.

In-Place Upgrade

This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 (11.2.0.2) 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.

Note:

If you select In-place upgrade to upgrade Oracle database to the latest version, then you must:

  1.     Review "Optionally Performing an In-Place Upgrade (Into the Same Oracle Home)" in Oracle Database Upgrade Guide.
  2.     Take a complete backup of your Oracle home directory before you perform the upgrade.

Out-of-Place Upgrade

This feature enables you to install Oracle Database 11g Release 2 (11.2.0.2) 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 (11.2.0.2), visit the Oracle Technology Network Web site at:

http://www.oracle.com/technology/deploy/security/alerts.htm

To review the latest Patch Set Updates for Oracle Database 11g Release 2 (11.2.0.2), see document 854428.1, Patch Set Updates for Oracle Products on the My Oracle Support (formerly OracleMetaLink) Web site:

https://support.oracle.com

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:
https://support.oracle.com

To locate document 880782.1:

  1.     Log on to My Oracle Support (formerly OracleMetaLink).
  2.     Set Article ID as the search source.
  3.     Enter 880782.1 in the search field, then click the Search icon.

5 Software Availability

Oracle Database 11g Release 2 (11.2.0.2) is available in the latest media pack. You can also download the software from My Oracle Support (formerly OracleMetaLink) Web site:

https://support.oracle.com

To download the software from My Oracle Support:

  1.     Log on to My Oracle Support.
  2.     Click Patches & Updates.
  3.     In the Patch Search section, click the Search tab.
  4.     Enter 10098816 in the patch number field.
  5.     Select a platform to download.
  6.     Click Search.
  7.     In the Patch Search Results page, under Patch Name, click the patch number to display the patch details.
  8.     Click Download.
  9.     From the File Download window, click each file name to download the selected software.
**********************************************************************************************************************************************
    Installation Type     Zip File
    Oracle Database (includes Oracle Database and Oracle RAC)
    Note: you must download both zip files to install Oracle Database.
    
    p10098816_112020_platform_1of7.zip
    p10098816_112020_platform_2of7.zip
    Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart):
    p10098816_112020_platform_3of7.zip
    Oracle Database Client :
    p10098816_112020_platform_4of7.zip
    Oracle Gateways
    p10098816_112020_platform_5of7.zip
    Oracle Examples
     p10098816_112020_platform_6of7.zip
    Deinstall :  
    p10098816_112020_platform_7of7.zip
**********************************************************************************************************************************************
6 Database Documentation

The latest documentation for Oracle Database 11g Release 2 (11.2) is available on the Oracle Technology Network Web site at

http://www.oracle.com/pls/db112/homepage

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

http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

8 Known Issues

To review known issues for Oracle Database 11g Release 2 (11.2.0.2), see document 1179474.1, Availability and Known Issues on the My Oracle Support (formerly OracleMetaLink) Web site:

https://support.oracle.com

To locate document 1179474.1:

  1.     Log on to My Oracle Support (formerly OracleMetaLink).
  2.     Set Article ID as the search source.
  3.     Enter 1179474.1 in the search field, then click the Search icon.

9 List of Bugs Fixed

To check the list of bugs fixed for Oracle Database 11g Release 2 (11.2.0.2), see document 1179583.1, List of Bug Fixes by Problem Type on the My Oracle Support (formerly OracleMetaLink) Web site:

https://support.oracle.com

To locate document 1179583.1:

  1.     Log on to My Oracle Support (formerly OracleMetaLink).
  2.     Set Article ID as the search source.
  3.     Enter 1179583.1 in the search field, then click the Search icon.

Praparation for database patching

mjbdb01:DEVDB1:/u01/home/oracle $opatch version
Invoking OPatch 11.2.0.1.2

OPatch Version: 11.2.0.1.2

OPatch succeeded.

mjbdb01:DEVDB1:/u01/home/oracle $opatch lsinventory
Invoking OPatch 11.2.0.1.2

Oracle Interim Patch Installer version 11.2.0.1.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    : 11.2.0.1.2
OUI version       : 11.2.0.1.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                                                  11.2.0.1.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
   Bugs fixed:
     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

--------------------------------------------------------------------------------

OPatch succeeded.

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:
4.unzip p10249532_112010_<platform>.zip
5.cd 10249532
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:
2.cd $ORACLE_HOME/rdbms/admin
3.sqlplus /nolog
4.SQL> CONNECT / AS SYSDBA
5.SQL> STARTUP
6.SQL> @catbundle.sql cpu apply (or run '@?/rdbms/admin/catbundle.sql cpu apply' )
7.SQL> QUIT

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

@?/rdbms/admin/utlrp.sql

Critical Patch Updates 2011

posted Feb 28, 2011, 12:19 PM by Sachchida Ojha   [ updated Jul 8, 2011, 9:09 AM ]

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:

  • 19 April 2011
  • 19 July 2011
  • 18 October 2011
  • 17 January 2012

For this calendar year, Oracle Java SE and Java for Business Critical Patch Updates will be released on the following dates:

  • 07 June 2011
  • 18 October 2011

A pre-release announcement will be published on the Thursday preceding each CPU release.

1-1 of 1