Patch Help


$ cd $ORACLE_HOME/OPatch
$ opatch -help

Invoking OPatch 10.2.0.4.2
 

Oracle Interim Patch Installer version 10.2.0.4.2

Copyright (c) 2007, Oracle Corporation.  All rights reserved.
 
 
 Usage: opatch [ -help ] [ -r[eport] ] [ command ]
 

                       lsinventory
command := apply
                       napply

                       query
nrollback
                       rollback

 <global_arguments> := -help       Displays the help message for the command.
version
                       prereq
                       util
 

   'opatch -help'
-report     Print the actions without executing.
 
 example:
   'opatch apply -help'
   'opatch lsinventory -help'
   'opatch napply -help'

 
'opatch nrollback -help'
   'opatch rollback -help'
   'opatch prereq -help'
   'opatch util -help'

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 .

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

|| Document || Description || Rolling RAC || Patch Download ||
|| Note:14275605.8 || 11.2.0.3.4 Patch Set Update (PSU) || Yes || Patch:14275605 ||

Grid Infrastructure

|| Document || Description || Rolling RAC || Patch Download ||
|| Note:14275572.8 || 11.2.0.3.4 Grid Infrastructure Patch Set Update (GI PSU) || Yes || Patch:14275572 ||

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 || - || - ||

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

|| Document || Description || Rolling RAC || Patch Download ||
|| Note:14275621.8 || 11.2.0.2.8 Patch Set Update (PSU) || Yes || Patch:14275621 ||

Grid Infrastructure

|| Document || Description || Rolling RAC || Patch Download ||
|| Note:14390437.8 || 11.2.0.2.8 Grid Infrastructure Patch Set Update (GI PSU) || Yes || Patch:14390437 ||

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 Patch Set Update (PSU) || Yes || Patch:12419378 ||

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:14275623.8 || 11.1.0.7.13 Patch Set Update (PSU) || Yes || Patch:14275623 ||

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:14275629.8 || 10.2.0.5.9 Patch Set Update (PSU) || Yes || Patch:14275629 ||

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.

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:14275630.8 || 10.2.0.4.14 Patch Set Update (PSU) Overlay || Yes || Patch:14275630 ||
|| 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

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 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 ||

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

Note:802103.1 - Previous (superseded) Recommended Patches

CLOUDARCHITECT

blog menu1

Patch Help

Patch Help

Oracle Recommended Patches -- Oracle Database

Target Configurations

Patch Availability

Current Recommended Patches

11.2.0.3 Current Recommended Patches

11.2.0.2 Current Recommended Patches

11.2.0.1 Current Recommended Patches

11.1.0.7 Current Recommended Patches

11.1.0.6 Current Recommended Patches

10.2.0.5 Current Recommended Patches

10.2.0.4 Current Recommended Patches

10.2.0.3 Current Recommended Patches

Conflict Resolution

On Request

No comments:

Post a Comment