Critical Patch Update Note
Release 10.2.0.5 for UNIX
Released: July 19, 2011
This document is accurate at the time of release. For changes, terminal Critical Patch Update plans, and additional information regarding CPUJul2011, see these related documents that are available at My Oracle Support (http://support.oracle.com/):
Note 1323616.1 Patch Set Update and Critical Patch Update July 2011 Availability Document
Note 1323599.1 Critical Patch Update July 2011 Oracle Database Known Issues
This document includes the following sections:
You should administer one Oracle product, one Oracle home at a time, for its particular Critical Patch Update July 2011 (CPUJul2011) patch. Each Oracle home will have its own requirements.
Refer to My Oracle Support Note 1323616.1 Patch Set Update and Critical Patch Update July 2011 Availability Document to determine the order of applying CPU patches.
Critical patch update (CPU) 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 the CPUJul2011 patches. However, you must be on the stated patch set level for a given product home before applying the CPUJul2011 patches for that release.
Table 1 describes installation types and CPU applicability. For each installation type, it indicates the most recent CPU 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 CPU is listed, then apply that CPU or any later CPU patch to be current with security fixes.
Table 1 Installation Types and CPU Applicability
| Installation Type | Latest CPU with Security Fixes |
|---|---|
|
Server homes |
CPUJul2011 |
|
Client-Only Installations |
CPUJul2011 |
|
Instant Client Installations |
None (The Instant Client installation is not the same as the client-only Installation. For additional information about Instant Client installations, see Oracle Database Concepts.) |
|
ASM (Automatic Storage Management) homes |
CPUApr2011 for certain configurations. See My Oracle Support Note: 1313771.1 TCPS configurations pertaining to the April 2011 CPU and PSU Patches for further information. |
|
CRS (Cluster Ready Services) homes |
None |
Components patched by this Critical Patch Update:
Oracle Database
This section includes the following sections:
Section 3.2, "Patch Installation Instructions for Oracle Database Release 10.2.0.5"
Section 3.3, "Patch Deinstallation Instructions for Oracle Database Release 10.2.0.5"
You must use the OPatch 10.2 version 10.2.0.5.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch 10.2, which is available for download from My Oracle Support patch 6880880 by selecting the 10.2.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Note 293369.1 OPatch documentation list.
N-apply CPUs are cumulative patches. For further information, refer to My Oracle Support Note 438314.1 Critical Patch Update - Introduction to Database n-Apply CPU Patches.
An n-apply CPU 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 CPU. 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 Note 835682.1, which documents the mapping of molecules to security vulnerabilities.
Select one of the following options:
Option 1: Resolve patch conflicts and install CPU together
File an SR for the merge request indicating all patches that conflict with the CPU as reported by OPatch.
Install the merge patches when they become available.
Install the CPU patch.
Option 2: Perform a partial installation of the CPU and resolve the conflicts later
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 CPU installation.
File an SR for the merge request indicating all patches that conflict with the CPU as reported by OPatch.
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.
These instructions are for both non-RAC environments and RAC environments.
Follow these steps:
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 Note 278641.1.
If you are patching an ASM instance, shut down all Oracle Database instances that use this ASM instance. (To see which Oracle Database instances are connected to this ASM instance, query the V$ASM_CLIENT view.)
Do one of the following, depending on whether this is a RAC environment:
If this is a RAC environment, choose one of the patch installation methods provided by OPatch (rolling, all node, or minimum downtime), and shutdown instances and listeners as appropriate for the installation method selected.
This CPU patch is rolling RAC installable. Refer to My Oracle Support Note 244241.1 Rolling Patch - OPatch Support for RAC.
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.
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
Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
unzip p12419258_10205_<platform>.zip
cd 12419258
opatch napply -skip_subset -skip_duplicate
Should OPatch return conflicts or subsets, refer to Section 3.1.1, "n-Apply CPUs and Patch Conflict Checking" for additional options.
If there are errors, refer to Section 4, "Known Issues".
Do not perform the operations in this section on ASM instances. However, if you shut down ASM as part of applying the CPU, you must start ASM instances before you can perform any of the actions in this section on any database instances.
After installing the patch, perform the following action:
Load modified SQL files into the database, as explained in Section 3.2.2.1.
The following steps load modified SQL files into the database. For a 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 cpu apply SQL> @utlrp.sql 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.
Check the following log files in $ORACLE_HOME/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".
These instructions are for a database that is created or upgraded after the installation of CPUJul2011.
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
Cloning a database that was created by either of the two preceding methods, and if Section 3.2.2.1, "Loading Modified SQL Files into the Database" were not executed after CPUJul2011 was applied
Upgraded databases do not require any post-installation steps.
These instructions are for both Non-RAC environments and RAC environments.
Section 3.3.1, "Patch Deinstallation Instructions for a Non-RAC Environment"
Section 3.3.2, "Post Deinstallation Instructions for a Non-RAC Environment"
Section 3.3.3, "Patch Deinstallation Instructions for a RAC Environment"
Section 3.3.4, "Post Deinstallation Instructions for a RAC Environment"
Follow these steps:
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 CPU.
Shut down all instances and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administrator's Guide.
Run the OPatch utility using the specified rollback argument to rollback all molecule patches included in CPUJul2011. 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/CPUJul2011/rollback_all.lst
If you have applied CPUJul2011 on top of a previous CPU, you may instead want to rollback only the molecule patches that are new in CPUJul2011. To do so, use the following command:
opatch nrollback -idFile $ORACLE_HOME/cpu/CPUJul2011/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.
For information on the content of molecules when doing a rollback of CPUJul2011, refer to My Oracle Support Note 1323607.1 "Critical Patch Update July 2011 Database Patch Security Vulnerability Molecule Mapping.
If there are errors, refer to Section 4, "Known Issues".
Follow these steps:
Start all database instances running from the Oracle home. (For more information, see Oracle Database Administrator's Guide.)
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> @utlrp.sql
SQL> QUIT
In a RAC environment, the name of the rollback script will have the format catbundle_CPU_<database SID PREFIX>_ROLLBACK.sql.
Check the log file for any errors. The log file is found in $ORACLE_HOME/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".
Follow these steps for each node in the cluster, one node at a time:
Shut down the instance on the node. (Shut down all RDBMS instances before any ASM instances.)
Roll back the patch on the node.
Run the OPatch utility using the specified rollback argument to rollback all molecule patches included in CPUJul2011. 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/CPUJul2011/rollback_all.lst -local
If you have applied CPUJul2011 on top of a previous CPU, you may instead want to rollback only the molecule patches that are new in CPUJul2011. To do so, use the following command:
opatch nrollback -idFile $ORACLE_HOME/cpu/CPUJul2011/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.
For information on the content of molecules when doing a rollback of CPUJul2011, refer to My Oracle Support Note 1323607.1 "Critical Patch Update July 2011 Database Patch Security Vulnerability Molecule Mapping.
If there are errors, refer to Section 4, "Known Issues".
Start the instance on the node. Depending on the type of home, enter the following commands or command.
For ASM homes:
srvctl start listener srvctl start asm srvctl start instance
For RDBMS (non-ASM) homes:
srvctl start instance
Follow the instructions listed in Section Section 3.3.2, "Post Deinstallation Instructions for a Non-RAC Environment" only on the node for which the steps in Section 3.2.2.1, "Loading Modified SQL Files into the Database" were executed during the patch application.
All other instances can be started and accessed as usual while you are executing the deinstallation steps.
For information about OPatch issues, see My Oracle Support Note 293369.1 OPatch documentation list.
For issues documented after the release of this CPU, see My Oracle Support Note 1323616.1 Critical Patch Update July 2011 Oracle Database Known Issues.
Other known issues are as follows.
The following ignorable errors may be encountered while running the catbundle.sql script or its rollback script:
ORA-29809: cannot drop an operator with dependent objects ORA-29931: specified association does not exist ORA-29830: operator does not exist ORA-00942: table or view does not exist ORA-00955: name is already used by an existing object ORA-01430: column being added already exists in table ORA-01432: public synonym to be dropped does not exist ORA-01434: private synonym to be dropped does not exist ORA-01435: user does not exist ORA-01917: user or role 'XDB' does not exist ORA-01920: user name '<user-name>' conflicts with another user or role name ORA-01921: role name '<role name>' conflicts with another user or role name ORA-01952: system privileges not granted to 'WKSYS' ORA-02303: cannot drop or replace a type with type or table dependents ORA-02443: Cannot drop constraint - nonexistent constraint ORA-04043: object <object-name> does not exist ORA-29832: cannot drop or replace an indextype with dependent indexes ORA-29844: duplicate operator name specified ORA-14452: attempt to create, alter or drop an index on temporary table already in use ORA-06512: at line <line number>. If this error follow any of above errors, then can be safely ignored. ORA-01927: cannot REVOKE privileges you did not grant
The following documents are references for this patch.
Note 293369.1 OPatch documentation list
Note 360870.1 Impact of Java Security Vulnerabilities on Oracle Products
Note 468959.1 Enterprise Manager Grid Control Known Issues
This patch includes the following molecules:
9963497 - DB-10.2.0.5-MOLECULE-001-CPUOCT2010
10327179 - DB-10.2.0.5-MOLECULE-002-CPUJAN2010
10327190 - DB-10.2.0.5-MOLECULE-003-CPUAPR2011
11792865 - DB-10.2.0.5-MOLECULE-004-CPUAPR2011
12551700 - DB-10.2.0.5-MOLECULE-005-CPUJUL2011
12551701 - DB-10.2.0.5-MOLECULE-006-CPUJUL2011
12551702 - DB-10.2.0.5-MOLECULE-007-CPUJUL2011
12551703 - DB-10.2.0.5-MOLECULE-008-CPUJUL2011
12551704 - DB-10.2.0.5-MOLECULE-009-CPUJUL2011
12551705 - DB-10.2.0.5-MOLECULE-010-CPUJUL2011
12551706 - DB-10.2.0.5-MOLECULE-011-CPUJUL2011
12551707 - DB-10.2.0.5-MOLECULE-012-CPUJUL2011
12551708 - DB-10.2.0.5-MOLECULE-013-CPUJUL2011
12551710 - DB-10.2.0.5-MOLECULE-014-CPUJUL2011
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 Critical Patch Update Note Release 10.2.0.5 for UNIX
Copyright © 2006, 2011, 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.