Oracle Datapatch Failed with error "ORA-04063: view "SYS.WRR_ROOT_REPLAY_DATA" has errors"
(Doc ID 3058913.1)
Last updated on DECEMBER 11, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.24.0.0.0 and laterInformation in this document applies to any platform.
Linux x86-64
Symptoms
After applying 19.24 RU patch, post patching step - datapatch failed with errors
[2024-10-24 20:44:31] Patch 36582781 apply (pdb PDB$SEED): WITH ERRORS
[2024-10-24 20:44:31] logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_<SID>_PDBSEED_2024Oct24_20_43_00.log[2024-10-24 20:44:31] (errors)
[2024-10-24 20:44:31] -> Error at line 4119: script rdbms/admin/backport_files/bug_36104744_apply.sql
[2024-10-24 20:44:31] - ORA-04063: view "SYS.WRR_ROOT_REPLAY_DATA" has errors
::::::::::::::::::
[2024-10-24 20:44:31] Patch 36582781 apply (pdb <PDB>): WITH ERRORS
[2024-10-24 20:44:31] logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_<SID>_<PDB>_2024Oct24_20_43_16.log[2024-10-24 20:44:31] (errors)
[2024-10-24 20:44:31] -> Error at line 4119: script rdbms/admin/backport_files/bug_36104744_apply.sql
[2024-10-24 20:44:31] - ORA-04063: view "SYS.WRR_ROOT_REPLAY_DATA" has errors
[2024-10-24 20:44:31] logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_<SID>_PDBSEED_2024Oct24_20_43_00.log[2024-10-24 20:44:31] (errors)
[2024-10-24 20:44:31] -> Error at line 4119: script rdbms/admin/backport_files/bug_36104744_apply.sql
[2024-10-24 20:44:31] - ORA-04063: view "SYS.WRR_ROOT_REPLAY_DATA" has errors
::::::::::::::::::
[2024-10-24 20:44:31] Patch 36582781 apply (pdb <PDB>): WITH ERRORS
[2024-10-24 20:44:31] logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/36582781/25751445/36582781_apply_<SID>_<PDB>_2024Oct24_20_43_16.log[2024-10-24 20:44:31] (errors)
[2024-10-24 20:44:31] -> Error at line 4119: script rdbms/admin/backport_files/bug_36104744_apply.sql
[2024-10-24 20:44:31] - ORA-04063: view "SYS.WRR_ROOT_REPLAY_DATA" has errors
Changes
Fixes for Bug 37010561 and Bug 37077352 are applied
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |