Wednesday, 11 November 2020

How do you find the latest patch for Oracle Grid Infrastructure & Database software? GI OCT 2020 and Database Patch

 It is the best to refer  Doc " Master Note for Database Proactive Patch Program" for latest Patch and  download the latest patch set from Oracle’s support site by using the Recommended Patch Advisor. 

Simple go to my Oracle Support note "Master Note for Database Proactive Patch Program (Doc ID 756671.1)" 

Go to section 4, supported versions are 19c, 18c, 12.2 and 12.1

Doc Details

Master Note for Database Proactive Patch Program (Doc ID 756671.1)

Oct 2020 GI patch Details

--------------------


Database version(19.7.2.0.0) -Patch 31719845 "Patch 31719845: GI RELEASE UPDATE REVISION 19.7.2.0.0"


Database version(18.10.2.0.0) -Patch 31719777 "Patch 31719777: GI RELEASE UPDATE REVISION 18.10.2.0.0"


Database version(12.2.0.1.0) - Patch 31750094 "Patch 31750094: GI OCT 2020 RELEASE UPDATE 12.2.0.1.201020"

 

Database version(12.1.0.2.0) - Patch 31550110 "Patch 31718737: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.201020"

Database version(11.2.0.4.0.0) - Patch 31537677 "Patch 31537677: DATABASE PATCH SET UPDATE 11.2.0.4.201020"



Document Details

-------



.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 "Oracle Database - Overview of Database Patch Delivery Methods for 12.2.0.1 and greater", Note 2337415.1
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.

 

1.1 Oracle Database Patching - SPU vs PSU/BP

The Database Security Patch Updates (SPU) and Patch Set Updates (PSU) / Bundle Patches (BP) that are released each quarter contain the same security fixes. However, they use different patching mechanisms, and PSU/BP include both security and critical fixes.

For more information on Database Patch Delivery Methods see My Oracle Support Note 1962125.1, Oracle Database - Overview of Database Patch Delivery Methods - 12.1.0.2 and older.

NOTE: Applying a SPU on an installation with an installed PSU/BP is not supported

 

 

1.2 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 and 11.2.0.4 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..

 

 

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

1.3.1 Some Database Proactive Interim patches for Oct2020 are delayed

While the goal is for all proactive interim patches to be available on the release date, some interim patches are delayed for October 2020. The current estimate is that all of them will be available by 30-Oct-2020. We will update this note as interim patches are completed for each version.

 

1.4 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.0 WHAT'S NEW

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

PatchPatch NumberPlatformAvailability
Combo OJVM Release Update 19.9.0.0.201020 & Database Release Update 19.9.0.0.201020Patch 31720396AllAvailable
DB RU 19.9.0.0.201020Patch 31771877AllAvailable
Combo OJVM Release Update 19.9.0.0.201020 & GI Release Update 19.9.0.0.201020Patch 31720429AllAvailable
GI RU 19.9.0.0.201020Patch 31750108AllAvailable
DB RUR 19.8.1.0.201020Patch 31666885AllAvailable
GI RUR 19.8.1.0.201020Patch 31719890All except Linux x86-64 & zLinuxETA 12-Nov-2020
DB RUR 19.7.2.0.201020Patch 31667176All except HP-UX ItaniumAvailable
DB RUR 19.7.2.0.201020Patch 31667176HP-UX ItaniumETA 11-Nov-2020
GI RUR 19.7.2.0.201020Patch 31719845All except Solaris SPARC, HP-UX ItaniumAvailable
GI RUR 19.7.2.0.201020Patch 31719845Solaris SPARC, HP-UX ItaniumETA 11-Nov-2020
DB RU 18.12.0.0.201020 (& associated COMBO)Patch 31730250 (& Patch 31720435)AllAvailable
GI RU 18.12.0.0.201020 (& associated COMBO)Patch 31748523 (& Patch 31720457)AllAvailable
DB RUR 18.11.1.0.201020Patch 31666917AllAvailable
GI RUR 18.11.1.0.201020Patch 31719758AllAvailable
DB RUR 18.10.2.0.201020Patch 31667173AllAvailable
GI RUR 18.10.2.0.201020Patch 31719777AllAvailable
DB Oct2020 RU 12.2.0.1.201020 (& associated COMBO)Patch 31741641 (& Patch 31720473)AllAvailable
GI Oct2020 RU 12.2.0.1.201020 (& associated COMBO)Patch 31750094 (& Patch 31720486)AllAvailable
DB Jul2020 RUR 12.2.0.1.201020Patch 31666944AllAvailable
GI Jul2020 RUR 12.2.0.1.201020Patch 31716471AllAvailable
DB Apr2020 RUR 12.2.0.1.201020Patch 31667168AllAvailable
GI Apr2020 RUR 12.2.0.1.201020Patch 31718774AllAvailable
DB Proactive Bundle Patch 12.1.0.2.201020 (& associated COMBO)Patch 31718813 (& Patch 31720769)AllAvailable
Oracle JavaVM Component Database PSU 12.1.0.2.201020Patch 31668915AllAvailable
DB PSU 11.2.0.4.201020 (& associated COMBO)Patch 31537677 (& Patch 31720776)HP-UX PA-RISCETA 13-Nov-2020
GI PSU 11.2.0.4.201020 (& associated COMBO)Patch 31718723 (& Patch 31720783)HP-UX PA-RISCETA 13-Nov-2020
DB SPU 11.2.0.4.201020 (& associated COMBO)Patch 31834759 (& Patch 31720810)AllAvailable
Microsoft Windows BP 19.9.0.0.201020 (& associated OJVM)Patch 31719903 (& Patch 31668882)Windows 32-Bit and 64-BitETA 13-Nov-2020
Microsoft Windows BP 18.12.0.0.201020 (& associated OJVM)Patch 31629682 (& Patch 31668892)Windows 32-Bit and 64-BitETA 13-Nov-2020
QFSDP for Exadata (Oct2020)Various (See Section 3.1)Linux x86-64, Solaris x86-64Available
Quarterly Full Stack download for SuperCluster (Q4.2020)Patch 31721198AllETA 20-Nov-2020

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

 

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

Date PublishedVersionPatch NumberNameKnown IssuesBugs Fixed ListComments
October 20, 202019.9.0.0.201020Patch 31720396Combo Of OJVM Update 19.9.0.0.201020 + DB Update 19.9.0.0.201020Note 2663985.1Note 2523220.1 
October 20, 202019.9.0.0.201020Patch 31720429Combo Of OJVM Update 19.9.0.0.201020 + GI Update 19.9.0.0.201020Note 2663985.1Note 2523221.1 
October 20, 202019.9.0.0.201020Patch 31771877Database Release Update 19.9.0.0.201020Note 2663985.1Note 2523220.1 
October 20, 202019.8.1.0.201020Patch 31666885Database Release Update Revision 19.8.1.0.201020Note 2663985.1Note 2523220.1 
October 20, 202019.7.2.0.201020Patch 31667176Database Release Update Revision 19.7.2.0.201020Note 2663985.1Note 2523221.1 
October 20, 202019.9.0.0.201020Patch 31750108Grid Infrastructure Release Update 19.9.0.0.201020Note 2663985.1Note 2523221.1 
October 20, 202019.8.1.0.201020Patch 31719890Grid Infrastructure Release Update Revision 19.8.1.0.201020Note 2663985.1Note 2523221.1 
October 20, 202019.7.2.0.201020Patch 31719845Grid Infrastructure Release Update Revision 19.7.2.0.201020Note 2663985.1Note 2523221.1 
October 20, 202019.9.0.0.201020Patch 31668882 (all platforms)OJVM Release Update 19.9.0.0.201020Unix: Note 2663985.1
Windows: Note 2628965.1
List not published for security-related fixes 
October 20, 202019.9.0.0.201020Patch 31719903Microsoft Windows 32-Bit and x86-64 BP 19.9.0.0.201020Note 2628965.1README file section "Bugs Fixed by This Patch" 
October 20, 202019.9.0.0.201020Patch 31721191Quarterly Full Stack download for Exadata BP 19.9.0.0.201020Note 2694942.1  
October 20, 2020Q4.2020Patch 31721198Quarterly Full Stack download for Supercluster (Q4.2020)Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2020) does not exist yet. However, it's title will be "Oracle Database 2020.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".

 

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

Date PublishedVersionPatch NumberNameKnown IssuesBugs Fixed ListComments
October 20, 202018.12.0.0.201020Patch 31720435Combo Of OJVM Update 18.12.0.0.201020 + DB Update 18.12.0.0.201020Note 2663976.1Note 2369471.1 
October 20, 202018.12.0.0.201020Patch 31720457Combo Of OJVM Update 18.12.0.0.201020 + GI Update 18.12.0.0.201020Note 2663976.1Note 2384954.1 
October 20, 202018.12.0.0.201020Patch 31730250Database Release Update 18.12.0.0.201020Note 2663976.1Note 2369471.1 
October 20, 202018.11.1.0.201020Patch 31666917Database Release Update Revision 18.11.1.0.201020Note 2663976.1List not published for security-related fixes 
October 20, 202018.10.2.0.201020Patch 31667173Database Release Update Revision 18.10.2.0.201020Note 2663976.1List not published for security-related fixes 
October 20, 202018.12.0.0.201020Patch 31748523Grid Infrastructure Release Update 18.12.0.0.201020Note 2663976.1Note 2384954.1 
October 20, 202018.11.1.0.201020Patch 31719758Grid Infrastructure Release Update Revision 18.11.1.0.201020Note 2663976.1List not published for security-related fixes 
October 20, 202018.10.2.0.201020Patch 31719777Grid Infrastructure Release Update Revision 18.10.2.0.201020Note 2663976.1List not published for security-related fixes 
October 20, 202018.12.0.0.201020Patch 31668892 (All platforms)OJVM Release Update 18.12.0.0.201020Note 2663976.1List not published for security-related fixes 
October 20, 202018.12.0.0.201020Patch 31629682Microsoft Windows 32-Bit and x86-64 BP 18.12.0.0.201020noneREADME file section "Bugs Fixed by This Patch" 
October 20, 202018.12.0.0.201020Patch 31721185Quarterly Full Stack download for Exadata BP 18.12.0.0.201020Note 2664000.1  
October 20, 2020Q4.2020Patch 31721198Quarterly Full Stack download for Supercluster (Q4.2020)Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2020) does not exist yet. However, it's title will be "Oracle Database 2020.Q4Quarterly Full Stack Download Patch for SuperCluster Known Issues".

 

 

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

Date PublishedVersionPatch NumberNameKnown IssuesBugs Fixed ListComments
October 20, 202012.2.0.1.201020Patch 31720473Combo Of OJVM Update Component 12.2.0.1.201020 + DB Update 12.2.0.1.201020Note 2663977.1Note 2245178.1 
October 20, 202012.2.0.1.201020Patch 31720486Combo Of OJVM Update Component 12.2.0.1.201020 + GI Update 12.2.0.1.201020Note 2663977.1Note 2245185.1 
October 20, 202012.2.0.1.201020Patch 31741641Database Release Update 12.2.0.1.201020Note 2663977.1Note 2245178.1 
October 20, 202012.2.0.1.201020Patch 31667168Database Apr2020 Release Update Revision 12.2.0.1.201020Note 2663977.1List not published for security-related fixessecond Revision for the Apr Update
October 20, 202012.2.0.1.201020Patch 31666944Database Jul2020 Release Update Revision 12.2.0.1.201020Note 2663977.1List not published for security-related fixesfirst Revision for the Jul Update
October 20, 202012.2.0.1.201020Patch 31750094Grid Infrastructure Release Update 12.2.0.1.201020Note 2663977.1Note 2245185.1 
October 20, 202012.2.0.1.201020Patch 31718774Grid Infrastructure Apr2020 Release Update Revision 12.2.0.1.201020Note 2663977.1List not published for security-related fixessecond Revision for the Apr Update
October 20, 202012.2.0.1.201020Patch 31716471Grid Infrastructure Jul2020 Release Update Revision 12.2.0.1.201020Note 2663977.1List not published for security-related fixesfirst Revision for the Jul Update
October 20, 202012.2.0.1.201020Patch 31668898 (Unix)
Patch 31740064 (Windows)
OJVM Release Update 12.2.0.1.201020Note 2663977.1List not published for security-related fixes 
October 20, 202012.2.0.1.201020Patch 31654782Windows DB Bundle Patch 12.2.0.1.201020Note 2408534.1README file section "Bugs Fixed by This Patch" 
October 20, 202012.2.0.1.201020Patch 31721177Quarterly Full Stack download for Exadata (Oct2020) BP 12.2.0.1Note 2664000.1  
October 20, 2020Q4.2020Patch 31721198Quarterly Full Stack download for Supercluster (Q4.2020)Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2020) does not exist yet. However, it's title will be "Oracle Database 2020.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".

 

 

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

Date PublishedVersionPatch NumberNameKnown IssuesBugs Fixed ListComments
October 20, 202012.1.0.2.201020Patch 31720769Combo OJVM PSU 12.1.0.2.201020 and Database Proactive BP 12.1.0.2.201020See separate KIs belowNote 1937782.1 
October 20, 202012.1.0.2.201020Patch 31720729Combo OJVM PSU 12.1.0.2.201020 and Database PSU 12.1.0.2.201020See separate KIs belowNote 1924126.1 
October 20, 202012.1.0.2.201020Patch 31720761Combo Of OJVM Component 12.1.0.2.201020 DB PSU + GI PSU 12.1.0.2.201020See separate KIs belowNote 1928853.1 
October 20, 202012.1.0.2.201020Patch 31718813Database Proactive Bundle Patch 12.1.0.2.201020Note 2663997.1Note 1937782.1 
October 20, 202012.1.0.2.201020Patch 31550110Database PSU 12.1.0.2.201020Note 2663979.1Note 1924126.1 
October 20, 202012.1.0.2.201020Patch 31718737GI PSU 12.1.0.2.201020Note 2664005.1Note 1928853.1 
October 20, 202012.1.0.2.201020Patch 31668915 Unix
Patch 31740134 Windows
Oracle JavaVM Component Database PSU 12.1.0.2.201020Note 2663981.1List not published for security-related fixes 
October 20, 202012.1.0.2.201020Patch 31658987Microsoft Windows 32-Bit and x86-64 BP 12.1.0.2.201020Note 2003221.1README file section "Bugs Fixed by This Patch" 
October 20, 202012.1.0.2.201020Patch 31721169Quarterly Full Stack download for Exadata (Oct2020) BP 12.1.0.2Note 2664000.1Note 1937782.1 
October 20, 2020Q4.2020Patch 31721198Quarterly Full Stack download for Supercluster (Q4.2020)Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2020) does not exist yet. However, it's title will be "Oracle Database 2020.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".

 

 

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

Date PublishedVersionPatch NumberNameKnown IssuesBugs Fixed ListComments
October 20, 202011.2.0.4.201020Patch 31720776Combo OJVM PSU 11.2.0.4.201020 and Database PSU 11.2.0.4.201020See separate KIs belowNote 1611785.1From 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, 202011.2.0.4.201020Patch 31720810Combo OJVM PSU 11.2.0.4.201020 and Database SPU 11.2.0.4.201020See separate KIs belowList not published for security-related fixesFrom 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, 202011.2.0.4.201020Patch 31720783Combo OJVM PSU 11.2.0.4.201020 and GI PSU 11.2.0.4.201020See separate KIs belowNote 1614046.1From 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, 202011.2.0.4.201020Patch 31720797Combo OJVM PSU 11.2.0.4.201020 and Quarterly Database Patch for Exadata BP 11.2.0.4.201020See separate KIs belowNote 1601749.1From 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, 202011.2.0.4.201020Patch 31537677Database PSU 11.2.0.4.201020Note 2663980.1Note 1611785.1 
October 20, 202011.2.0.4.201020Patch 31718723GI PSU 11.2.0.4.201020Note 2663996.1Note 1614046.1 
October 20, 202011.2.0.4.201020Patch 31834759Database SPU 11.2.0.4.201020Note 2663999.1List not published for security-related fixes 
October 20, 202011.2.0.4.201020Patch 31668908 UnixOracle JavaVM (OJVM) Component Database PSU 11.2.0.4.201020Note 2663983.1List not published for security-related fixesFrom 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, 202011.2.0.4.200414Patch 31740195 WindowsOracle JavaVM (OJVM) Component Database PSU 11.2.0.4.200414Note 2663983.1List 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, 202011.2.0.4.201020Patch 31659823Microsoft Windows (32-Bit) and x64 (64-Bit) BP 11.2.0.4.201020Note 2003218.1README file section "Bugs Fixed by This Patch" 
October 20, 202011.2.0.4.201020Patch 31721158Quarterly Full Stack download for Exadata (Oct2020) BP 11.2.0.4Note 2664000.1Note 1601749.1 
October 20, 2020Q4.2020Patch 31721198Quarterly Full Stack download for Supercluster (Q4.2020)Note TBD As of the release date of this Document, the Known Issues Note for Supercluster (Q4.2020) does not exist yet. However, it's title will be "Oracle Database 2020.Q4 Quarterly Full Stack Download Patch for SuperCluster Known Issues".
October 20, 202011.2.0.4.201020Patch 31718644Quarterly Database Patch for Exadata BP 11.2.0.4.201020See section 3 of the patch README fileNote 1601749.1