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

相关文章
|
1天前
|
Oracle Java 关系型数据库
【服务器】python通过JDBC连接到位于Linux远程服务器上的Oracle数据库
【服务器】python通过JDBC连接到位于Linux远程服务器上的Oracle数据库
13 6
|
1天前
|
SQL Oracle 关系型数据库
零基础入门 Oracle数据库:轻松上手
零基础入门 Oracle数据库:轻松上手
4 0
|
1天前
|
Oracle 关系型数据库 Java
java操作多数据源将oracle数据同步达梦数据库
java操作多数据源将oracle数据同步达梦数据库
|
2天前
|
SQL 关系型数据库 MySQL
MySQL数据库的约束+进阶版新增与查询-2
MySQL数据库的约束+进阶版新增与查询
11 1
|
2天前
|
关系型数据库 MySQL 测试技术
MySQL数据库的约束+进阶版新增与查询-1
MySQL数据库的约束+进阶版新增与查询
11 1
|
2天前
|
存储 Oracle 关系型数据库
oracle 数据库 迁移 mysql数据库
将 Oracle 数据库迁移到 MySQL 是一项复杂的任务,因为这两种数据库管理系统具有不同的架构、语法和功能。
15 0
|
5天前
|
SQL 数据库
SQL数据库基础语法-查询语句
SQL数据库基础语法-查询语句
|
5天前
|
存储 监控 Apache
查询提速11倍、资源节省70%,阿里云数据库内核版 Apache Doris 在网易日志和时序场景的实践
网易的灵犀办公和云信利用 Apache Doris 改进了大规模日志和时序数据处理,取代了 Elasticsearch 和 InfluxDB。Doris 实现了更低的服务器资源消耗和更高的查询性能,相比 Elasticsearch,查询速度提升至少 11 倍,存储资源节省达 70%。Doris 的列式存储、高压缩比和倒排索引等功能,优化了日志和时序数据的存储与分析,降低了存储成本并提高了查询效率。在灵犀办公和云信的实际应用中,Doris 显示出显著的性能优势,成功应对了数据增长带来的挑战。
查询提速11倍、资源节省70%,阿里云数据库内核版 Apache Doris 在网易日志和时序场景的实践
|
Oracle 关系型数据库 数据库
ORACLE查看补丁出现“OPatch failed with error code 1”
案例场景:               在Oracle Linux Server release 5.7上安装完ORACLE 10g后,顺便将PSR(Patch Set Release)p6810189_10204_Linux-x86-64.zip也安装了。
1354 0

推荐镜像

更多