oracle数据库最新补丁信息查询

简介: Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database - Standard Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.

Primary Note for Database Proactive Patch Program (Doc ID 888.1)

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:

Quarterly Release Updates (Updates) and Quarterly Release Update Revisions (Revisions) - Applies to Database 12.2.0.1 and later
Quarterly Patch Set Updates (PSUs) and Quarterly Proactive Bundle Patches (BPs) - Applies to Database 12.1.0.2 and prior
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.

Patch Patch Number Platform Availability
21.8.0.0.221018 DB RU Patch 34527084 HP-UX Itanium 05-Nov-2022
21.8.0.0.221018 GI RU Patch 34526142 HP-UX Itanium 05-Nov-2022
19.17.0.0.221018 DB RU (& associated COMBO) Patch 34419443 (& Patch 34449114) Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
19.17.0.0.221018 GI RU (& associated COMBO) Patch 34416665 (& Patch 34449117) Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
19.16.1.0.221018 DB RUR Patch 34444812 Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
19.16.1.0.221018 GI RUR Patch 34436463 Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
19.15.2.0.221018 DB RUR Patch 34429835 Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
19.15.2.0.221018 GI RUR Patch 33881789 Solaris Sparc64, Solaris x86-64, zLinux, HP-UX Itanium, AIX 21-Oct-2022
21.8.0.0.221018 WIN BP Patch 34468137 MS-Windows 05-Nov-2022
19.17.0.0.221018 WIN BP Patch 34468114 MS-Windows 05-Nov-2022
19.17.0.0.221018 OJVM Patch 34411846 MS-Windows 05-Nov-2022
Quarterly Full Stack download for Exadata (Oct2022) 21.8.0 Patch 34538883 Linux x86-64 21-Oct-2022
Quarterly Full Stack download for Exadata (Oct2022) 19.17.0 Patch 34538888 Linux x86-64, Solaris x86-64 21-Oct-2022
Quarterly Full Stack download for SuperCluster (Q4.2022) Patch 34538896 Solaris Sparc64 01-Dec-2022
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.

Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
October 18, 2022 21.8.0.0.220719 Patch 34527084 DATABASE RELEASE UPDATE 21.8.0.0.0 Note 21202210.9 Note 2814015.1
From Jan2021 onwards the Database and GI Update and Revision patches include updates to the Crypto libraries. See "MES v4.1.6 to v4.5 update 18c / 19c databases (Note 2746801.1)" for more details.

From Jan2022 onwards the Database Bundles includes changes to allow Oracle Multitenant Isolation. See MOS Note 2847081.1- Oracle Multitenant Isolation and Security Principles in 21c for more details.

October 18, 2022 21.8.0.0.221018 Patch 34526142 GI RELEASE UPDATE 21.8.0.0.0 Note 21202210.9 Note 2814016.1 See Database Release Update
October 18, 2022 21.8.0.0.221018 Patch 34468137 WINDOWS DATABASE BUNDLE PATCH 21.8.0.0.221018 Note 21202210.9 README file section "Bugs Fixed by This Patch"
October 18, 2022 21.8.0.0.221018 Patch 34538888 QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (Oct2022 - 21.8.0) Note 2888746.1

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.

Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
October 18, 2022 19.17.0.0.221018 Patch 34419443 DATABASE RELEASE UPDATE 19.17.0.0.0 Note 19202210.9 Note 2523220.1
From Jan2021 onwards the Database and GI Update and Revision patches include updates to the Crypto libraries. See "MES v4.1.6 to v4.5 update 18c / 19c databases (Note 2746801.1)" for more details.

From Jan2022 onwards the Database Bundles includes changes to allow Oracle Multitenant Isolation. See MOS Note 2847081.1- Oracle Multitenant Isolation and Security Principles in 21c for more details.

October 18, 2022 19.17.0.0.221018 Patch 34416665 GI RELEASE UPDATE 19.17.0.0.0 Note 19202210.9 Note 2523221.1 See Database Release Update
October 18, 2022 19.17.0.0.221018 Patch 34411846 (all platforms) OJVM RELEASE UPDATE 19.17.0.0.0 Note 19202210.9 List not published for security-related fixes
October 18, 2022 19.17.0.0.221018 Patch 34468114 WINDOWS DATABASE BUNDLE PATCH 19.17.0.0.221018 Note 19202210.9 README file section "Bugs Fixed by This Patch"
October 18, 2022 19.17.0.0.221018 Patch 34449114 COMBO OF OJVM RU COMPONENT 19.17.0.0.221018 + DB RU 19.17.0.0.221018 Note 19202210.9 Note 2523220.1
October 18, 2022 19.17.0.0.221018 Patch 34449117 COMBO OF OJVM RU COMPONENT 19.17.0.0.221018 + GI RU 19.17.0.0.221018 Note 19202210.9 Note 2523221.1
October 18, 2022 19.16.1.0.221018 Patch 34444812 DATABASE RELEASE UPDATE REVISION 19.16.1.0.0 Note 19202210.9 Note 2523220.1 See Database Release Update
October 18, 2022 19.16.1.0.221018 Patch 34436463 GI RELEASE UPDATE REVISION 19.16.1.0.0 Note 19202210.9 Note 2523221.1 See Database Release Update
October 18, 2022 19.15.2.0.221018 Patch 34429835 DATABASE RELEASE UPDATE REVISION 19.15.2.0.0 Note 19202210.9 Note 2523220.1 See Database Release Update
October 18, 2022 19.15.2.0.221018 Patch 34518661 GI RELEASE UPDATE REVISION 19.15.2.0.0 Note 19202210.9 Note 2523221.1 See Database Release Update
October 18, 2022 19.17.0.0.221018 Patch 34538883 QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (Oct2022 - 19.17.0) Note 2888746.1
October 18, 2022 Q4.2022 Patch 34538896 QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q4.2022) Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2022) does not exist yet. However, it's title will be "Oracle Database 2022.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".

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.
Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
April 20, 2021 18.14.0.0.210420 Patch 32524155 DATABASE RELEASE UPDATE 18.14.0.0.0 Note 18202104.9 Note 2369471.1 From Jan2021 onwards the Database and GI Update and Revision patches include updates to the Crypto libraries. See "MES v4.1.6 to v4.5 update 18c / 19c databases (Note 2746801.1)" for more details.
April 20, 2021 18.14.0.0.210420 Patch 32524152 GI RELEASE UPDATE 18.14.0.0.0 Note 18202104.9 Note 2384954.1 See Database Release Update
April 20, 2021 18.14.0.0.210420 Patch 32552752 (All platforms) OJVM RELEASE UPDATE 18.14.0.0.0 Note 18202104.9 List not published for security-related fixes
April 20, 2021 18.14.0.0.210420 Patch 32438481 WINDOWS DATABASE BUNDLE PATCH 18.14.0.0.210420 none README file section "Bugs Fixed by This Patch"
April 20, 2021 18.14.0.0.210420 Patch 32579022 COMBO OF OJVM RU COMPONENT 18.14.0.0.210420 + DB RU 18.14.0.0.210420 Note 18202104.9 Note 2369471.1
April 20, 2021 18.14.0.0.210420 Patch 32579024 COMBO OF OJVM RU COMPONENT 18.14.0.0.210420 + GI RU 18.14.0.0.210420 Note 18202104.9 Note 2384954.1
April 20, 2021 18.13.1.0.210420 Patch 32451079 DATABASE RELEASE UPDATE REVISION 18.13.1.0.0 Note 18202104.9 Note 2369471.1 See Database Release Update
April 20, 2021 18.13.1.0.210420 Patch 32580014 GI RELEASE UPDATE REVISION 18.13.1.0.0 Note 18202104.9 Note 2384954.1 See Database Release Update
April 20, 2021 18.12.2.0.210420 Patch 32421478 DATABASE RELEASE UPDATE REVISION 18.12.2.0.0 Note 18202104.9 Note 2369471.1 See Database Release Update
April 20, 2021 18.12.2.0.210420 Patch 32579981 GI RELEASE UPDATE REVISION 18.12.2.0.0 Note 18202104.9 Note 2384954.1 See Database Release Update
April 20, 2021 18.14.0.0.210420 Patch 32579177 QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (APR2021 - 18.14) Note 2749152.1
April 20, 2021 Q3.2021 Patch 32579195 QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q3.2021) Note 2768035.1

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.
Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
January 18, 2022 12.2.0.1.220118 Patch 33587128 DATABASE Jan 2022 RELEASE UPDATE 12.2.0.1.220118 Note 12202201.9 Note 2245178.1
January 18, 2022 12.2.0.1.220118 Patch 33583921 GI Jan 2022 RELEASE UPDATE 12.2.0.1.220118 Note 12202201.9 Note 2245185.1
January 18, 2022 12.2.0.1.220118 Patch 33561275 (Unix)
Patch 33577550 (Windows) OJVM RELEASE UPDATE 12.2.0.1.220118 Unix: Note 12202201.9
Windows: Note 2408534.1 List not published for security-related fixes
January 18, 2022 12.2.0.1.220118 Patch 33488333 WINDOWS DB BUNDLE PATCH 12.2.0.1.220118 Note 2408534.1 README file section "Bugs Fixed by This Patch"
January 18, 2022 12.2.0.1.220118 Patch 33559893 COMBO OF OJVM RU COMPONENT 12.2.0.1.220118 + 12.2.0.1.220118 DB Jan2022 RU Note 12202201.9 Note 2245178.1
January 18, 2022 12.2.0.1.220118 Patch 33559966 COMBO OF OJVM RU COMPONENT 12.2.0.1.220118 + 12.2.0.1.220118 GI Jan2022 RU Note 12202201.9 Note 2245185.1
January 18, 2022 12.2.0.1.220118 ** Database Oct 2021 Release Update Revision 12.2.0.1.220118 Note 12202201.9 Note 2245178.1 first Revision for the Oct Update
January 18, 2022 12.2.0.1.220118 ** Grid Infrastructure Oct 2021 Release Update Revision 12.2.0.1.220118 Note 12202201.9 Note 2245185.1first Revision for the Oct Update
January 18, 2022 12.2.0.1.220118 ** Database Jul 2021 Release Update Revision 12.2.0.1.220118 Note 12202201.9 Note 2245178.1 second Revision for the Jul Update
January 18, 2022 12.2.0.1.220118 ** Grid Infrastructure Jul 2021 Release Update Revision 12.2.0.1.220118 Note 12202201.9 Note 2245185.1second Revision for the Jul Update
January 18, 2022 12.2.0.1.220118 Patch 33567282 QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (Jan2022 - 12.2.0.1) Note 2817017.1
January 18, 2022 Q1.2022 Patch 33567289 QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q1.2022) Note 2848496.1
** 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
Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
July 19, 2022 12.1.0.2.220719 Patch 34204559 DATABASE PROACTIVE BUNDLE PATCH 12.1.0.2.220719 Note 2867931.1 Note 1937782.1
July 19, 2022 12.1.0.2.220719 Patch 34057742 DATABASE PATCH SET UPDATE 12.1.0.2.220719 Note 2867915.1 Note 1924126.1
July 19, 2022 12.1.0.2.220719 Patch 34204576 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.220719 Note 2867907.1 Note 1928853.1
July 19, 2022 12.1.0.2.220719 Patch 34086863 Unix
Patch 34185253 Windows OJVM PATCH SET UPDATE 12.1.0.2.220719 Note 2867930.1 List not published for security-related fixes
July 19, 2022 12.1.0.2.220719 Patch 33883271 WINDOWS DB BUNDLE PATCH 12.1.0.2.220719 Note 2867915.1 README file section "Bugs Fixed by This Patch"
July 19, 2022 12.1.0.2.220719 Patch 34163651 COMBO OF OJVM COMPONENT 12.1.0.2.220719 DB PSU + DB BP 12.1.0.2.220719 See separate KIs below Note 1937782.1
July 19, 2022 12.1.0.2.220719 Patch 34163630 COMBO OF OJVM COMPONENT 12.1.0.2.220719 DB PSU + DBPSU 12.1.0.2.220719 See separate KIs below Note 1924126.1
July 19, 2022 12.1.0.2.220719 Patch 34163645 COMBO OF OJVM COMPONENT 12.1.0.2.220719 DB PSU + GIPSU 12.1.0.2.220719 See separate KIs below Note 1928853.1
July 19, 2022 12.1.0.2.220719 Patch 34205981 QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (Jul2022 - 12.1.0.2) Note 2867919.1 Note 1937782.1
July 19, 2022 Q3.2022 Patch 34206024 QUARTERLY FULL STACK DOWNLOAD PATCH FOR SUPERCLUSTER (Q3.2022) Note 2892107.1Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2022) does not exist yet. However, it's title will be "Oracle Database 2022.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".

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.
Date Published Version Patch Number Name Known Issues Bugs Fixed List Comments
October 20, 2020 11.2.0.4.201020 Patch 31720776 Combo OJVM PSU 11.2.0.4.201020 and Database PSU 11.2.0.4.201020 See separate KIs below Note 1611785.1 From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.
October 20, 2020 11.2.0.4.201020 Patch 31720810 Combo OJVM PSU 11.2.0.4.201020 and Database SPU 11.2.0.4.201020 See separate KIs below List not published for security-related fixes From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.
October 20, 2020 11.2.0.4.201020 Patch 31720783 Combo OJVM PSU 11.2.0.4.201020 and GI PSU 11.2.0.4.201020 See separate KIs below Note 1614046.1 From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.
October 20, 2020 11.2.0.4.201020 Patch 31720797 Combo OJVM PSU 11.2.0.4.201020 and Quarterly Database Patch for Exadata BP 11.2.0.4.201020 See separate KIs below Note 1601749.1 From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.
October 20, 2020 11.2.0.4.201020 Patch 31537677 Database PSU 11.2.0.4.201020 Note 2663980.1 Note 1611785.1
October 20, 2020 11.2.0.4.201020 Patch 31718723 GI PSU 11.2.0.4.201020 Note 2663996.1 Note 1614046.1
October 20, 2020 11.2.0.4.201020 Patch 31834759 Database SPU 11.2.0.4.201020 Note 2663999.1 List not published for security-related fixes
October 20, 2020 11.2.0.4.201020 Patch 31668908 Unix Oracle JavaVM (OJVM) Component Database PSU 11.2.0.4.201020 Note 2663983.1 List not published for security-related fixes From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.
October 20, 2020 11.2.0.4.200414 Patch 31740195 Windows Oracle JavaVM (OJVM) Component Database PSU 11.2.0.4.200414 Note 2663983.1 List not published for security-related fixes
From Jan2019 onwards the OJVM now only supports JDK7 for security compliance. Please ensure that if there are applications with an OJVM dependency that they are compatible with JDK7.

October 20, 2020 11.2.0.4.201020 Patch 31659823 Microsoft Windows (32-Bit) and x64 (64-Bit) BP 11.2.0.4.201020 Note 2003218.1 README file section "Bugs Fixed by This Patch"
October 20, 2020 11.2.0.4.201020 Patch 31721158 Quarterly Full Stack download for Exadata (Oct2020) BP 11.2.0.4 Note 2664000.1 Note 1601749.1
October 20, 2020 Q4.2020 Patch 31721198 Quarterly Full Stack download for Supercluster (Q4.2020) Note 2720064.1
October 20, 2020 11.2.0.4.201020 Patch 31718644 Quarterly Database Patch for Exadata BP 11.2.0.4.201020 See section 3 of the patch README file Note 1601749.1

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

Date Modification
October 18, 2022 Released
October 20, 2022 Updated the notebox in Section 6.5
Updated patch availability in section 5

相关文章
|
16天前
|
存储 Oracle 关系型数据库
数据库数据恢复—ORACLE常见故障的数据恢复方案
Oracle数据库常见故障表现: 1、ORACLE数据库无法启动或无法正常工作。 2、ORACLE ASM存储破坏。 3、ORACLE数据文件丢失。 4、ORACLE数据文件部分损坏。 5、ORACLE DUMP文件损坏。
62 11
|
22天前
|
存储 缓存 网络协议
数据库执行查询请求的过程?
客户端发起TCP连接请求,服务端通过连接器验证主机信息、用户名及密码,验证通过后创建专用进程处理交互。服务端进程缓存以减少创建和销毁线程的开销。后续步骤包括缓存查询(8.0版后移除)、语法解析、查询优化及存储引擎调用,最终返回查询结果。
27 6
|
29天前
|
Oracle 关系型数据库 数据库
Oracle数据恢复—Oracle数据库文件有坏快损坏的数据恢复案例
一台Oracle数据库打开报错,报错信息: “system01.dbf需要更多的恢复来保持一致性,数据库无法打开”。管理员联系我们数据恢复中心寻求帮助,并提供了Oracle_Home目录的所有文件。用户方要求恢复zxfg用户下的数据。 由于数据库没有备份,无法通过备份去恢复数据库。
|
1月前
|
存储 Oracle 关系型数据库
oracle数据恢复—Oracle数据库文件大小变为0kb的数据恢复案例
存储掉盘超过上限,lun无法识别。管理员重组存储的位图信息并导出lun,发现linux操作系统上部署的oracle数据库中有上百个数据文件的大小变为0kb。数据库的大小缩水了80%以上。 取出&并分析oracle数据库的控制文件。重组存储位图信息,重新导出控制文件中记录的数据文件,发现这些文件的大小依然为0kb。
|
20天前
|
SQL JavaScript 程序员
数据库LIKE查询屡试不爽?揭秘大多数人都忽视的秘密操作符!
本文分析了因数据库中的不可见空白字符导致的数据查询问题,探讨了问题的成因与特性,并提出了使用 SQL 语句修复问题的有效方案。同时,总结了避免类似问题的经验和注意事项。
28 0
|
22天前
|
存储 Oracle 关系型数据库
服务器数据恢复—华为S5300存储Oracle数据库恢复案例
服务器存储数据恢复环境: 华为S5300存储中有12块FC硬盘,其中11块硬盘作为数据盘组建了一组RAID5阵列,剩下的1块硬盘作为热备盘使用。基于RAID的LUN分配给linux操作系统使用,存放的数据主要是Oracle数据库。 服务器存储故障: RAID5阵列中1块硬盘出现故障离线,热备盘自动激活开始同步数据,在同步数据的过程中又一块硬盘离线,RAID5阵列瘫痪,上层LUN无法使用。
|
1月前
|
存储 缓存 固态存储
怎么让数据库查询更快
【10月更文挑战第28天】
38 2
|
1月前
|
存储 缓存 关系型数据库
怎么让数据库查询更快
【10月更文挑战第25天】通过以上综合的方法,可以有效地提高数据库查询的速度,提升应用程序的性能和响应速度。但在优化过程中,需要根据具体的数据库系统、应用场景和数据特点进行合理的调整和测试,以找到最适合的优化方案。
|
27天前
|
JSON JavaScript 关系型数据库
node.js连接GBase 8a 数据库 并进行查询代码示例
node.js连接GBase 8a 数据库 并进行查询代码示例
|
1月前
|
监控 关系型数据库 MySQL
数据库优化:MySQL索引策略与查询性能调优实战
【10月更文挑战第27天】本文深入探讨了MySQL的索引策略和查询性能调优技巧。通过介绍B-Tree索引、哈希索引和全文索引等不同类型,以及如何创建和维护索引,结合实战案例分析查询执行计划,帮助读者掌握提升查询性能的方法。定期优化索引和调整查询语句是提高数据库性能的关键。
285 1

推荐镜像

更多