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)'
No comments:
Post a Comment