12.1.0.1 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:18031528.8 12.1.0.1.3 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031528
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:18413105.8 AIX/HP/zLinux: 12.1.0.1.3 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18413105 Note:18139660.8 Linux/Solaris: 12.1.0.1.3 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139660
11.2.0.4 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:18031668.8 11.2.0.4.2 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031668
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:18139609.8 11.2.0.4.2 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139609
Also see:
- Note:1645862.1 Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results
11.2.0.3 Current Recommended Patches
Patch Set Updates
Document Description Rolling RAC Patch Download Note:18031683.8 11.2.0.3.10 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031683
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:18139678.8 11.2.0.3.10 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:18139678
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.3 – –
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.3 – –
Miscellaneous Fixes
Document Description Rolling RAC Patch Download Note:17403540.8 AIX: 11.2.0.3 N-apply patch for critcal AIX fixes – Bundle #2 Yes Patch:17403540
Also see:
- Note:1392633.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.3
11.2.0.2 Current Recommended Patches
Note: 11.2.0.2 is outside of patching policy. It is advisable to use a newer Patch Set or release.
Patch Set Updates
Document Description Rolling RAC Patch Download Note:17082367.8 11.2.0.2.12 (Oct 2013) Database Patch Set Update (PSU) Yes Patch:17082367
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:17272753.8 11.2.0.2.12 (Oct 2013) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:17272753
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:1367654.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:1367644.1 Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.2 – –
Also see:
- Note:1320966.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.2
11.2.0.1 Current Recommended Patches
Note: 11.2.0.1 is outside of patching policy. It is advisable to use a newer Patch Set or release.
Patch Set Updates
Document Description Rolling RAC Patch Download Note:12419378.8 11.2.0.1.6 (Jul 2011) Database Patch Set Update (PSU) Yes Patch:12419378
Grid Infrastructure
Document Description Rolling RAC Patch Download Note:9655006.8 11.2.0.1.2 (Jul 2010) 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:18031726.8 11.1.0.7.19 (Apr 2014) Database Patch Set Update (PSU) Yes Patch:18031726
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
Note: 11.1.0.6 is outside of patching policy. It is advisable to use a newer Patch Set or release.
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:16619894.8 10.2.0.5.12 (Jul 2013) Database Patch Set Update (PSU) Yes Patch:16619894
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 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.
Note: 10.2.0.4 is outside of patching policy. Database PSU 10.2.0.4.13 onwards are only available on limited platforms.
Patch Set Updates
Document Description Rolling RAC Patch Download Note:16619897.8 10.2.0.4.17 (Jul 2013) Database Patch Set Update (PSU) Overlay [limited platforms] Yes Patch:16619897 Note:9352164.8 10.2.0.4.4 (Apr 2010) Database 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
Note: 10.2.0.3 is outside of patching policy.
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 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
