Buda Database Patch News — August 2024

Buda Database Patch News — August 2024

Welcome to Database Patch News, August 2024 Edition!

Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Here you’ll find information recently made available on patches—including security patches—and unsupported versions.

Why should you care about patching vulnerabilities and bugs?
Two big reasons:

  • Unpatched systems are a top cyber attack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk.
  • Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Bugs and vulnerabilities exist in all aspects of an application.  Below is a list of bugs that have been fixed in both MS SQL Server and Oracle’s latest patch releases:

Oracle:

  • 10121473 INCORRECT WAIT EVENT PARAMETER DESCRIPTION FOR “LIBRARY CACHE LOCK”
  • 10123661 CURSOR SHARING OF “AS OF SCN” CURSORS
  • 1297945 QH:FOLDER ERORR WHEN ATTEMPTING TO PLACE ITEMS ON EIT TAB
  • 13742922 DI:PROVIDE COMMAND TO CLEAN OUT CSS LEASES
  • 14219141 ACFS FILESYSTEM FULL DUE TO INODE TABLE
  • 14570574 TKPROF RETURNS INCORRECT PARSING USERID FOR ANY ID > 65535
  • 14735102 AC: SQLPLUS WITH TAC
  • 15931756 QUERIES AGAINST SYS_FBA_TRACKEDTABLES DON’T USE BIND VARIABLES.

MS SQL Server:

  • Fixes an issue in which maintenance plan logs might report garbled characters when the message reported involves non-ASCII characters.
  • Fixes the following error that you encounter during a Volume Shadow Copy Service (VSS) restore on a SQL Server instance that has previously deleted databases:
    • Volume Shadow Copy Service error: Unexpected error calling routine GetVolumePathName is fail on the path <PathName> … The system cannot find the file specified.
  • Fixes an issue in which the SQL Server Launchpad service can’t shut down properly when certain errors occur during startup.
  • Fixes an issue in which the remote secondary replica shows Not Synchronizing for several minutes after successive failovers between local replicas. It occurs when configured in multi-subnet, multi-region configurations in the cloud with two or more local replicas and one or more remote replicas.
  • Fixes an assertion dump issue (Location: hadrlogcapture.cpp:<LineNumber>; Expression: m_pFsManager->GetEnqueuedBlockId () < capturedLogBlockId || capturedLogBlockId == m_pDbPartner->GetFirstLogBlockIdToCapture ()) that you encounter when there are FILESTREAM transactions in an Always On availability group (AG).
  • Adds performance monitor counters to the cluster log report when the health check timeout is reported.
  • FIX: Memory exceeds the configured limits that are specified by memory.memorylimitmb in SQL Server (KB5042369)
  • Fixes an assertion failure (Location: sosmemobj.cpp:2744; Expression: pvb->FInUse()) in CVariableInfo::PviRelease that you encounter when you use UTF-8 collations and the WITH RESULT SETS clause.
  • Fixes two issues related to cardinality estimation (CE) feedback: plan cache leaks and access violations due to race conditions with statement recompilations.
  • Fixes an issue in which change tracking auto cleanup consumes CPU in cycles every 30 minutes even if change tracking isn’t enabled on any databases.

Here are the latest patch updates for Oracle and SQL Server:

Oracle Patches:

23ai – Release Update 23.4 is available (36429488 (GI/DB) & 36197510 (JDK))
Regular support ends in April 30, 2029 and extended support ends in April 30, 2032.

21c – Release Update 21.15 is available (36696109 (GI/DB) & 36538658 (JDK))
Regular support ends in April 30, 2025.  Not eligible for extended support as this is not a long term release.

19c – Release Update 19.24 is available (36582629 (GI/DB) and 36538667 (OJVM))
Regular support ends in April 30, 2026 and extended support ends in April 2027.

12cR2 – Release Update JUL 2022 is available (34219654 (GI/DB) and 34086867 (OJVM))
No longer receiving patches.  Regular support ends in July 31, 2019 and restricted upgrade support ends in Dec 31, 2025.

MS SQL Server Patches:

SQL Server 2022

Cumulative update 14 (Latest build) Released July 2024

Mainstream support ends Jan 11, 2028

Extended support ends Jan 11, 2033

SQL Server 2019

Cumulative update 28  (Latest build) Released August 2024 

Mainstream support ends Jan 7, 2025

Extended support ends Jan 8, 2030

SQL Server 2017

Cumulative update 31 (Latest build) Released July 2024

Mainstream support ends Jul 13, 2022

Extended support ends Oct 12, 2027

SQL Server 2016 Service Pack 3

GDR security update (KB5014355) Released July, 2024

Mainstream support ends Jul 13, 2021

Extended support ends Jul 14, 2026


Note: All other Oracle & SQL Server versions not mentioned are no longer supported.

Be sure to keep your databases up to date!
~The Buda Team

Database Patch News — August 2022

Database Patch News — August 2022

Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions.

 

Why should you care about patching vulnerabilities and bugs? Two big reasons:

  • Unpatched systems are a top cyber attack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk. 
  • Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Bugs and vulnerabilities exist in all aspects of an application.  Here is a list of some of the bugs fixed in this current cycle of patches:

  • 34246846 CLUVFY REPORTS FILES MISSING IN GRID AND DB HOME FOR 12.2 JULY 100% LABEL
  • 32586040 CLUVFY Reports ‘dmu’ and ‘suptools’ Files Being Dropped From DB Home and Grid Home.
  • 32963248 CVU Reports Files Missing From DB Home on 12.2.0.1.210420
  • 33903505 Cluvfy Reports Files Not Being Present in DB Home and Grid Home
  • 33903553 Drop Cluvfy Reports Files Not Being Present in DB Home and GRID Home
  • 27416177 OCSSD Coredump at clssnmvkillblockthread
  • 28677941E 191-CVU: ADD WARNING FOR /USR/LIB/TMPFILES.D/TMP.CONF
  • 29476870 CSSD Process Death Does Not Cause Instant Node Death – Disables Exadata FNDD feature
  • 30921995 Double Free During Voting File Deletion.

Here are the latest patch updates for Oracle and SQL Server:

 

Oracle Patches:

 

Oracle Quarterly Patch Updates as of August 2022:

 

21c – Release Update 21.7 is available (34155589 (GI/DB) & 34113643 (JDK))

 

19c – Release Update 19.16 is available (34130714 (GI/DB) and 34086870 (OJVM))

 

18c – Release Update 18.18 is available (33878362 (GI/DB) and 33829896 (OJVM))

 

12cR2 – Release Update JUL 2022 is available (34219654 (GI/DB) and 34086867 (OJVM))

Regular support ends in Mar 2023 and extended support ends in Mar 2026.

 

12cR1 – Release Update 220719 is available (34204576 (GI/DB) and 34086863 (OJVM))

Regular support ended in July 2019 and extended support ends in July 2021.

 

SQL Server Patches:

 

SQL Server 2019

Cumulative update 17 (Latest build) Released August 11,, 2022

Mainstream support ends Jan 7, 2025

Extended support ends Jan 8, 2030

 

SQL Server 2017

Cumulative update 30 (Latest build) Released July 13, 2022

Mainstream support ends Oct 11, 2022

Extended support ends Oct 12, 2027

 

SQL Server 2016 Service Pack 3

GDR security update (KB5014355) Released June 14, 2022

Release date: September 15, 2021

Mainstream support ends Jul 13, 2021

Extended support ends Jul 14, 2026

 

SQL Server 2014 Service Pack 3

Cumulative update 4 + GDR (5014164) Release date: June 14,  2021

Mainstream support ended Jul 9, 2019

Extended support ends Jul 9, 2024

 

Note: All other SQL Server versions not mentioned are no longer supported.

Database Patch News — August 2022

Database Patch News — April 23, 2022

Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions.

Why should you care about patching vulnerabilities and bugs? Two big reasons:

  1. Unpatched systems are a top cyberattack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk. 
  2. Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Bugs and vulnerabilities exist in all aspects of an application.  Here is a list of some of the bugs fixed in this current cycle of patches:

  1. Bug 26910536 – memory leak in clsnsg_dnssd_get_domain() (Doc ID 26910536.8)
  2. Bug 30609048 – srvctl start database or sqlplus startup discovers wrong spfile (Doc ID 30609048.8)
  3. Bug 28790623 – ASM is Not Started Automatically, After GI Upgrade from 11204 to 12201 (Doc ID 28790623.8)
  4. Bug 30816230 – ohasd.bin Does Not Respawn after Killing “ohasd.bin” (Doc ID 30816230.8)
  5. Bug 31074907 – Windows running 20c grid and 19c database might give prct-1128 : acfs is not supported on this operating system (Doc ID 31074907.8)
  6. Bug 27416177 – OCSSD Coredump at clssnmvkillblockthread (Doc ID 27416177.8)
  7. Bug 31775363 – GIPC Memory Corruption when Running under Valgrind (Doc ID 31775363.8)
  8. Bug 31849609 – GIPC Memory Leak When Running under Valgrind (Doc ID 31849609.8)

Here are the latest patch updates for Oracle and SQL Server:

Oracle Patches:

Oracle Quarterly Patch Updates as of April 2022:

21c – Release Update 21.6 is available (33859395 (GI/DB) & 33810177(JDK))

19c – Release Update 19.15 is available (33803476 (GI/DB) and 33808367 (OJVM))

 

18c – Release Update 18.17 is available (33582710 (GI/DB) and 33549631 (OJVM))

 

12cR2 – Release Update JAN 2022 is available (33583921 (GI/DB) and 33561275 (OJVM))

Regular support ends in Mar 2023 and extended support ends in Mar 2026.

 

12cR1 – Release Update 220118 is available (33829718 (GI/DB) and 33808385 (OJVM))

Regular support ended in July 2019 and extended support ends in July 2021.

 

11gR4 – Patch Set Update 201020 is available (31720776)

Regular support ended in October 2018 and extended support ended on December 31, 2020.

 

SQL Server Patches:

SQL Server 2019

Cumulative update 16 (Latest build) Released April 18, 2022

Mainstream support ends Jan 7, 2025

Extended support ends Jan 8, 2030

 

SQL Server 2017

Cumulative update 29 (Latest build) Released March 30, 2022

Mainstream support ends Oct 11, 2022

Extended support ends Oct 12, 2027

 

SQL Server 2016 Service Pack 3

Release date: September 15, 2021

Mainstream support ends Jul 13, 2021

Extended support ends Jul 14, 2026

 

SQL Server 2014 Service Pack 3

Cumulative update 4 Release date: Jan 12, 2021

Mainstream support ended Jul 9, 2019

Extended support ends Jul 9, 2024

 

Note: All other SQL Server versions not mentioned are no longer supported.

Database Patch News — August 2022

Database Patch News — January 23, 2022

Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions.

Why should you care about patching vulnerabilities and bugs? Two big reasons:

  1. Unpatched systems are a top cyberattack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk. 
  2. Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Here are the latest patch updates for Oracle and SQL Server:

Oracle Patches:

January, 2022 Quarterly Patch Updates:

21c – Release Update 21.5 is available (33531909 & 33497132)

19c – Release Update 19.14 is available (33509923 and 33561310)

18c – Release Update 18.14 is available (32524152 and 32552752)

12cR2 – Release Update JAN 2022 is available (33583921 and 33561275)

Regular support ends in Mar 2023 and extended support ends in Mar 2026.

12cR1 – Release Update 220118 is available (33575274 and 33561268)

Regular support ended in July 2019 and extended support ends in July 2021.

11gR4 – Patch Set Update 201020 is available (31720776)

Regular support ended in October 2018 and extended support ended December 31, 2020.

SQL Server Patches:

SQL Server 2019

  • Cumulative update 14 (Latest build) Released November 22, 2021
  • Mainstream support ends Jan 7, 2025
  • Extended support ends Jan 8, 2030

 

SQL Server 2017

  • Cumulative update 28 (Latest build) Released January 13, 2022
  • Mainstream support ends Oct 11, 2022
  • Extended support ends Oct 12, 2027

 

SQL Server 2016 Service Pack 3

  • Release date: September 15, 2021
  • Mainstream support ends Jul 13, 2021
  • Extended support ends Jul 14, 2026

 

SQL Server 2014 Service Pack 3

  • Cumulative update 4 Release date: Jan 12, 2021
  • Mainstream support ended Jul 9, 2019
  • Extended support ends Jul 9, 2024

 

Note: All other SQL Server versions not mentioned are no longer supported.

 

Database Patch News — August 2022

Database Patch News — November 2021

Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions.

Why should you care about patching vulnerabilities and bugs? Two big reasons:

  1. Unpatched systems are a top cyberattack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk. 
  2. Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Here are the latest patch updates for Oracle and SQL Server:

Oracle Patches:

October 2021 Quarterly Patch Updates:

21c – Release Update 21.4 is available (33239276 & 33197565)

19c – Release Update 19.13 is available (33192793 and 33192694)

18c – Release Update 18.14 is available (32524152 and 32552752)

12cR2 – Release Update OCT 2021 is available (33261817 and 33192662)

Regular support ends in Mar 2023 and extended support ends in Mar 2026.

12cR1 – Release Update 211019 is available (33128590 and 33192628)

Regular support ended in July 2019 and extended support ends in July 2021.

11gR4 – Patch Set Update 201020 is available (31720776)

Regular support ended in October 2018 and extended support ended December 31, 2020.

SQL Server Patches:

SQL Server 2019

Cumulative update 13 (Latest build) Released October 5, 2021

Mainstream support ends Jan 7, 2025

Extended support ends Jan 8, 2030

 

SQL Server 2017

Cumulative update 27 (Latest build) Released October 27, 2021

Mainstream support ends Oct 11, 2022

Extended support ends Oct 12, 2027

 

SQL Server 2016 Service Pack 3

Release date: September 15, 2021

Mainstream support ends Jul 13, 2021

Extended support ends Jul 14, 2026

 

SQL Server 2014 Service Pack 3

Cumulative update 4 Release date: Jan 12, 2021

Mainstream support ended Jul 9, 2019

Extended support ends Jul 9, 2024

 

Note: All other SQL Server versions not mentioned are no longer supported.

 

Database Patch News — August 2022

Database Patch News — March 2021 (Issue 7)

Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions.

Why should you care about patching vulnerabilities and bugs? Two big reasons:

  1. Unpatched systems are a top cyber attack target. Patch releases literally advertise vulnerabilities to the hacker community. The longer you wait to patch, the greater your security risk. 
  2. Along with running a supported database version, applying the latest patches ensures that you can get support from the vendor in case of an issue. Patching also helps eliminate downtime and lost productivity associated with bugs. 

Here are the latest patch updates for Oracle and SQL Server:

Oracle Patches:

January 19, 2021 Quarterly Patch Updates:

21c – Released January 13, 2021, Version 21.1; no Quarterly patch yet

19c – Release Update 19.10 is available (32218494 and 321266828)

18c – Release Update 18.13 is available (32204699 and 32126855)

12cR2 – Release Update 210119 is available (32228578 and 32126871)

Regular support ends in Mar 2023 and extended support ends in Mar 2026.

12cR1 – Release Update 210119 is available (32132231 and 32126908)

Regular support ended in July 2019 and extended support ends in July 2021.

11gR4 – Patch Set Update 201020 is available (31720776)

Regular support ended in October 2018 and extended support ended December 31, 2020.

 

SQL Server Patches:

SQL Server 2019

Cumulative update 9 (Latest build) Released Feb 2, 2021
Mainstream support ends Jan 7, 2025
Extended support ends Jan 8, 2030


SQL Server 2017

Cumulative update 23 (Latest build) Released Feb 24, 2021
Mainstream support ends Oct 11, 2022|
Extended support ends Oct 12, 2027


SQL Server 2016 Service Pack 2

Cumulative update 16 Release date: Feb 11, 2021
Mainstream support ends Jul 13, 2021
Extended support ends Jul 14, 2026


SQL Server 2014 Service Pack 3

Cumulative update 4 Release date: Jan 12, 2021
Mainstream support ended Jul 9, 2019
Extended support ends Jul 9, 2024


SQL Server 2012 Service Pack 4

Release date: Oct 5, 2017
Mainstream support ended Jul 11, 2017
Extended support ends Jul 12, 2022

Note: All other SQL Server versions not mentioned are no longer supported.