Oracle Database - Overview of Database Patch Delivery Method

Platform Environment DB Version Method/s Microsoft Platforms Any 10.2.0.4 - 12.1.0.2 Windows Bundle,TZ Unix Platforms Exadata 12.1.0.1 - 12.1.0.2 DBBP,QSFDP for Exadata,OJVM PSU,TZ 11.1.0.7 - 11.2.0.4 ExaDBBP,TZ RAC 12.1.0.1 - 12.1.0.2 GI PSU,Combo,TZ 11.2.0.1 - 11.2.0.4 GI PSU,TZ 10.2.0.4 - 11.1.0.7 DB PSU,CRS PSU,TZ Non-RAC 12.1.0.1 - 12.1.0.2 DB PSU,TZ 10.2.0.4 - 11.2.0.4 DB PSU,TZ Other Platforms Any Any No new bundles

More Information on Proactive Database Patches

Database Patch Set Update Short Name DB PSU Target environment/s Non-RAC DB installations on Unix platforms. Unix DB client installs. Versions DB versions 10.2.0.4 - 12.1.0.2 Platform/s Unix platforms Released Released quarterly Patch Content Critical fixes for Database and Database client. Includes security (CPU) content. No optimizer fixes. See Note:854428.1?Patch Set Updates for Oracle Products ? Note:756671.1?Master Note for Database Proactive Patch Program Recommended Version Recommend to be on the latest version Notes ? ? ? Database Grid Infrastructure Patch Set Update Short Name GI PSU Target environment/s RAC DB installations on Unix platforms (including single instance RAC). DB Versions DB versions 11.2.0.1 - 12.1.0.2 Platform/s Unix platforms Released Released quarterly Patch Content Patches include critical fixes for Grid Infrastructure and include the matching DB PSU but *not* any OJVM PSU See Note:854428.1?Patch Set Updates for Oracle Products ? Note:756671.1?Master Note for Database Proactive Patch Program Recommended Version Recommend to be on the latest version Notes ? ? ? OJVM Patch Set Update Short Name OJVM PSU (Oct 2014 also has a separate "JDBC Patch") Target environment/s Any DB installation using OJVM. DB Versions DB versions 11.1.0.7,11.2.0.3,11.2.0.4,12.1.0.1 - 12.1.0.2 Platform/s All platforms. Note that Windows platforms have special OJVM PSU overlay patches to apply on top of a Windows BP Released Released quarterly Patch Content OJVM PSU introduced Oct/2014 but had separate patches for OJVM and JDBC.?
Jan/2015 onwards the OJVM PSU patch includes JDBC fixes for the database home.? See Note:1929745.1?OJVM PSU Information ? Note:756671.1?Master Note for Database Proactive Patch Program Recommended Version Recommend to be on the latest version OR have mitigation patch installed and enabled where that is not possible Notes There is a "mitigation patch" that can be used in place of OJVM PSU ? OJVM PSU is NOT RAC Rolling and NOT Standby First installable ? Oct 2014 also has a separate "JDBC Patch" ? ? OJVM Patch Set Update "JDBC Patch" (Oct 2014 only) Short Name JDBC Patch Target environment/s Any DB,DB client,instant client or Grid Infrastructure installation using JDBC DB Versions JDBC versions 11.1.0.7,12.1.0.1 Platform/s All? platforms Released Was released as a separate patch just for October 2014 Patch Content JDBC security fixes See Note:1929745.1?OJVM PSU Information ? Note:756671.1?Master Note for Database Proactive Patch Program Recommended Version Recommend to install this patch wherever JDBC is used,or the latest JDBC component of OJVM PSU Notes From Jan 2015 onwards the JDBC fixes are included in OJVM PSU patch ? ? Combo Patches Short Name COMBO Patch Target environment/s Depends on the content - COMBO patches are convenience patches that group patches together DB Versions DB versions 11.1.0.7,12.1.0.1 - 12.1.0.2 Platform/s Unix platforms Released Released quarterly Oct 2014 onwards Patch Content Includes Patch Set Updates for the different components in a single download See Note:756671.1?Master Note for Database Proactive Patch Program ? See notes on the included components (DB PSU,GI PSU,OJVM PSU) Recommended Version See recommendation notes on included components Notes Oct/2014 omitted JDBC patches from the Combo patches ? ? Windows Database Bundle Patch Short Name Windows Bundle Patch Target environment/s DB and DB client installs on Microsoft platforms DB Versions All DB versions Platform/s Microsoft platforms only Released Release interval depends on the database version.? Patch Content Miscellanoues bug fixes.? See Note:161549.1?Oracle Database,CRS,ASM,Networking and EM Agent Patches for Microsoft Platforms Recommended Version Recommend to be on latest quarterly release or later Notes Windows Database Bundle Patches do not include OJVM PSU fixes.?
There are separate OJVM PSU patches available. ? ? Database Patch for Exadata Short Name ExaDBBP (or just BP) Target environment/s Exadata Database installations DB Versions DB Versions 11.2.0.1 - 12.1.0.2? Platform/s Exadata systems only Released Released quarterly Patch Content Critical and security content quarterly See Note:888828.1Exadata Database Machine and Exadata Storage Server Supported Versions Recommended Version Recommend to be on latest quarterly release Notes Each quarter the latest Exadata BP is included in the "Quarterly Full Stack Download Patch for Exadata" ? ? Quarterly Full Stack Download Patch for Exadata Short Name QFSDP for Exadata Target environment/s Exadata systems only DB Versions DB Versions 11.2.0.1 - 12.1.0.2 Platform/s Exadata systems only Released Released quarterly Patch Content Grid Infrastructure Release Update and other Exadata component patches See Note:888828.1?Exadata Database Machine and Exadata Storage Server Supported Versions Suggested Level of Testing Includes more fixes than just PSU fixes. Testing recommended. Recommended Version Recommend to be on latest release Notes ? ? ? Database Proactive Bundle Patch Short Name DBBP Target environment/s

（编辑：广西网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

For the quarterly proactive patches released as part of the Critical Patch Update program (DB PSU,Quarterly Database Patch for Exadata,and?Database Proactive Bundle Patch,Oracle proactively produces new interim patches for existing patches that would conflict. The new interim patches are usually released at the same time as the proactive bundles. For information about resolving patch conflicts see the following documents: Document:1941934.1?My Oracle Support Patch Conflict Checker Overview?[Video] Document:1091294.1?How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video] Document:1321267.1?Database Patch Conflict Resolution Frequently Asked Questions (FAQ) Can I use "Quarterly Database Patch for Exadata" (11.2.0.x) on non-Exadata systems? No,Oracle does not support this. Most updates are delivered in bundle patches created specifically for Exadata for Oracle Database (DB_BP) and Oracle Clusterware (GI_BP).? Bundle patches contain no Exadata-specific code,however,they may only be installed on non-Exadata systems for testing purposes,or when providing disaster recovery support for an Exadata system.? Oracle will supply interim fixes on top of Exadata bundle patches for non-Exadata systems only when the non-Exadata system is being used in a Data Guard environment as the primary or standby system for an Exadata system. Can I use "Database Proactive Bundle Patch" (12.1.0.2+) on non-Exadata systems? Yes. This patch is applicable for non-Exadata systems.? The fix information for the bundle may include some "Exadata" specific fixes but that is because the bundle is also applicable to Exadata systems.? Please refer to?Note 1937782.1?12.1.0.2 Database Proactive Bundle Patches / Bundle Patches for Engineered Systems and DB In-Memory - List of Fixes in each Bundle - List of Fixes in each Bundle for more information. Do proactive patches include optimizer fixes? "Database SPU" and "Database PSU" do?not?include optimizer fixes "Database Patch for Exadata"?can?include optimizer fixes for wrong results issues,but only in a form that allows them to be individually enabled/disabled as required. "Windows Database Bundle Patch"?can?include optimizer fixes How can I tell what patching method an installation uses? Review the opatch lsinventory output to see what patches are applied.? SPU,PSU and BP patches include a description of the patch name/version in the output. What is the difference between "Windows Database Bundle Patch" and "Database Patch for Exadata" etc.. ? These BP are targeted? at different environments. The latest versions will include the same SPU and PSU content,but all other content is specific to the target environment - there may be some other common content but there will be differences in content. Do proactive patches affect the database version as reported in tracefiles and database views like V$VERSION? No. The patch level is reflected in the opatch lsinventory data,and for some patch types is reflected in DBA_REGISTRY or DBA_REGISTRY_HISTORY ? Current Database Proactive Patches The following tables give information on currently available proactive database related patches,including some patch types that are no longer produced. Proactive Database Patches by Platform / Environment / Version Short names used in the "Method/s" column of the following table are expanded on in the next section.