Oracle Recommended Patches -- Oracle Database [ID 756671.1] | |||||
| |||||
Modified 16-MAY-2011 Type ANNOUNCEMENT Status PUBLISHED |
Oracle Recommended Patches -- Oracle Database
- #TARGET_CONFIGS">Target Configurations
- #PATCH_AVAIL">Patch Availability
- #CURRENT_BUNDLES">Current Recommended Patches
- #r11202">11.2.0.2 Current Recommended Patches
- #r11201">11.2.0.1 Current Recommended Patches
- #r11107">11.1.0.7 Current Recommended Patches
- #r11106">11.1.0.6 Current Recommended Patches
- #r10205">10.2.0.5 Current Recommended Patches
- #r10204">10.2.0.4 Current Recommended Patches
- #r10203">10.2.0.3 Current Recommended Patches
- #CONFLIST_RES">Conflict Resolution
- #ON_REQUEST">On Request
- #KNOWN">Known Issues
- #REF">References
Beginning with release 10.2.0.3, Oracle releases Recommended Patches for Oracle Database. For an introduction to Recommended Patches, see Note:756388.1.
Target Configurations
Recommended Patches are provided for the following target configurations:
- Generic
- Real Application Clusters
- Data Guard
- Exadata
- Ebusiness Suite Certification
Patch Availability
Recommended Patches are released on all platforms at the same time. They are generally available on the following platforms: HP-UX PA-RISC, Solaris Operating System (SPARC 64-Bit), HP-UX Itanium, IBM AIX on POWER Systems (64-Bit), Linux x86 (32-bit), and Linux x86-64.
Oracle provides bundled patches for Microsoft Windows platforms. Recommended patches are included in these bundles rather than as separately downloadable patches. See Note:161549.1 for details of the bundled patches for Microsoft platforms. It is recommended to apply the most current Windows bundle patch .
Patch Set Updates
Document Description Rolling RAC Patch Download Note:11724916.8 11.2.0.2.2 Patch Set Update (PSU) Yes Patch:11724916
Generic
Document Description Rolling RAC Patch Download Note:1321817.1 Mutex waits may cause higher CPU usage in 11.2.0.2.2 PSU / GI PSU Yes Patch:12431716
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:12311357.8 11.2.0.2.2 Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:12311357
Exadata
Document Description Rolling RAC Patch Download Note:888828.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2) - -
EBusiness Suite R11i Certification
Document Description Rolling RAC Patch Download Note:881505.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.2 - -
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:1058763.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.2 - -
11.2.0.1 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:11724930.8 11.2.0.1.5 Patch Set Update (PSU) Yes Patch:11724930
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:9655006.8 11.2.0.1.2 Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:9655006
Exadata
Document Description Rolling RAC Patch Download Note:888828.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2) - -
EBusiness Suite R11i Certification
Document Description Rolling RAC Patch Download Note:1265268.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.1 - -
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:1265232.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.1 - -
11.1.0.7 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:11724936.8 11.1.0.7.7 Patch Set Update (PSU) Yes Patch:11724936
CRS
Document Description Rolling RAC Patch Download Note:11724953.8 11.1.0.7.7 CRS Patch Set Update (CRS PSU) Yes Patch:11724953
Data Guard
Document Description Rolling RAC Patch Download Note:7628357.8 11.1.0.7 Data Guard Broker Recommended Patch Bundle #1 No Patch:7628357
Exadata
Document Description Rolling RAC Patch Download Note:835032.1 Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 1 (11.1) - -
EBusiness Suite R11i Certification
Document Description Rolling RAC Patch Download Note:452783.1 Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.1.0.7 - - Note:7295298.8 Poor Subquery filter order / Queries against ALL_OBJECTS can be slow Yes Patch:7295298 Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531 Note:6530141.8 False ORA-979 can occur on an UPDATE DML Yes Patch:6530141
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:735276.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.1.0.7 - - Note:7684818.8 11.1.0.7 EBusiness Suite R12 Certification Patch Bundle #1 Yes Patch:7684818 Note:7630760.8 HPUX: 11.1.0.7 patch install deletes libskgxp11.a No Patch:7630760 Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531
11.1.0.6 Current Recommended Patches
EBusiness Suite R11i Certification
Document Description Rolling RAC Patch Download Note:9196488.8 PLS-306 executing procedure on 11g from lower version PLSQL client No Patch:9196488 Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531 Note:6972189.8 Invalid package bodies when using _load_without_compile option Yes Patch:6972189 Note:6778860.8 11.1.0.6 EBusiness Suite R11 Certification Patch Bundle #1 No Patch:6778860 Note:6501565.8 Dump under JVM from JIT of Java class compiled with old Java compiler No Patch:6501565
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:7377378.8 11.1.0.6 EBusiness Suite R12 Certification Patch Bundle #1 Yes Patch:7377378 Note:7253531.8 A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte Yes Patch:7253531 Note:6991626.8 Datapump export fails with ORA-39126 / ORA-22813 Yes Patch:6991626 Note:6815733.8 OERI [qctcte1] from cost based transformation with subquery in ORDER BY clause Yes Patch:6815733 Note:6598432.8 ORA-1466 from read-only transaction when client / server in different timezones Yes Patch:6598432 Note:6266400.8 A dump can occur in kokbTabFuncRewrite Yes Patch:6266400
10.2.0.5 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:11724962.8 10.2.0.5.3 Patch Set Update (PSU) Yes Patch:11724962
CRS
Document Description Rolling RAC Patch Download Note:9952245.8 10.2.0.5.2 CRS Patch Set Update (CRS PSU) Yes Patch:9952245
10.2.0.4 Current Recommended Patches
Oracle has introduced Patch Set Updates (PSU) for 10.2.0.4 which include recommended fixes for generic , RAC and DataGuard issues.The PSU should be treated as the recommended patch for these areas - additional recommendations may be listed below under relevant areas.
Please read Note:854428.1 for an introduction to Patch Set Updates.
Patch Set Updates
Document Description Rolling RAC Patch Download Note:11724977.8 10.2.0.4.8 Patch Set Update (PSU) Overlay Yes Patch:11724977 Note:9352164.8 10.2.0.4.4 Patch Set Update (PSU) Yes Patch:9352164
Generic
Document Description Rolling RAC Patch Download Note:9572766.8 Recommended merge fix for bug 6994194 and bug 8830147 Yes Patch:9572766
RAC
Document Description Rolling RAC Patch Download Note:6367097.8 Recommended on HP Itanium: RAC diagnostics can abort the instance (LMS ORA-484) Yes Patch:6367097 Note:6079224.8 Recommended on Linux: RAC ORA-27506 / IPC Send timeout Yes Patch:6079224
CRS
Document Description Rolling RAC Patch Download Note:9294403.8 10.2.0.4.4 CRS Patch Set Update (CRS PSU) Yes Patch:9294403
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:7014646.8 OERI [kkocxj : pjpctx] from complex query Yes Patch:7014646
10.2.0.3 Current Recommended Patches
RAC
Document Description Rolling RAC Patch Download Note:7145055.8 10.2.0.3 RAC Recommended Patch Bundle #2 Yes Patch:7145055
CRS
Document Description Rolling RAC Patch Download Note:7117233.8 10.2.0.3 CRS Recommended Patch Bundle #3 Yes Patch:7117233
Data Guard
Document Description Rolling RAC Patch Download Note:6909784.8 Recommended Merge Fix for bug 6128197 with Data Guard Logical No Patch:6909784 Note:6081556.8 10.2.0.3 Data Guard RMAN Recommended Patch Bundle #1 Yes Patch:6081556 Note:6081550.8 10.2.0.3 Data Guard Logical Recommended Patch Bundle #1 No Patch:6081550 Note:6081547.8 10.2.0.3 Data Guard Physical Recommended Patch Bundle #1 Yes Patch:6081547 Note:6048286.8 10.2.0.3 Data Guard Broker Recommended Patch #1 No Patch:6048286
EBusiness Suite R11i Certification
Document Description Rolling RAC Patch Download Note:6166683.8 Z-Linux: ctxhx missing from 10.2.0.3 Yes Patch:6166683 Note:412271.1 Upgrade to 10.2.0.3 can fail with ORA-600 [22635] Yes Patch:5892355 Note:5871314.8 Pickler fix needed to allow some DB upgrade / downgrade to work Yes Patch:5871314 Note:5257698.8 9idata NLS files missing leading to file handle leak No Patch:5257698
EBusiness Suite R12 Certification
Document Description Rolling RAC Patch Download Note:6319846.8 EBusiness Suite R12 Certification Recommended Patch Bundle Yes Patch:6319846 Note:5240469.8 Linux-X86 64bit: genoccish generates lots of errors No Patch:5240469
Miscellaneous One Off Fixes
Document Description Rolling RAC Patch Download Note:6875865.8 Database instrumentation for OCM Yes Patch:6875865 Note:6869828.8 Recommended Merge Fix of 6122097 and 5903829 Yes Patch:6869828 Note:471479.1 IOT corruption after upgrade from <= 9.2 to >= 10g Yes Patch:6646613 Note:6455161.8 Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild No Patch:6455161 Note:453259.1 OERI[kcrfr_resize2] / cannot recover database No Patch:6128197 Note:453309.1 OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed Yes Patch:6017420 Note:5949701.8 Recommended Merge Fix of 5648872 and 5863277 Yes Patch:5949701 Note:455832.1 Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database No Patch:5933477 Note:5907779.8 Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS) No Patch:5907779 Note:5896963.8 High LGWR CPU and longer "log file sync" with fix for bug 5065930 Yes Patch:5896963 Note:5765958.8 OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL No Patch:5765958 Note:5728380.8 DML may spin under ktspffc searching for space in ASSM segment No Patch:5728380 Note:454464.1 Various dumps / instance crash possible Yes Patch:5605370 Note:5577046.8 ADD or DROP attribute causes UNION query to fail with ORA-1790 Yes Patch:5577046 Note:5514109.8 OERI [kql-hash-collision] / false ORA-955 No Patch:5514109 Note:5364143.8 Bind Peeking is not done upon query reload, Execution Plan changes Yes Patch:5364143 Note:5363584.8 Array insert into table can corrupt redo Yes Patch:5363584 Note:4899479.8 Undo/redo corruption if distributed transactions used No Patch:4899479
Conflict Resolution
If you encounter a patch conflict while installing the Recommended Patches, you need to file a service request (SR) with Oracle Global Support to request a merge patch.Patch conflict resolution is provided using the same mechanism as the database Critical Patch Updates. For more information, see My Oracle Support Note:438314.1, Critical Patch Update - Introduction to Database n-Apply CPU Patches.
On Request
To obtain Recommended Patches for a platform not in the patch availability list, file a service request (SR) with Oracle Global Support. A request may be made at any time. Either the current Recommended Patches or the next Recommended patches for a given target configuration will be provided depending on when the request is received and processed.Known Issues
For Known Issues with any of the Recommended Patches, please click on the Document link in the tables above against the relevant version and target configuration.References
NOTE:756388.1 - Introduction to Recommended PatchesNOTE:438314.1 - Critical Patch Update - Introduction to Database n-Apply CPU Patches
NOTE:161549.1 - Oracle Database Server and Networking Patches for Microsoft Platforms
NOTE:743126.1 - RAC on Windows: How to Apply Oracle Windows Mini Patch Bundles in a Rolling Fashion
Note:847410.5 - Patches and Updates help for My Oracle Support