Oracle Recommended Patches -- Oracle Database [ID 756671.1]

rongshiyuan發表於2012-11-27
原文網址 : http://blog.itpub.net/17252115/viewspace-750072/
OracleDatabase

Oracle Recommended Patches -- Oracle Database [ID 756671.1]

Oracle Recommended Patches -- Oracle Database

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 .<!-- PREV TEXT Windows bundles are cumulative; you may install the patch indicated below (in the relevant Recommended Patches table under Current Recommended Patches) or any later bundle in the Windows bundle series (See Note:161549.1). !--&gt

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.3 Current Recommended Patches

Patch Set Updates

DocumentDescriptionRolling RACPatch Download
Note:14275605.811.2.0.3.4 Patch Set Update (PSU)YesPatch:14275605

Grid Infrastructure

DocumentDescriptionRolling RACPatch Download
Note:14275572.811.2.0.3.4 Grid Infrastructure Patch Set Update (GI PSU)YesPatch:14275572

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:881505.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.3--

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:1058763.1Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.2.0.3--
Also see:
  • Note:1392633.1 Common Performance/Wrong Results Bugs Reported on 11.2.0.3


11.2.0.2 Current Recommended Patches

Patch Set Updates

DocumentDescriptionRolling RACPatch Download
Note:14275621.811.2.0.2.8 Patch Set Update (PSU)YesPatch:14275621

Grid Infrastructure

DocumentDescriptionRolling RACPatch Download
Note:14390437.811.2.0.2.8 Grid Infrastructure Patch Set Update (GI PSU)YesPatch:14390437

Exadata

DocumentDescriptionRolling RACPatch Download
Note:888828.1Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2)--

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:1367654.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.2--

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:1367644.1Interoperability 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

DocumentDescriptionRolling RACPatch Download
Note:12419378.811.2.0.1.6 Patch Set Update (PSU)YesPatch:12419378

Grid Infrastructure

DocumentDescriptionRolling RACPatch Download
Note:9655006.811.2.0.1.2 Grid Infrastructure Patch Set Update (GI PSU)YesPatch:9655006

Exadata

DocumentDescriptionRolling RACPatch Download
Note:888828.1Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 2 (11.2)--

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:1265268.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.2.0.1--

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:1265232.1Interoperability 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

DocumentDescriptionRolling RACPatch Download
Note:14275623.811.1.0.7.13 Patch Set Update (PSU)YesPatch:14275623

CRS

DocumentDescriptionRolling RACPatch Download
Note:11724953.811.1.0.7.7 CRS Patch Set Update (CRS PSU)YesPatch:11724953

Data Guard

DocumentDescriptionRolling RACPatch Download
Note:7628357.811.1.0.7 Data Guard Broker Recommended Patch Bundle #1NoPatch:7628357

Exadata

DocumentDescriptionRolling RACPatch Download
Note:835032.1Recommended Patch Information for Database Machine and Exadata Storage Server 11g Release 1 (11.1)--

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:452783.1Interoperability Notes for Oracle E-Business Suite Release 11i with Oracle Database 11.1.0.7--
Note:7295298.8Poor Subquery filter order / Queries against ALL_OBJECTS can be slowYesPatch:7295298
Note:7253531.8A dump [ttci2u] passing LOB data over heterogeneous connection with multibyteYesPatch:7253531
Note:6530141.8False ORA-979 can occur on an UPDATE DMLYesPatch:6530141

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:735276.1Interoperability Notes for Oracle E-Business Suite Release 12 with Oracle Database 11.1.0.7--
Note:7684818.811.1.0.7 EBusiness Suite R12 Certification Patch Bundle #1YesPatch:7684818
Note:7630760.8HPUX: 11.1.0.7 patch install deletes libskgxp11.aNoPatch:7630760
Note:7253531.8A dump [ttci2u] passing LOB data over heterogeneous connection with multibyteYesPatch: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

DocumentDescriptionRolling RACPatch Download
Note:9196488.8PLS-306 executing procedure on 11g from lower version PLSQL clientNoPatch:9196488
Note:7253531.8A dump [ttci2u] passing LOB data over heterogeneous connection with multibyteYesPatch:7253531
Note:6972189.8Invalid package bodies when using _load_without_compile optionYesPatch:6972189
Note:6778860.811.1.0.6 EBusiness Suite R11 Certification Patch Bundle #1NoPatch:6778860
Note:6501565.8Dump under JVM from JIT of Java class compiled with old Java compilerNoPatch:6501565

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:7377378.811.1.0.6 EBusiness Suite R12 Certification Patch Bundle #1YesPatch:7377378
Note:7253531.8A dump [ttci2u] passing LOB data over heterogeneous connection with multibyteYesPatch:7253531
Note:6991626.8Datapump export fails with ORA-39126 / ORA-22813YesPatch:6991626
Note:6815733.8OERI [qctcte1] from cost based transformation with subquery in ORDER BY clauseYesPatch:6815733
Note:6598432.8ORA-1466 from read-only transaction when client / server in different timezonesYesPatch:6598432
Note:6266400.8A dump can occur in kokbTabFuncRewriteYesPatch:6266400

10.2.0.5 Current Recommended Patches

Patch Set Updates

DocumentDescriptionRolling RACPatch Download
Note:14275629.810.2.0.5.9 Patch Set Update (PSU)YesPatch:14275629

CRS

DocumentDescriptionRolling RACPatch Download
Note:9952245.810.2.0.5.2 CRS Patch Set Update (CRS PSU)YesPatch: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.
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

DocumentDescriptionRolling RACPatch Download
Note:14275630.810.2.0.4.14 Patch Set Update (PSU) OverlayYesPatch:14275630
Note:9352164.810.2.0.4.4 Patch Set Update (PSU)YesPatch:9352164

Generic

DocumentDescriptionRolling RACPatch Download
Note:9572766.8Recommended merge fix for bug 6994194 and bug 8830147YesPatch:9572766

RAC

DocumentDescriptionRolling RACPatch Download
Note:6367097.8Recommended on HP Itanium: RAC diagnostics can abort the instance (LMS ORA-484)YesPatch:6367097
Note:6079224.8Recommended on Linux: RAC ORA-27506 / IPC Send timeoutYesPatch:6079224

CRS

DocumentDescriptionRolling RACPatch Download
Note:9294403.810.2.0.4.4 CRS Patch Set Update (CRS PSU)YesPatch:9294403

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:7014646.8OERI [kkocxj : pjpctx] from complex queryYesPatch:7014646

10.2.0.3 Current Recommended Patches

Note: 10.2.0.3 is outside of patching policy.

RAC

DocumentDescriptionRolling RACPatch Download
Note:7145055.810.2.0.3 RAC Recommended Patch Bundle #2YesPatch:7145055

CRS

DocumentDescriptionRolling RACPatch Download
Note:7117233.810.2.0.3 CRS Recommended Patch Bundle #3YesPatch:7117233

Data Guard

DocumentDescriptionRolling RACPatch Download
Note:6909784.8Recommended Merge Fix for bug 6128197 with Data Guard LogicalNoPatch:6909784
Note:6081556.810.2.0.3 Data Guard RMAN Recommended Patch Bundle #1YesPatch:6081556
Note:6081550.810.2.0.3 Data Guard Logical Recommended Patch Bundle #1NoPatch:6081550
Note:6081547.810.2.0.3 Data Guard Physical Recommended Patch Bundle #1YesPatch:6081547
Note:6048286.810.2.0.3 Data Guard Broker Recommended Patch #1NoPatch:6048286

EBusiness Suite R11i Certification

DocumentDescriptionRolling RACPatch Download
Note:6166683.8Z-Linux: ctxhx missing from 10.2.0.3YesPatch:6166683
Note:412271.1Upgrade to 10.2.0.3 can fail with ORA-600 [22635]YesPatch:5892355
Note:5871314.8Pickler fix needed to allow some DB upgrade / downgrade to workYesPatch:5871314
Note:5257698.89idata NLS files missing leading to file handle leakNoPatch:5257698

EBusiness Suite R12 Certification

DocumentDescriptionRolling RACPatch Download
Note:6319846.8EBusiness Suite R12 Certification Recommended Patch BundleYesPatch:6319846
Note:5240469.8Linux-X86 64bit: genoccish generates lots of errorsNoPatch:5240469

Miscellaneous One Off Fixes

DocumentDescriptionRolling RACPatch Download
Note:6875865.8Database instrumentation for OCMYesPatch:6875865
Note:6869828.8Recommended Merge Fix of 6122097 and 5903829YesPatch:6869828
Note:471479.1IOT corruption after upgrade from <= 9.2 to >= 10gYesPatch:6646613
Note:6455161.8Higher CPU / Higher "cache buffer chains" latch gets / Higher "consistent gets" after truncate/RebuildNoPatch:6455161
Note:453259.1OERI[kcrfr_resize2] / cannot recover databaseNoPatch:6128197
Note:453309.1OERI[kcbo_link_q_1] / crash with fix for bug 5454831 installedYesPatch:6017420
Note:5949701.8Recommended Merge Fix of 5648872 and 5863277YesPatch:5949701
Note:455832.1Client <= 9.2.0.7 / 10.1.0.4 can dump when running against higher level databaseNoPatch:5933477
Note:5907779.8Self deadlock hang on "cursor: pin S wait on X" (typically from DBMS_STATS)NoPatch:5907779
Note:5896963.8High LGWR CPU and longer "log file sync" with fix for bug 5065930YesPatch:5896963
Note:5765958.8OERI[qcscpqbTxt] / OERI[qcsfbdnp:1] from ANSI query in PLSQLNoPatch:5765958
Note:5728380.8DML may spin under ktspffc searching for space in ASSM segmentNoPatch:5728380
Note:454464.1Various dumps / instance crash possibleYesPatch:5605370
Note:5577046.8ADD or DROP attribute causes UNION query to fail with ORA-1790YesPatch:5577046
Note:5514109.8OERI [kql-hash-collision] / false ORA-955NoPatch:5514109
Note:5364143.8Bind Peeking is not done upon query reload, Execution Plan changesYesPatch:5364143
Note:5363584.8Array insert into table can corrupt redoYesPatch:5363584
Note:4899479.8Undo/redo corruption if distributed transactions usedNoPatch: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 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:847410.5 - Patches and Updates help for My Oracle Support
Note:331.1 - Oracle Database 11.2.0.x Patching & Maintenance Advisor
Note:1320966.1 - Common Performance/Wrong Results Bugs Reported on 11.2.0.2
Note:1392633.1 - Common Performance/Wrong Results Bugs Reported on 11.2.0.3
<!-- Removed for now on advice of Roger Note:466181.1 - 10g Upgrade Companion
Note:601807.1 - 11g Upgrade Companion
!--&gtNote:802103.1 - Previous (superseded) Recommended Patches

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-750072/，如需轉載，請註明出處，否則將追究法律責任。

相關文章