My Oracle Support Banner

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 later
Information 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



 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.