Friday, 6 February 2026

bug in DB RU 19.29 and 19.30 (January 2026)


Bug in DB RU 19.29 and 19.30 (January 2026)

Users is experiencing difficulties in downloading the Database Release Update 19.30.0.0.260120 (Patch 38632161) shortly after release.it is known issue and will be available shortly

 Oracle has temporarily withdrawn to download DB RU 19.29 and 19.30 (January 2026) from website

 both 19.29 and 19.30 are currently impacted by a critical bug (Bug 34352668), specifically affecting RAC (Real Application Cluster) environments. due to this bug ,database block and redo log corruption noticed after rolling updates to 19.29 (e.g., RU 19.28 to 19.29) on RAC databases. 

So it is encouraged to apply 19.30 if possible when it is available for download .

New 19.30 DB RU with the proper fix will be released shortly

It is also advised to postpone direct updates to 19.29 till new DB RU release 19.30 published

As a mitigation, set the hidden parameter “_gcs_recoverable_asserts” on any one RAC instance. 

If Oracle Data Guard is in use, apply this setting on both the primary and standby databases.


Recommendation: Oracle has temporarily paused the release of 19.30 and advises against applying 19.29 or 19.30 in RAC environments until a new patched version is available.

To check for lock state consistency across all instances

Please run below command

SQL> select sum(value) from gv$ges_statistics where name like 'number of triggered LSRs%';

Please verify fixes are in-place 

opatch lsinventory -bugs_fixed | egrep '^(34352668|38854064|38884142)'

To mitigate the issue, run the following SQL on any one RAC instance. 

If you use Oracle Data Guard, run these on both the primary and the standby databases.

Note : Downtime is not required 

SQL> ALTER SYSTEM SET "_gcs_recoverable_asserts" = 3 SCOPE = BOTH SID = '*';

SQL> ALTER SYSTEM RESET "_gcs_recoverable_asserts" SCOPE = BOTH SID = '*';


Please verify as below


SELECT

   a.ksppinm AS parameter,

   b.ksppstvl AS value,

   b.ksppstdf AS is_default,

   a.ksppdesc AS description

FROM

   x$ksppi a,

   x$ksppcv b

WHERE a.indx = b.indx AND a.ksppinm = '_gcs_recoverable_asserts';


Please verify fixes are in-place 

opatch lsinventory -bugs_fixed | egrep '^(34352668|38854064|38884142)'


Oracle Database 19c Proactive Patch Information (MOS KM Doc ID 2521164.1) - R19c Database Release Update Revision (Revision)
Critical Patch Update (CPU) Program Jan 2025 Patch Availability Document (DB-only) (MOS KM Doc ID KB160593) - DETAILS
Oracle Database 19c Release Update January 2025 Known Issues (MOS KM Doc ID 19202501.9) - Purpose
Oracle Database 19c Release Update January 2025 Known Issues (MOS KM Doc ID 3113613.1) - Purpose
Critical Patch Update (CPU) Program Apr 2025 Patch Availability Document (DB-only) (MOS KM Doc ID 3070732.1) - 6 Modification History
[OCI]: Primary Note For Oracle Database Cloud Service In OCI (Oracle Cloud Infrastructure) Environment (MOS KM Doc ID KB33189) - Database Patching
Oracle Database 19c Release Update January 2024 Known Issues (MOS KM Doc ID 19202401.9) - Purpose
Oracle Database 19c Release Update January 2024 Known Issues (MOS KM Doc ID 3113605.1) - Purpose

No comments:

Post a Comment