Skip Headers

Oracle® Database

Security Patch Update Note

Release 11.2.0.2 for UNIX

 

Released: April 16, 2013

This document is accurate at the time of release. For changes, terminal Critical Patch Update plans, and additional information regarding CPUApr2013, see these related documents that are available at My Oracle Support (http://support.oracle.com/):

This document includes the following sections:

1 Getting Started

You should administer one Oracle product, one Oracle home at a time, for its particular Security Patch Update (SPU) April 2013 patch. Each Oracle home will have its own requirements.

Refer to My Oracle Support Document 1525152.1 Patch Set Update and Critical Patch Update April 2013 Availability Document to determine the order of applying CPU patches.

2 Patch Information

Starting from October 2012 onwards, Critical Patch Update (CPU) patches will now be called Security Patch Update (SPU) patches. The patches will still be released as part of the overall Oracle Critical Patch Update (CPU) Program. See My Oracle Support Document 1430923.1 - New Patch Nomenclature for Oracle Products.

Security Patch Update (SPU) patches are cumulative, which means fixes from previous Oracle security alerts and critical patch updates are included. It is not required to have previous security patches applied before applying this SPU patch. However, you must be on the stated patch set level for a given product home before applying the SPU patches for that release.

Table 1 describes installation types and SPU applicability. For each installation type, it indicates the most recent SPU patch to include new security fixes that are pertinent to that installation type. If there are no security fixes to be applied to an installation type, then "None" is indicated. If a specific SPU is listed, then apply that SPU or any later SPU patch to be current with security fixes.

Table 1 Installation Types and SPU Applicability

Installation Type Latest SPU with Security Fixes

Server homes

SPU released for CPUApr2013 program

Client-Only Installations

SPU released for CPUOct2012 to address CVE-2012-3137 and CVE-2012-3151.

Prior to installing this SPU you MUST read My Oracle Support Document: 1493990.1 - Patching for CVE-2012-3137.

Instant Client Installations

SPU released for CPUOct2012 to address CVE-2012-3137 for certain configurations.

Prior to installing this SPU you MUST read My Oracle Support Document: 1493990.1 - Patching for CVE-2012-3137.

(The Instant Client installation is not the same as the client-only Installation. For additional information about Instant Client installations, see Oracle Call Interface Programmer's Guide.)


Components patched by this Security Patch Update:

  • Oracle Database

3 Patch Installation Procedures for Oracle Database Release 11.2.0.2

This section includes the following sections:

3.1 OPatch Utility Information

You must use the OPatch utility version 11.2.0.1.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.

For information about OPatch documentation, including any known issues, see My Oracle Support Document 293369.1 OPatch documentation list.

3.1.1 n-Apply SPUs and Patch Conflict Checking

N-apply SPUs are cumulative patches. For further information, refer to My Oracle Support Document 438314.1 Critical Patch Update - Introduction to Database n-Apply CPU Patches.

An n-apply SPU patch consists of groups of security fixes, where each group is called a molecule. Each molecule is an independent patch and does not conflict with any of the other molecule patches within the SPU. Prior to the patch installation, the following checks are performed for each molecule patch being installed:

  • Conflicts with other patches

  • Subset patches (patch to be installed is a subset of an existing patch in the Oracle Home)

  • Duplicates (patch to be installed is the same as an existing patch in the Oracle Home)

If a conflict is found, the installation will stop and you will be notified to file a merge request for the conflicting patches. To assist you in determining the best course of action when conflicts are reported, refer to My Oracle Support Document 835682.1, which documents the mapping of molecules to security vulnerabilities.

Select one of the following options:

  • Option 1: Resolve patch conflicts and install SPU together

    1. File an SR for the merge request indicating all patches that conflict with the SPU as reported by OPatch.

    2. Install the merge patches when they become available.

    3. Install the SPU patch.

  • Option 2: Perform a partial installation of the SPU and resolve the conflicts later

    1. At the conclusion of the aborted installation, OPatch returns the necessary command to install all molecules that do not conflict with patches in the Oracle home. Run this command to perform a partial SPU installation.

    2. File an SR for the merge request indicating all patches that conflict with the SPU as reported by OPatch.

    3. Install the merge patches when they become available.

If a subset or duplicate is found, the patch installation will continue. The subset and duplicate patches will not be installed as they are already installed.

3.2 Patch Installation Instructions for Oracle Database Release 11.2.0.2

These instructions are for all Oracle Database installations.

3.2.1 Patch Installation Instructions

Follow these steps:

  1. If you are using a Data Guard Physical Standby database, you must install this patch on both the primary database and the physical standby database, as described by My Oracle Support Document 278641.1.

  2. If this is a RAC environment, install the SPU patch using the OPatch rolling (no downtime) installation method as the SPU patch is rolling RAC installable. Refer to My Oracle Support Document 244241.1 Rolling Patch - OPatch Support for RAC.

  3. If this is not a RAC environment, shut down all instances and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administrator's Guide.

  4. Ensure that the $PATH has the following executables: make, ar, ld, and nm.

    The location of these executables depends on your operating system. On many operating systems, they are located in /usr/ccs/bin, in which case you can set your PATH as follows:

    export PATH=$PATH:/usr/ccs/bin
    
  5. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

    unzip p16294412_112020_<platform>.zip
    cd 16294412
    opatch napply -skip_subset -skip_duplicate
    

    Should OPatch return conflicts or subsets, refer to Section 3.1.1, "n-Apply SPUs and Patch Conflict Checking" for additional options.

  6. If there are errors, refer to Section 4, "Known Issues".

3.2.2 Patch Post-Installation Instructions

After installing the patch, load modified SQL files into the database, as explained in Section 3.2.2.1.

3.2.2.1 Loading Modified SQL Files into the Database

The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.

  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:

    cd $ORACLE_HOME/rdbms/admin
    sqlplus /nolog
    SQL> CONNECT / AS SYSDBA
    SQL> STARTUP
    SQL> @catbundle.sql cpu apply
    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 Document 605795.1 Introduction to Oracle Database catbundle.sql.

  2. Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

    catbundle_CPU_<database SID>_APPLY_<TIMESTAMP>.log
    catbundle_CPU_<database SID>_GENERATE_<TIMESTAMP>.log
    

    where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, refer to Section 4, "Known Issues".

3.2.3 Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of SPU in the Oracle Home

These instructions are for a database that is created or upgraded after the installation of this SPU patch.

You must execute the steps in Section 3.2.2.1, "Loading Modified SQL Files into the Database" for any new database only if it was created by any of the following methods:

  • Using DBCA (Database Configuration Assistant) to select a sample database (General, Data Warehouse, Transaction Processing)

  • Using a script that was created by DBCA that creates a database from a sample database

There are no actions required for databases that have been upgraded.

3.3 Patch Deinstallation Instructions for Oracle Database Release 11.2.0.2

These instructions apply if you need to deinstall the patch.

3.3.1 Patch Deinstallation Instructions for a Non-RAC Environment

Follow these steps:

  1. Verify that an $ORACLE_HOME/rdbms/admin/catbundle_CPU_<database SID>_ROLLBACK.sql file exists for each database associated with this ORACLE_HOME. If this is not the case, you must execute the steps in Section 3.2.2.1, "Loading Modified SQL Files into the Database" against the database before deinstalling the SPU.

  2. Shut down all instances and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administrator's Guide.

  3. Run the OPatch utility using the specified rollback argument to rollback all molecule patches included in this SPU. If a molecule is not installed in the Oracle Home, the rollback will ignore it. If a molecule is installed as part of a merge patch, it will not be rolled back. If it is desired to rollback merge patches that have been applied to your Oracle Home, the rollback needs to be issued separately.

    opatch nrollback -idFile $ORACLE_HOME/cpu/CPUApr2013/rollback_all.lst
    

    If you have applied this SPU on top of a previous SPU, you may instead want to rollback only the molecule patches that are new in this SPU. To do so, use the following command:

    opatch nrollback -idFile $ORACLE_HOME/cpu/CPUApr2013/rollback_new.lst
    

    You may also rollback individual molecules or a list of molecules, as needed. Refer to the OPatch documentation on the nrollback command.

  4. For information on the content of molecules when doing a rollback of this SPU, refer to My Oracle Support Document 1523827.1 "Critical Patch Update April 2013 Database Patch Security Vulnerability Molecule Mapping.

  5. If there are errors, refer to Section 4, "Known Issues".

3.3.2 Patch Post-Deinstallation Instructions for a Non-RAC Environment

Follow these steps:

  1. Start all database instances running from the Oracle home. (For more information, see Oracle Database Administrator's Guide.)

  2. For each database instance running out of the ORACLE_HOME, connect to the database using SQL*Plus as SYSDBA and run the rollback script as follows:

    cd $ORACLE_HOME/rdbms/admin
    sqlplus /nolog
    SQL> CONNECT / AS SYSDBA
    SQL> STARTUP
    SQL> @catbundle_CPU_<database SID>_ROLLBACK.sql
    SQL> QUIT
    
  3. Check the log file for any errors. The log file is found in $ORACLE_BASE/cfgtoollogs/catbundle and is named catbundle_CPU_<database SID>_ROLLBACK_<TIMESTAMP>.log where TIMESTAMP is of the form YYYYMMMDD_HH_MM_SS. If there are errors, refer to Section 4, "Known Issues".

3.3.3 Patch Deinstallation Instructions for a RAC Environment

Follow these steps:

  1. Shut down the instance on one node.

  2. Shut down all nodeapps services on the node in step 1:

    srvctl stop nodeapps -n <node-name>
    
  3. Roll back the patch on the node in step 1.

    Run the OPatch utility using the specified rollback argument to rollback all molecule patches included in this SPU. If a molecule is not installed in the Oracle Home, the rollback will ignore it. If a molecule is installed as part of a merge patch, it will not be rolled back. If it is desired to rollback merge patches that have been applied to your Oracle Home, the rollback needs to be issued separately.

    opatch nrollback -idFile $ORACLE_HOME/cpu/CPUApr2013/rollback_all.lst -local
    

    If you have applied this SPU on top of a previous SPU, you may instead want to rollback only the molecule patches that are new in this SPU. To do so, use the following command:

    opatch nrollback -idFile $ORACLE_HOME/cpu/CPUApr2013/rollback_new.lst -local
    

    You may also rollback individual molecules or a list of molecules, as needed. Refer to the OPatch documentation on the nrollback command.

    If there are errors, refer to Section 4, "Known Issues".

  4. Start all nodeapps services on the node in step 1:

    srvctl start nodeapps -n <node-name>
    
  5. Start the instance on the node in step 1.

  6. Repeat steps 1-5 on all the remaining nodes in the cluster.

  7. For information on the content of molecules when doing a rollback of this SPU, refer to My Oracle Support Document 1523827.1 "Critical Patch Update April 2013 Database Patch Security Vulnerability Molecule Mapping".

3.3.4 Patch Post-Deinstallation Instructions for a RAC Environment

Follow these steps:

  1. Go to the node that you used for the instructions in Section 3.3.1, "Patch Deinstallation Instructions for a Non-RAC Environment".

  2. Follow the same set of instructions listed in Section 3.3.2, "Patch Post-Deinstallation Instructions for a Non-RAC Environment".

    Users can start and access all other instances as usual while you are executing the steps from this instance.

  3. Restart all nodeapps services on all nodes, one at a time:

     srvctl start nodeapps -n <node-name>
    
  4. Restart instances on all nodes.

You do not need to run post-deinstallation steps on other nodes. (That is, perform steps 1 and 2 only on the node selected in step 1, and perform steps 3 and 4 only once.)

4 Known Issues

For information about OPatch issues, see My Oracle Support Document 293369.1 OPatch documentation list.

For issues documented after the release of this SPU, see My Oracle Support Document 1523844.1 Critical Patch Update April 2013 Oracle Database Known Issues.

5 References

The following documents are references for this patch.

Document 293369.1 OPatch documentation list

Document 360870.1 Impact of Java Security Vulnerabilities on Oracle Products

Document 468959.1 Enterprise Manager Grid Control Known Issues

6 Bugs Fixed by This Patch

This patch includes the following bug fixes.

SPU 11.2.0.2 for April 2013 contains all molecules previously released in previous SPU versions and the following new molecules:


16303114 - DB-11.2.0.2-MOLECULE-049-CPUAPR2013

16303115 - DB-11.2.0.2-MOLECULE-050-CPUAPR2013

16303116 - DB-11.2.0.2-MOLECULE-051-CPUAPR2013

16303117 - DB-11.2.0.2-MOLECULE-052-CPUAPR2013

16303118 - DB-11.2.0.2-MOLECULE-053-CPUAPR2013

The preceding CPUApr2013 molecules include the following bug fixes:

Generic


14841812 - Fix for bug 14841812

Oracle Security


13596521 - Fix for bug 13596521

Oracle Spatial


13561951 - Fix for bug 13561951

SQL*Net


14841558 - Fix for bug 14841558

Workspace Manager


14220725 - Fix for bug 14220725

7 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/us/corporate/accessibility/index.html.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.


Oracle Database Security Patch Update Note Release 11.2.0.2 for UNIX

Copyright © 2006, 2013, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark licensed through X/Open Company, Ltd.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.