Wednesday, September 3, 2025

19c datapatch failed with error "ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'"

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: