<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#INTRODUCTION">Introduction</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#TARGET_CONFIGS">Target Configurations</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#PATCH_AVAIL">Patch Availability</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#CONFLIST_RES">Conflict Resolution</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#ON_REQUEST">On Request</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#KNOWN">Known Issues</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=101375711299267&id=756671.1&_afrWindowMode=0&_adf.ctrl-state=zgx5pjf3g_4#REF">References</a>
Beginning with version 10.2.0.3, Oracle releases Recommended Patches for Oracle Database.
Beginning with version 10.2.0.4, Recommended Patches for Generic, RAC and DataGuard issues are released in the form of Patch Set Updates (PSU).
As of October 2014 Oracle releases "Oracle JavaVM Component Database Patch Set Update" (OJVM PSU) patches in addition to other Patch Set Updates.
This document gives information about the current Recommended Patches for each Oracle Database version.
Recommended Patches are provided for the following target configurations:
Generic
Real Application Clusters
Data Guard
Exadata
Ebusiness Suite Certification
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
Patches on other platforms are created on request.
Recommended Patches, including Patch Set Updates, have the same certification and OS version support as the 4 digit database version they are for.
Please note that Grid Infrastructure (GI) PSU Patches are applicable to both RAC environments and Oracle Restart (GI Standalone) environments.
Patch Set Updates
Document Description Rolling RAC Patch Download <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791366.8">Note:19791366.8</a> Combo of 12.1.0.2.1 OJVM PSU and 12.1.0.2.1 DB PSU (Oct 2014) No <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791366">Patch:19791366</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19303936.8">Note:19303936.8</a> 12.1.0.2.1 (Oct 2014) Database Patch Set Update (DB PSU) Yes <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19303936">Patch:19303936</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19282028.8">Note:19282028.8</a> Oracle JavaVM Component 12.1.0.2.1 Database PSU (Oct 2014) (OJVM PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19282028">Patch:19282028</a>
Grid Infrastructure
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791375.8">Note:19791375.8</a> Combo of 12.1.0.2.1 OJVM PSU and 12.1.0.2.1 GI PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791375">Patch:19791375</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19392646.8">Note:19392646.8</a> 12.1.0.2.1 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19392646">Patch:19392646</a>
Engineered Systems and DB In-Memory
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19404326.8">Note:19404326.8</a> 12.1.0.2 Bundle Patch 1 for Engineered Systems and DB In-Memory (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19404326">Patch:19404326</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19852360.8">Note:19852360.8</a> Oracle JavaVM Component 11.2.0.4.1 Database PSU - Generic JDBC Patch (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19852360">Patch:19852360</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791364.8">Note:19791364.8</a> Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 DB PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791364">Patch:19791364</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19282021.8">Note:19282021.8</a> Oracle JavaVM Component 11.2.0.4.1 Database PSU (Oct 2014) (OJVM PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19282021">Patch:19282021</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19121551.8">Note:19121551.8</a> 11.2.0.4.4 (Oct 2014) Database Patch Set Update (DB PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19121551">Patch:19121551</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791420.8">Note:19791420.8</a> Combo of 11.2.0.4.1 OJVM PSU and 11.2.0.4.4 GI PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791420">Patch:19791420</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19380115.8">Note:19380115.8</a> 11.2.0.4.4 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19380115">Patch:19380115</a>
Also see:
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19852361.8">Note:19852361.8</a> Oracle JavaVM Component 11.2.0.3.1 Database PSU - Generic JDBC Patch (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19852361">Patch:19852361</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791427.8">Note:19791427.8</a> Combo of 11.2.0.3.1 OJVM PSU and 11.2.0.3.12 DB PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791427">Patch:19791427</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19282015.8">Note:19282015.8</a> Oracle JavaVM Component 11.2.0.3.1 Database PSU (Oct 2014) (OJVM PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19282015">Patch:19282015</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19121548.8">Note:19121548.8</a> 11.2.0.3.12 (Oct 2014) Database Patch Set Update (DB PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19121548">Patch:19121548</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791428.8">Note:19791428.8</a> Combo of 11.2.0.3.1 OJVM PSU and 11.2.0.3.12 GI PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791428">Patch:19791428</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19440385.8">Note:19440385.8</a> 11.2.0.3.12 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19440385">Patch:19440385</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=888828.1">Note:888828.1</a> Recommended Patch Information for Exadata Database Machine and Exadata Storage Server -
EBusiness Suite R11i Certification
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=881505.1">Note:881505.1</a> Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.3
EBusiness Suite R12 Certification
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=1058763.1">Note:1058763.1</a> Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.3
Miscellaneous Fixes
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=17403540.8">Note:17403540.8</a> AIX: 11.2.0.3 N-apply patch for critcal AIX fixes - Bundle #2 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=17403540">Patch:17403540</a>
Note: 11.2.0.2 is outside of patching policy. It is advisable to use a newer Patch Set or release.
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=17082367.8">Note:17082367.8</a> 11.2.0.2.12 (Oct 2013) Database Patch Set Update (PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=17082367">Patch:17082367</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=17272753.8">Note:17272753.8</a> 11.2.0.2.12 (Oct 2013) Grid Infrastructure Patch Set Update (GI PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=17272753">Patch:17272753</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=1367654.1">Note:1367654.1</a> Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.2
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=1367644.1">Note:1367644.1</a> Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.2
Note: 11.2.0.1 is outside of patching policy. It is advisable to use a newer Patch Set or release.
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=12419378.8">Note:12419378.8</a> 11.2.0.1.6 (Jul 2011) Database Patch Set Update (PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=12419378">Patch:12419378</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9655006.8">Note:9655006.8</a> 11.2.0.1.2 (Jul 2010) Grid Infrastructure Patch Set Update (GI PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9655006">Patch:9655006</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=1265268.1">Note:1265268.1</a> Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.1
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=1265232.1">Note:1265232.1</a> Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.1
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19852363.8">Note:19852363.8</a> Oracle JavaVM Component 11.1.0.7.1 Database PSU - Generic JDBC Patch (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19852363">Patch:19852363</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19791436.8">Note:19791436.8</a> Combo of 11.1.0.7.1 OJVM PSU and 11.1.0.7.21 DB PSU (Oct 2014) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19791436">Patch:19791436</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19282002.8">Note:19282002.8</a> Oracle JavaVM Component 11.1.0.7.1 Database PSU (Oct 2014) (OJVM PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19282002">Patch:19282002</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=19152553.8">Note:19152553.8</a> 11.1.0.7.21 (Oct 2014) Database Patch Set Update (DB PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=19152553">Patch:19152553</a>
CRS
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=11724953.8">Note:11724953.8</a> 11.1.0.7.7 CRS Patch Set Update (CRS PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=11724953">Patch:11724953</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7628357.8">Note:7628357.8</a> 11.1.0.7 Data Guard Broker Recommended Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7628357">Patch:7628357</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=835032.1">Note:835032.1</a> Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 1 (11.1)
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=452783.1">Note:452783.1</a> Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.1.0.7 <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7295298.8">Note:7295298.8</a> Poor Subquery filter order / Queries against ALL_OBJECTS can be slow <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7295298">Patch:7295298</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7253531.8">Note:7253531.8</a> A dump [ttci2u] passing LOB data over heterogeneous connection with multibyte <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7253531">Patch:7253531</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6530141.8">Note:6530141.8</a> False ORA-979 can occur on an UPDATE DML <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6530141">Patch:6530141</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=735276.1">Note:735276.1</a> Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.1.0.7 <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7684818.8">Note:7684818.8</a> 11.1.0.7 EBusiness Suite R12 Certification Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7684818">Patch:7684818</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7630760.8">Note:7630760.8</a> HPUX: 11.1.0.7 patch install deletes libskgxp11.a <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7630760">Patch:7630760</a>
Note: 11.1.0.6 is outside of patching policy. It is advisable to use a newer Patch Set or release.
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9196488.8">Note:9196488.8</a> PLS-306 executing procedure on 11g from lower version PLSQL client <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9196488">Patch:9196488</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6972189.8">Note:6972189.8</a> Invalid package bodies when using _load_without_compile option <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6972189">Patch:6972189</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6778860.8">Note:6778860.8</a> 11.1.0.6 EBusiness Suite R11 Certification Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6778860">Patch:6778860</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6501565.8">Note:6501565.8</a> Dump under JVM from JIT of Java class compiled with old Java compiler <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6501565">Patch:6501565</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7377378.8">Note:7377378.8</a> 11.1.0.6 EBusiness Suite R12 Certification Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7377378">Patch:7377378</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6991626.8">Note:6991626.8</a> Datapump export fails with ORA-39126 / ORA-22813 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6991626">Patch:6991626</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6815733.8">Note:6815733.8</a> OERI [qctcte1] from cost based transformation with subquery in ORDER BY clause <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6815733">Patch:6815733</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6598432.8">Note:6598432.8</a> ORA-1466 from read-only transaction when client / server in different timezones <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6598432">Patch:6598432</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6266400.8">Note:6266400.8</a> A dump can occur in kokbTabFuncRewrite <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6266400">Patch:6266400</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=16619894.8">Note:16619894.8</a> 10.2.0.5.12 (Jul 2013) Database Patch Set Update (PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=16619894">Patch:16619894</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9952245.8">Note:9952245.8</a> 10.2.0.5.2 CRS Patch Set Update (CRS PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9952245">Patch:9952245</a>
Oracle 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.
Note: 10.2.0.4 is outside of patching policy. Database PSU 10.2.0.4.13 onwards are only available on limited platforms.
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=16619897.8">Note:16619897.8</a> 10.2.0.4.17 (Jul 2013) Database Patch Set Update (PSU) Overlay [limited platforms] <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=16619897">Patch:16619897</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9352164.8">Note:9352164.8</a> 10.2.0.4.4 (Apr 2010) Database Patch Set Update (PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9352164">Patch:9352164</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9572766.8">Note:9572766.8</a> Recommended merge fix for bug 6994194 and bug 8830147 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9572766">Patch:9572766</a>
RAC
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6367097.8">Note:6367097.8</a> Recommended on HP Itanium: RAC diagnostics can abort the instance (LMS ORA-484) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6367097">Patch:6367097</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6079224.8">Note:6079224.8</a> Recommended on Linux: RAC ORA-27506 / IPC Send timeout <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6079224">Patch:6079224</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=9294403.8">Note:9294403.8</a> 10.2.0.4.4 CRS Patch Set Update (CRS PSU) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=9294403">Patch:9294403</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7014646.8">Note:7014646.8</a> OERI [kkocxj : pjpctx] from complex query <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7014646">Patch:7014646</a>
Note: 10.2.0.3 is outside of patching policy.
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7145055.8">Note:7145055.8</a> 10.2.0.3 RAC Recommended Patch Bundle #2 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7145055">Patch:7145055</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=7117233.8">Note:7117233.8</a> 10.2.0.3 CRS Recommended Patch Bundle #3 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=7117233">Patch:7117233</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6909784.8">Note:6909784.8</a> Recommended Merge Fix for bug 6128197 with Data Guard Logical <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6909784">Patch:6909784</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6081556.8">Note:6081556.8</a> 10.2.0.3 Data Guard RMAN Recommended Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6081556">Patch:6081556</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6081550.8">Note:6081550.8</a> 10.2.0.3 Data Guard Logical Recommended Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6081550">Patch:6081550</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6081547.8">Note:6081547.8</a> 10.2.0.3 Data Guard Physical Recommended Patch Bundle #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6081547">Patch:6081547</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6048286.8">Note:6048286.8</a> 10.2.0.3 Data Guard Broker Recommended Patch #1 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6048286">Patch:6048286</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6166683.8">Note:6166683.8</a> Z-Linux: ctxhx missing from 10.2.0.3 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6166683">Patch:6166683</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=412271.1">Note:412271.1</a> Upgrade to 10.2.0.3 can fail with ORA-600 [22635] <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5892355">Patch:5892355</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5871314.8">Note:5871314.8</a> Pickler fix needed to allow some DB upgrade / downgrade to work <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5871314">Patch:5871314</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5257698.8">Note:5257698.8</a> 9idata NLS files missing leading to file handle leak <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5257698">Patch:5257698</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6319846.8">Note:6319846.8</a> EBusiness Suite R12 Certification Recommended Patch Bundle <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6319846">Patch:6319846</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5240469.8">Note:5240469.8</a> Linux-X86 64bit: genoccish generates lots of errors <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5240469">Patch:5240469</a>
<a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6875865.8">Note:6875865.8</a> Database instrumentation for OCM <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6875865">Patch:6875865</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6869828.8">Note:6869828.8</a> Recommended Merge Fix of 6122097 and 5903829 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6869828">Patch:6869828</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=471479.1">Note:471479.1</a> IOT corruption after upgrade from <= 9.2 to >= 10g <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6646613">Patch:6646613</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=6455161.8">Note:6455161.8</a> Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/Rebuild <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6455161">Patch:6455161</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=453259.1">Note:453259.1</a> OERI[kcrfr_resize2] / cannot recover database <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6128197">Patch:6128197</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=453309.1">Note:453309.1</a> OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installed <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=6017420">Patch:6017420</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5949701.8">Note:5949701.8</a> Recommended Merge Fix of 5648872 and 5863277 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5949701">Patch:5949701</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=455832.1">Note:455832.1</a> Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level database <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5933477">Patch:5933477</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5907779.8">Note:5907779.8</a> Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS) <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5907779">Patch:5907779</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5896963.8">Note:5896963.8</a> High LGWR CPU and longer "log file sync" with fix for bug 5065930 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5896963">Patch:5896963</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5765958.8">Note:5765958.8</a> OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQL <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5765958">Patch:5765958</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5728380.8">Note:5728380.8</a> DML may spin under ktspffc searching for space in ASSM segment <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5728380">Patch:5728380</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=454464.1">Note:454464.1</a> Various dumps / instance crash possible <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5605370">Patch:5605370</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5577046.8">Note:5577046.8</a> ADD or DROP attribute causes UNION query to fail with ORA-1790 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5577046">Patch:5577046</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5514109.8">Note:5514109.8</a> OERI [kql-hash-collision] / false ORA-955 <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5514109">Patch:5514109</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5364143.8">Note:5364143.8</a> Bind Peeking is not done upon query reload, Execution Plan changes <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5364143">Patch:5364143</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=5363584.8">Note:5363584.8</a> Array insert into table can corrupt redo <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=5363584">Patch:5363584</a> <a target="_blank" href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=756671.1&id=4899479.8">Note:4899479.8</a> Undo/redo corruption if distributed transactions used <a target="_blank" href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?parent=DOCUMENT&sourceId=756671.1&patchId=4899479">Patch:4899479</a>
If you encounter a patch conflict while installing a Recommended Patch:
For conflicts with a Patch Set Update:
For older non-PSU Recommended Patches:
Patch conflict resolution is provided using the same mechanism as the database Critical Patch Updates.
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.
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.
![Java String.format方法的簡單使用[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)