Oracle Recommended Patches — Oracle Database
- Target Configurations
- Patch Availability
- Current Recommended Patches
- Conflict Resolution
- On Request
- Known Issues
- 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 .
Patches on other platforms are created on request.
Whenever planning on patching or upgrading you can get help from the Patch Planner or Upgrade Planner in My Oracle Support – See Note:847410.5 for more information.
Current Recommended Patches
11.2.0.2 Current Recommended Patches
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 |
