重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 3112|回复: 0
打印 上一主题 下一主题

Oracle Recommended Patches -- Oracle Database

[复制链接]
跳转到指定楼层
楼主
发表于 2015-5-8 09:23:19 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

Oracle Recommended Patches -- Oracle Database

Introduction

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.
  • See Note:1929745.1 for an introduction to "Oracle JavaVM Component Database PSU"

This document gives information about the current Recommended Patches for each Oracle Database version.

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.

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.

Current Recommended Patches

12.1.0.2 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:20834354.8 Combo of 12.1.0.2.3 OJVM PSU and 12.1.0.2.3 DB PSU (Apr 2015) Part Patch:20834354
Note:20415564.8 Oracle JavaVM Component 12.1.0.2.3 Database PSU (Apr 2015) (OJVM PSU) No Patch:20415564
Note:20299023.8 12.1.0.2.3 (Apr 2015) Database Patch Set Update (DB PSU) Yes Patch:20299023

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:20834538.8 Combo of 12.1.0.2.3 OJVM PSU and 12.1.0.2.3 GI PSU (Apr 2015) Part Patch:20834538
Note:20485724.8 12.1.0.2.3 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20485724

Oracle Engineered Systems

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server - -
Note:20834553.8 Combo of 12.1.0.2.3 OJVM PSU and 12.1.0.2.7 DBBP (Apr 2015) Part Patch:20834553
Note:20698050.8 12.1.0.2 Bundle Patch 7 for Engineered Systems and DB In-Memory (Apr 2015) Yes Patch:20698050

Database In-Memory (DBIM)

Document Description Rolling RAC Patch Download
Note:20834553.8 Combo of 12.1.0.2.3 OJVM PSU and 12.1.0.2.7 DBBP (Apr 2015) Part Patch:20834553
Note:20698050.8 12.1.0.2 Bundle Patch 7 for Engineered Systems and DB In-Memory (Apr 2015) Yes Patch:20698050


12.1.0.1 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:20834568.8 Combo of 12.1.0.1.3 OJVM PSU and 12.1.0.1.7 DB PSU (Apr 2015) Part Patch:20834568
Note:20406245.8 Oracle JavaVM Component 12.1.0.1.3 Database PSU (Apr 2015) (OJVM PSU) No Patch:20406245
Note:20299016.8 12.1.0.1.7 (Apr 2015) Database Patch Set Update (DB PSU) Yes Patch:20299016
Note:19852357.8 Oracle JavaVM Component 12.1.0.1.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852357

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:20834579.8 Combo of 12.1.0.1.3 OJVM PSU and 12.1.0.1.7 GI PSU (Apr 2015) Part Patch:20834579
Note:20485774.8 AIX/HP/zLinux: 12.1.0.1.7 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20485774
Note:20485762.8 Linux/Solaris: 12.1.0.1.7 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20485762
Note:19852357.8 Oracle JavaVM Component 12.1.0.1.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852357

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server - -


11.2.0.4 Current Recommended Patches

Patch Set Updates

Document Description Rolling RAC Patch Download
Note:20834611.8 Combo of 11.2.0.4.3 OJVM PSU and 11.2.0.4.6 DB PSU (Apr 2015) Part Patch:20834611
Note:20406239.8 Oracle JavaVM Component 11.2.0.4.3 Database PSU (Apr 2015) (OJVM PSU) No Patch:20406239
Note:20299013.8 11.2.0.4.6 (Apr 2015) Database Patch Set Update (DB PSU) Yes Patch:20299013
Note:19852360.8 Oracle JavaVM Component 11.2.0.4.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852360

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:20834621.8 Combo of 11.2.0.4.3 OJVM PSU and 11.2.0.4.6 GI PSU (Apr 2015) Part Patch:20834621
Note:20485808.8 11.2.0.4.6 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20485808
Note:19852360.8 Oracle JavaVM Component 11.2.0.4.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852360

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server - -

Miscellaneous Fixes

Document Description Rolling RAC Patch Download
Note:20208022.8 AIX: 11.2.0.4 N-apply patch for critcal AIX fixes - Bundle #1 Yes Patch:20208022
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:20834670.8 Combo of 11.2.0.3.3 OJVM PSU and 11.2.0.3.14 DB PSU (Apr 2015) Part Patch:20834670
Note:20406220.8 Oracle JavaVM Component 11.2.0.3.3 Database PSU (Apr 2015) (OJVM PSU) No Patch:20406220
Note:20299017.8 11.2.0.3.14 (Apr 2015) Database Patch Set Update (DB PSU) Yes Patch:20299017
Note:19852361.8 Oracle JavaVM Component 11.2.0.3.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852361

Grid Infrastructure

Document Description Rolling RAC Patch Download
Note:20834686.8 Combo of 11.2.0.3.3 OJVM PSU and 11.2.0.3.14 GI PSU (Apr 2015) Part Patch:20834686
Note:20485830.8 11.2.0.3.14 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Yes Patch:20485830
Note:19852361.8 Oracle JavaVM Component 11.2.0.3.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852361

Exadata

Document Description Rolling RAC Patch Download
Note:888828.1 Recommended Patch Information for Exadata Database Machine and Exadata Storage Server - -

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 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results


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 Exadata Database Machine and Exadata Storage Server - -

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 Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results


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 Exadata Database Machine and Exadata Storage Server - -

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:20834724.8 Combo of 11.1.0.7.3 OJVM PSU and 11.1.0.7.23 DB PSU (Apr 2015) Part Patch:20834724
Note:20406213.8 Oracle JavaVM Component 11.1.0.7.3 Database PSU (Apr 2015) (OJVM PSU) No Patch:20406213
Note:20299012.8 11.1.0.7.23 (Apr 2015) Database Patch Set Update (DB PSU) Yes Patch:20299012
Note:19852363.8 Oracle JavaVM Component 11.1.0.7.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852363

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) - -
Note:19852363.8 Oracle JavaVM Component 11.1.0.7.1 Database PSU - Generic JDBC Patch (Oct 2014) Yes Patch:19852363

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

Conflict Resolution

If you encounter a patch conflict while installing a Recommended Patch:
  • For conflicts with a Patch Set Update:
    • See "Patch Conflict Resolution" in Note:854428.1 "Patch Set Updates for Oracle Products"
    • See Note:1061295.1 "Patch Set Updates - One-off Patch Conflict Resolution" which includes links to documents with known conflict resolutions
  • For older non-PSU Recommended Patches:
    • Patch conflict resolution is provided using the same mechanism as the database Critical Patch Updates.
    • See Note:438314.1 "Critical Patch Update - Introduction to Database n-Apply CPU Patches".
For general information about various types of patch conflict see Note:1321267.1 "Database Patch conflict resolution"

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 Patches
Note:854428.1 - Introduction to Patch Set Updates for Oracle Products.
Note:1929745.1 - Introduction to "Oracle JavaVM Component Database PSU" (OJVM PSU) Patches
Note:1454618.1 - Quick Reference To Patch Numbers For Database PSU, SPU(CPU) And Bundle Patches
NOTE: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:331.1 - Oracle Database 11.2.0.x Patching & Maintenance Advisor
Note:1320966.1 - Things to Consider Before Upgrading to 11.2.0.2 to Avoid Poor Performance or Wrong Results
Note:1392633.1 - Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
Note:1645862.1 - Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results
Note:802103.1 - Previous (superseded) Recommended Patches
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-5-18 17:55 , Processed in 0.103333 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表