Oracle Database 19c Important Recommended One-off Patches (DOC ID 555.1) for Linux 19.24.0.0.240716

Doc ID 555.1

Copyright (c) 2024, Oracle. All rights reserved. Oracle Confidential.
Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1)
NOTE: This document will be updated once a week on Tuesdays at 9AM EST if any new patch is identified.
Through our review of service requests, we often find that issues encountered are the result of customers being on an older Release Update (RU) or Release Update Revision (RUR). Many issues will have been fixed in the latest updates, which we always recommend.
As noted in the update-specific tables below, fixes for known issues are targeted for inclusion in the first available RU or RUR. You can always find the latest RUs, RURs, other patches, lists of fixed bugs and known issues in Primary Note for Database Proactive Patch Program(Doc ID 888.1). Identifying and installing the latest updates (patches) helps ensure you are using the most current content for security, functional, regression and bug fixes, as well as minor enhancements and any emergency one-offs.
Note:
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 (Doc ID 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 Nov 2022. MRPs are supported only on Linux x86-64 platform.
Refer to Introducing Monthly Recommended Patches (MRPs) and FAQ (Doc ID 2898740.1) for further details.
In addition to the relevant patches listed below, you should apply patches based on the specific RU after reviewing the following My Oracle Support knowledge documents:
Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1)
Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.
NOTE: Bug 33539779 is no longer recommended and this note will be updated when a replacement becomes available in the future.
NOTE: If you are an Applications Unlimited (for example, EBS) customer, you should follow any directions given in your product-specific documentation on applicability of Release Updates (RUs) and Release Update Revisions (RURs).
The information below lists any additional patches (both rolling and non-rolling) that are recommended for installation on top of each RU. Click the relevant link for details. Be aware that this document only shows patches for the latest four RUs.
NOTE: Latest four RUs.

• 19.24 GI RU - Patch 36582629 (for Grid Infrastructure home and Database homes on RAC systems), 19.23 DB RU - Patch 36582781 (for Database homes on non-RAC systems)
  
• 19.23 GI RU - Patch 36233126 (for Grid Infrastructure home and Database homes on RAC systems), 19.23 DB RU - Patch 36233263 (for Database homes on non-RAC systems)
  
• 19.22 GI RU - Patch 35940989 (for Grid Infrastructure home and Database homes on RAC systems), 19.22 DB RU - Patch 35943157 (for Database homes on non-RAC systems)
  
• 19.21 GI RU - Patch 35642822 (for Grid Infrastructure home and Database homes on RAC systems), 19.21 DB RU - Patch 35643107 (for Database homes on non-RAC systems)

Recommended Patches for 19.24 DB Home
Below is the list of important patches to consider applying on top of 19.24. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.

• 35663882 [RMAN] Many Sessions are Blocked by CF Enqueue Contention
  
• 36273767 [TXN MGMT LOCAL] ORA-1578: oracle data block corrupted on tempfile even after 35904282, 35733946
  
• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
  
• 34774667 [AQ] ORA-7445 in Purge Queue Table / High CPU usage in SVCB Service
  
• 31061145 RAC] Remove requirement to set TARGET_PDBS for RAC on multitenant deployments in 18c onwards
  
• 29213893 [QRY OPTIMIZER] DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table

Version DB 19.24_555.1: 35663882,36273767,34672698,34774667,31061145,29213893
Recommended Patches for 19.24 GI Home
Below is the list of important patches to consider applying on top of 19.24. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.
Only one OCW (Oracle Clusterware) patch should be applied to GI homes. Ensure you apply the patch starting with X8M if you are on an X8M system

• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)[list-patches]YES 22-FEB-2024

Version GI 19.24_555.1: 34672698
Recommended Patches for 19.23 DB Home
Below is the list of important patches to consider applying on top of 19.23. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.

• 35925654 [ROW CACHE] Sessions Deadlock on Row Cache Mutex and Shared Pool Latch
  
• 35663882 [RMAN] Many Sessions are Blocked by CF Enqueue Contention
  
• 36065162 [EXTENSIBILITY] ORA-7445 [qkaual_get_selexp] with pipelined function in union all in 19.20
  
• 36285197 [RAC] ORA-4021: timeout occurred while waiting to lock object and/or Global Cache Performance Issues
  
• 36158909 [RAC] DB Hung Wating For 'log file switch (checkpoint incomplete)'
  
• 35077128 [VOS RESRC MGR] ORA-600 [15709] - kxfpqsrls due to cpurm and dead sessions
  
• 36273767 [TXN MGMT LOCAL] ORA-1578: oracle data block corrupted on tempfile even after 35904282, 35733946
  
• 36480774 [RECOVERY] Slow Opening of database in RAC database for other instance
  
• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
  
• 34774667 [AQ] ORA-7445 in Purge Queue Table / High CPU usage in SVCB Service
  
• 31061145 [RAC] Remove requirement to set TARGET_PDBS for RAC on multitenant deployments in 18c onwards
  
• 29213893 [QRY OPTIMIZER] DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table

Version DB 19.23_555.1: 35925654,35663882,36065162,36285197,36158909,35077128,36273767,36480774,34672698,34774667,31061145,29213893
Recommended Patches for 19.23 GI Home
Below is the list of important patches to consider applying on top of 19.23. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.
Only one OCW (Oracle Clusterware) patch should be applied to GI homes. Ensure you apply the patch starting with X8M if you are on an X8M system

• 36427106 [OSS SRV LAYER] Exadata: Cannot upgrade cell nodes after gi is upgraded from 19c to 23ai - Griddisks do not show "YES" for asmdeactivateoutcome
  
• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)

Version GI 19.23_555.1: 36427106,34672698
Recommended Patches for 19.22 DB Home
Below is the list of important patches to consider applying on top of 19.22. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.

• 35925654 [ROW CACHE] Sessions Deadlock on Row Cache Mutex and Shared Pool Latch
  
• 35663882 [RMAN] Many Sessions are Blocked by CF Enqueue Contention
  
• 36065162 [EXTENSIBILITY] ORA-7445 [qkaual_get_selexp] with pipelined function in union all in 19.20
  
• 34547607 [TXN MGMT LOCAL] ORA-600 [ktugct: corruption detected] w/ Compression & RAC DB Instances Crash
  
• 36285197 [RAC] ORA-4021: timeout occurred while waiting to lock object and/or Global Cache Performance Issues
  
• 36158909 [RAC] DB Hung Wating For 'log file switch (checkpoint incomplete)'
  
• 35077128 [VOS RESRC MGR] ORA-600 [15709] - kxfpqsrls due to cpurm and dead sessions
  
• 36273767 [TXN MGMT LOCAL] ORA-1578: oracle data block corrupted on tempfile even after 35904282, 35733946
  
• 35286895 [KPDB] Switchover/Failover Failing for Backup-Based Cadg : ORA-1113: File 3013 Needs Media Recovery
  
• 36480774 [RECOVERY] Slow Opening of database in RAC database for other instance
  
• 36366069 [BLOCK TRACK] CPU spinning on CTWR and reports ORA-32701 / instance crash post 19.21 DBRU on standby
  
• 35998116 [DBSEC_PRIVS] PLS-00801: internal error [pgm.c:pgmrcm 4] from internal trigger compilation
  
• 36228325 [RMAN] Backup check logical fails with code:6057 when block is encrypted
  
• 36386686 [BUFFER CACHE] ORA-600 [kcbnlc2_1] - kcbnlc2
  
• 35985645 [PARTITIONING] Instance crash with ORA-600 [kdifind:kcbz_objdchk]
  
• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
  
• 35692839 [VOS-IPC] ORA-600 [ipc_recreate_que_2] [2] [8]" During Live Migration
  
• 34774667 [AQ] ORA-7445 in Purge Queue Table / High CPU usage in SVCB Service
  
• 31061145[RAC] Remove requirement to set TARGET_PDBS for RAC on multitenant deployments in 18c onwards
  
• 29213893[QRY OPTIMIZER] DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table

Version DB 19.22_555.1: 35925654,35663882,36065162,34547607,36285197,36158909,35077128,36273767,35286895,36480774,36366069,35998116,36228325,36386686,35985645,34672698,35692839,34774667,31061145,29213893
Recommended Patches for 19.22 GI Home
Below is the list of important patches to consider applying on top of 19.22. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.
Only one OCW (Oracle Clusterware) patch should be applied to GI homes. Ensure you apply the patch starting with X8M if you are on an X8M system

• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)

Version GI 19.22_555.1: 34672698
Recommended Patches for 19.21 DB Home
Below is the list of important patches to consider applying on top of 19.21. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.

• 35925654 [ROW CACHE] Sessions Deadlock on Row Cache Mutex and Shared Pool Latch
  
• 35663882 [RMAN] Many Sessions are Blocked by CF Enqueue Contention
  
• 36065162 [EXTENSIBILITY] ORA-7445 [qkaual_get_selexp] with pipelined function in union all in 19.20
  
• 34547607 [TXN MGMT LOCAL] ORA-600 [ktugct: corruption detected] w/ Compression & RAC DB Instances Crash
  
• 36285197 [RAC] ORA-4021: timeout occurred while waiting to lock object and/or Global Cache Performance Issues
  
• 36158909 [RAC] DB Hung Wating For 'log file switch (checkpoint incomplete)'
  
• 35077128[VOS RESRC MGR] ORA-600 [15709] - kxfpqsrls due to cpurm and dead sessions
  
• 36273767 [TXN MGMT LOCAL] ORA-1578: oracle data block corrupted on tempfile even after 35904282, 35733946
  
• 35286895 [KPDB] Switchover/Failover Failing for Backup-Based Cadg : ORA-1113: File 3013 Needs Media Recovery
  
• 36480774 [RECOVERY] Slow Opening of database in RAC database for other instance[list-patches]YES YES 27-APR-2024
  
• 36366069 [BLOCK TRACK] CPU spinning on CTWR and reports ORA-32701 / instance crash post 19.21 DBRU on standby
  
• 35998116 [DBSEC_PRIVS] PLS-00801: internal error [pgm.c:pgmrcm 4] from internal trigger compilation
  
• 36228325 [RMAN] Backup check logical fails with code:6057 when block is encrypted
  
• 36386686 [BUFFER CACHE] ORA-600 [kcbnlc2_1] - kcbnlc2
  
• 35985645 [PARTITIONING] Instance crash with ORA-600 [kdifind:kcbz_objdchk]
  
• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
  
• 35692839 [VOS-IPC] ORA-600 [ipc_recreate_que_2] [2] [8]" During Live Migration
  
• 35843249 [RAC] LMS Hit ORA-600[kjblpgorm:!antilock]
  
• 35702932 [VOS] ORA-600 ipc_recreate_que_2 While Running Stress Workload
  
• 35813895 [VOS-IPC] Throw a Fatal Error If memlock limits Are Not Configured As Expected
  
• 35836860 [BUFFER CACHE] ORA-600 [kclmergepifd_1] during normal processing
  
• 35403248 [RAC] Many Sessions Hang Waiting For 'free buffer waits'[list-patches]YES 07-NOV-2023
  
• 34774667 [AQ] ORA-7445 in Purge Queue Table / High CPU usage in SVCB Service
  
• 31061145 [RAC] Remove requirement to set TARGET_PDBS for RAC on multitenant deployments in 18c onwards
  
• 29213893 [QRY OPTIMIZER] DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table

Version DB 19.21_555.1: 35925654,35663882,36065162,34547607,36285197,36158909,35077128,36273767,35286895,36480774,36366069,35998116,36228325,36386686,35985645,34672698,35692839,35843249,35702932,35813895,35836860,35403248,34774667,31061145,29213893
Recommended Patches for 19.21 GI Home
Below is the list of important patches to consider applying on top of 19.21. In addition to the relevant patches listed below, you should also review patches in Database PSU/BP/Update/Revision - Known Issues Primary Note(Doc ID 1227443.1) and Oracle Database Patches to Consider for 19c (Doc ID 2781612.2) which contains patches to consider for specific areas such as Data Pump, Golden gate etc.
Only one OCW (Oracle Clusterware) patch should be applied to GI homes. Ensure you apply the patch starting with X8M if you are on an X8M system

• 34672698 [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)

Version GI 19.21_555.1: 34672698

Recommended Patches for 19.24 DB Home

35663882: [RMAN] Many Sessions are Blocked by CF Enqueue Contention
36273767: [TXN MGMT LOCAL] ORA-1578: oracle data block corrupted on tempfile even after 35904282, 35733946
34672698: [VOS] DB50: ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
34774667: [AQ] ORA-7445 in Purge Queue Table / High CPU usage in SVCB Service
31061145: [RAC] Remove requirement to set TARGET_PDBS for RAC on multitenant deployments in 18c onwards
29213893: DBMS_STATS Failing With Error Ora-1422 When Gathering Stats for User$ Table
36582781: DATAPUMP BUNDLE PATCH 19.24.0.0.0
6880880: OPatch 12.2.0.1.43

Recommended Patches for 19.24 GI Home

34672698: [VOS] ORA-800: soft external error, arguments: [set priority failed], [vktm] , dism(16)
6880880: OPatch 12.2.0.1.43