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:
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:
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:
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:
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:
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 |
Oracle database patching
Critical Patch Updates 2011
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. |
1-1 of 1