When running datapatch against Oracle 19c database, it failes with error "ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'".
The datapatch output is something like following,
Patch 37960098 apply (pdb PDB01): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37960098/27641878/37960098_apply_CDB01_PDB01_2025Aug20_15_44_17.log (errors)
-> Error at line 140412: script rdbms/admin/owmcvws.plb
- ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'
- ORA-00604: error occurred at recursive SQL level 2
- ORA-04061: existing state of has been invalidated
- ORA-04061: existing state of package body "WMSYS.LT_CTX_PKG" has been
- invalidated
- ORA-04065: not executed, altered or dropped package body "WMSYS.LT_CTX_PKG"
- ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_CTX_PKG"
- ORA-06512: at "WMSYS.LTADM", line 9800
- ORA-04061: existing state of package body "WMSYS.LT_CTX_PKG" has been
- invalidated
- ORA-04065: not executed, altered or dropped package body "WMSYS.LT_CTX_PKG"
- ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_CTX_PKG"
- ORA-06512: at "WMSYS.LTADM", line 9532
- ORA-06512: at "WMSYS.OWM_DYNSQL_ACCESS", line 549
- ORA-06512: at line 17
- ORA-06512: at line 7
- ORA-06512: at line 7
-> Error at line 142841: script rdbms/admin/owmcvws.plb
- ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'
- ORA-00604: error occurred at recursive SQL level 1
- ORA-04068: existing state of packages has been discarded
- ORA-04061: existing state of package body "WMSYS.LTUTIL" has been invalidated
- ORA-04065: not executed, altered or dropped package body "WMSYS.LTUTIL"
- ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTUTIL"
- ORA-06512: at "WMSYS.LTADM", line 9437
- ORA-06512: at "WMSYS.OWM_DYNSQL_ACCESS", line 544
- ORA-06512: at line 15
Solution
Disable the trigger which caused the issues, then re-run datapatch.
No comments:
Post a Comment