oracle最新补丁信息20221021

• 1.0 Overview
• 2.0 Delivery
• 2.1 OJVM PSU can be installed in "Conditional Rolling Install" manner in certain use cases
• 2.2 Proactive Replacement Interim Patches for Conflicts with Database Proactive Patches
• 2.3 Interim Patch Pros and Cons
• 2.4 Policy to obtain older Oracle Database Bundles, Updates & Revisions
• 2.5 Documentation of New Features and New Database Parameters
• 2.6 Bug fixes that may change an existing Optimizer execution plan
• 3.0 Oracle Recommendation
• 4.0 What's New
• 4.1 Some Database Proactive Interim patches for Oct2022 are delayed
• 4.2 Sunsetting of 19c RURs
• 4.3 Monthly Recommended Patches (MRPs)
• 5.0 Post Release Patches
• 6.0 Current patches
• 6.1 Database 21
• 6.2 Database 19
• 6.3 Database 18
• 6.4 Database 12.2.0.1
• 6.5 Database 12.1.0.2
• 6.6 Database 11.2.0.4
• 7.0 Sources of Additional Information
• 8.0 Modification History

 

1.0 OVERVIEW

Oracle provides Database patches for both proactive and reactive maintenance:

• Reactive Patches:

• are usually delivered as “Interim Patches”
• were historically known as “one-off” patches
• are provided on demand for a given “defect, version, platform” combination
• go through basic sanity tests
• fixes will usually be included in the next relevant Patch Set Release

• Proactive Patches

• address high impact bugs that affect a given configuration
• contain proven low risk fixes
• all patches are cumulative of prior fixes
• go through extra levels of testing, determined by the feature(s) affected
• are available on "My Oracle Support" by clicking on the "Patches & Updates" tab

For more information on Database Patch Delivery Methods see "Oracle Database - Overview of Database Patch Delivery Methods - 12.1.0.2 and older", Note 1962125.1 and "Patch Delivery Methods for Oracle Database 12c Release 2 (12.2.0.1) and Later Versions"

Oracle releases multiple types of Database patches for the Database and Clusterware installations:

1. Quarterly Release Updates (Updates) and Quarterly Release Update Revisions (Revisions) - Applies to Database 12.2.0.1 and later
2. Quarterly Patch Set Updates (PSUs) and Quarterly Proactive Bundle Patches (BPs) - Applies to Database 12.1.0.2 and prior
3. One-off Patches - Applies to all Database versions

The Database PSU is available for Database installations and the Grid Infrastructure (GI) PSU / Database Proactive BP for Clusterware installations for Database 12.1.0.2 and prior. Starting with Database 12.2.0.1, the Quarterly Release Updates (Updates) will replace Bundle patches and Quarterly Release Update Revisions (Revisions) will replace the PSU's to improve the quality and experience of proactive maintenance.

For more information on Database Release Update (Update) and Release Update Revision (Revision) see My Oracle Support Note 2285040.1 Release Update Introduction and FAQ.

These patches are released quarterly (Jan, Apr, Jul, Oct). There may be Monthly updates released in the first few months of a new release to accelerate stabilization.

Customers can get standalone one-off patches and diagnostic patches as Oracle has delivered for many years for Update, Revision, PSU or BP. Emergency patches will be delivered on request on top of any Updates or Revisions or PSUs or BPs for a supported release as long as technically feasible. If a fix has severe impact or issue is encountered by many customers, then fix will be considered for inclusion into the various bundles. Customers should update to the latest bundle that includes their emergency fix once it is available.

 

2.0 DELIVERY

2.1 OJVM PSU can be installed in "Conditional Rolling Install" manner in certain use cases

Starting in January 2017, the OJVM PSU for 12.1.0.2 may be installed in a "Conditional Rolling Install" fashion for the following use cases:

 * No OJVM usage

 * OJVM used by non-critical jobs and programs

 * OJVM used by critical functions isolated as services

 * OJVM used extensively, not isolated, and downtime is tolerated

 * OJVM used by critical functions and minimal downtime is required

See My Oracle Support Note 2217053.1 for more details.

Additionally, OJVM RU patches for 12.2.0.1 and 18c and greater which are dated after September 2018 may be installed in a rolling fashion as detailed in their respective README file instructions..

 

 

2.2 Proactive Replacement Interim Patches for Conflicts with Database Proactive Patches

So that customers can quickly consume new quarterly Database Proactive Patches, Oracle determines any existing interim patches that conflict with the new proactive patches, and generates replacement interim patches as needed.

For more information, see My Oracle Support Note 1998563.1 Proactive Replacement Interim Patches for Conflicts with Database Proactive Patches.

2.3 Interim Patch Pros and Cons

Interium Patches (aka one-off patches) are special exception fixes provided for a specific bug. While it may be good to have an immediate fix for a bug, it also has severe future implications that a customer should consider before immediately requesting an Interium Patch. The better option is often to wait for the next quarterly Release Update patch bundle, where the fix is already included. For an additional discussion of the pros and cons of asking for one-off bug fixes instead of waiting on the next Release Update, see MOS Note 2648544.1.

2.4 Policy to obtain older Oracle Database Bundles, Updates & Revisions

Through our review of customer Service Requests (SRs), we find that customers frequently run into issues because they have unknowingly downloaded older database bundles. To help mitigate this going forward, when a customer tries to download bundles, updates (RUs), or revisions (RURs) older than 12 months, they will be redirected to information on newer versions. We will password-protect these older versions to prevent customers from unintentionally downloading them. Customers are still entitled to download these older versions, and can obtain them by logging an SR to request the password. This will also allow us to capture reasons for these requests so that we can formulate corrective actions to improve delivery and uptake of the latest versions.

2.5 Documentation of New Features and New Database Parameters

Small, important Cloud features or new database initialization parameters are not routinely introduced in quarterly patch bundles. When they are included, the new items are documented as follows:

• Any 'Small, important Cloud feature' that might be included into a quarterly patch bundle would be included in a bug fix.. Therefore, the "Bug Fixed List" for each Release (cited in the tables below) would list any new features.
• Any new or changed database initialization parameters that might be included into a quarterly patch bundle would be documented in the Oracle Database Reference manual section on initialization parameters. For example, for Release 19c refer to E96196-09

2.6 Bug fixes that may change an existing Optimizer execution plan

Beginning with database version 12.2.0.1 and beyond, database Bug fixes that may change an existing Optimizer execution plan will be delivered with the Bug fix disabled by default. Such fixes will have to be explicitly enabled after the patch has been applied. Details on this, including the commands to explicitly enable such Bug fixes are presented in MOS Note 2147007.1.

 

3.0 ORACLE RECOMMENDATION

• If you are starting your testing now, start with latest release update 19.17.
• If you are ready to upgrade soon, but have already finished testing on 19.15 and cannot change the release version, the recommended version is 19.15.2.0.221018. This includes regression fixes and critical fixes from Note 555.1 on top of 19.15.

Beginning with the October 2022 patching cycle, 19c RURs will no longer be provided for 19.17.0 and above. No additional RURs will be delivered on any platform after the delivery of Oracle Database 19c RUR 19.16.2 in January, 2023. Refer to Sunsetting of 19c RURs and FAQ (Note 2898381.1) for further details.

To provide customers more frequent access to recommended and well-tested collections of patches, Oracle is pleased to introduce Monthly Recommended Patches (MRPs) starting in Nov 2022. MRPs are supported only on the Linux x86-64 platform. Refer to Introducing Monthly Recommended Patches (MRPs) and FAQ (Note 2898740.1) for further details.

 

4.0 WHAT'S NEW

4.1 Some Database Proactive Bundles for Oct2022 are delayed

While the goal is for all Database proactive bundles to be available on the release date, some bundles are delayed beyond October 18, 2022.

Section 6 lists all the latest bundles announced for Oct2022. Some of these bundles that are delayed are listed in Section 5 and will be updated regularly as the bundles become available for download.

4.2 Sunsetting of 19c RURs

Beginning with the October 2022 patching cycle, 19c RURs will no longer be provided for 19.17.0 and above. No additional RURs will be delivered on any platform after the delivery of Oracle Database 19c RUR 19.16.2 in January, 2023. Refer to Sunsetting of 19c RURs and FAQ (Note 2898381.1) for further details.

4.3 Monthly Recommended Patches (MRPs)

To provide customers more frequent access to recommended and well-tested collections of patches, Oracle is pleased to introduce Monthly Recommended Patches (MRPs) starting in Nov 2022. MRPs are supported only on the Linux x86-64 platform. Refer to Introducing Monthly Recommended Patches (MRPs) and FAQ (Note 2898740.1) for further details.

 

5.0 POST RELEASE PATCHES

Oracle strives to complete preparations and testing of each database Quarterly Security Patch for each platform by the quarterly release date. Occasionally, circumstances beyond our control dictate that a particular database patch be delayed and be released a few days after the quarterly release date. The following table lists any current database patch delays and the estimated date of availability.

6.0 CURRENT PATCHES

The following tables are a complete listing of the latest available RDBMS Database Patchsets and Release Updates. See the patch readmes for patch install instructions.

There is a separate MOS note that lists the JDK and PERL patches that can be applied to the Database Homes. See Note 2584628.1, "JDK and PERL Patches for Oracle Database Home and Grid Home".

 

6.1 Database 21

This table only contains patch information from the most recently available Release Update (Update) and Release Update Revision (Revision). For information on historical patches, please see My Oracle Support Note 2796590.1 Database 21c Proactive Patch Information.

Oracle recommends that you subscribe to the Known Issues NOTE(s) listed below in order to stay informed of any emergent problems.

 

6.2 Database 19

This table only contains patch information from the most recently available Release Update (Update) and Release Update Revision (Revision). For information on historical patches, please see My Oracle Support Note 2521164.1 Database 19 Proactive Patch Information.

Oracle recommends that you subscribe to the Known Issues NOTE(s) listed below in order to stay informed of any emergent problems.

Please also refer to Note 555.1 for important recommended patches to be installed on top of the Update / Revision.

Beginning with the October 2022 patching cycle, 19c RURs will no longer be provided for 19.17.0 and above. No additional RURs will be delivered on any platform after the delivery of Oracle Database 19c RUR 19.16.2 in January, 2023. Refer to Sunsetting of 19c RURs and FAQ (Note 2898381.1) for further details.

To provide customers more frequent access to recommended and well-tested collections of patches, Oracle is pleased to introduce Monthly Recommended Patches (MRPs) starting in Nov 2022. MRPs are supported only on the Linux x86-64 platform. Refer to Introducing Monthly Recommended Patches (MRPs) and FAQ (Note 2898740.1) for further details.

 

6.3 Database 18

This table only contains patch information from the most recently available Release Update (Update) and Release Update Revision (Revision). For information on historical patches, please see My Oracle Support Note 2369376.1 Database 18 Proactive Patch Information.

Oracle recommends that you subscribe to the Known Issues NOTE(s) listed below in order to stay informed of any emergent problems.

Database 18 is in Sustaining mode from July 1, 2021. Quarterly patch Bundles released from July 2021 are password protected and ONLY for Customers with Quarterly Updates exception approval. Please see My Oracle Support Note 2369376.1 for listing of latest Database 18 Patch Information.

 

6.4 Database 12.2.0.1

This table only contains patch information from the most recently available Release Update (Update) and Release Update Revision (Revision). For information on historical patches, please see My Oracle Support Note 2285557.1 Database 12.2.0.1 Proactive Patch Information.

Oracle recommends that you subscribe to the Known Issues NOTE(s) listed below in order to stay informed of any emergent problems.

Database 12.2.0.1 is in Sustaining mode from April 1, 2022. Quarterly patch Bundles released from April 2022 are password protected and ONLY for Customers with Quarterly Updates exception approval. Please see My Oracle Support Note 2285557.1 for listing of latest Database 12.2.0.1 Patch Information.

** denotes that since 12.2.0.1 entered Limted Error Correction as of December 01, 2020 all 12.2.0.1 customers should use the 12.2.0.1 Release Update.

 

6.5 Database 12.1.0.2

This table only contains patch information from the most recently available Patch Set Update (PSU) and Bundle Patch (BP). For information on historical patches, please see My Oracle Support Note 2285558.1 Database 12.1.0.2 Proactive Patch Information.

Oracle recommends that you subscribe to the Known Issues NOTE(s) listed below in order to stay informed of any emergent problems.

Database 12.1.0.2 is in Sustaining mode from August 1, 2022. Quarterly patch Bundles released after July 2022 are ONLY for Customers with Quarterly Update approval. Please see My Oracle Support Note 2285558.1 for listing of latest Database 12.1.0.2 Patch Information

 

6.6 Database 11.2.0.4

This table only contains patch information from the most recently available Security Patch Update (SPU) and Patch Set Update (PSU). For information on historical patches, please see My Oracle Support Note 2285559.1 Database 11.2.0.4 Proactive Patch Information.

Database 11.2.0.4 is in Market Driven Support (MDS) mode from January 1, 2021. Quarterly patch Bundles released from January 2021 are restricted MDS Program patches, as explained in Note 2728619.1. Please see My Oracle Support Note 2285559.1 for listing of latest Database 11.2.0.4 Patch Information.

 

 

7.0 SOURCES OF ADDITIONAL INFORMATION

The following documents provide additional information about Critical Patch Updates:

• My Oracle Support Note 888.1,Database PSU/BP/Update/Revision - Known Issues Primary Note
  
• My Oracle Support Note 854428.1,Patch Set Updates (PSUs) for Oracle Products
  
• My Oracle Support Note 438314.1,Critical Patch Update - Introduction to Database n-Apply CPU Patches
  
• My Oracle Support Note 161549.1,Oracle Database, CRS, ASM, Networking and EM Agent Patches for Microsoft Platforms
  
• My Oracle Support Note 2796590.1, Database 21c Proactive Patch Information
  
• My Oracle Support Note 2521164.1, Database 19 Proactive Patch Information
  
• My Oracle Support Note 2898381.1, Sunsetting of 19c RURs and FAQ
  
• My Oracle Support Note 2369376.1, Database 18 Proactive Patch Information
  
• My Oracle Support Note 2285557.1, Database 12.2.0.1 Proactive Patch Information
  
• My Oracle Support Note 2285558.1, Database 12.1.0.2 Proactive Patch Information
  
• My Oracle Support Note 2285559.1, Database 11.2.0.4 Proactive Patch Information

8.0 MODIFICATION HISTORY

Modification History