Many ORA-24344 Errors Are Shown In Installation Log When Installing APEX 5.x Or Upgrading From Previous Version. (Doc ID 2373324.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

When installing or upgrading APEX 5.x, receive errors in install.log file stating ORA-24344.

All the errors are in creating trigger wwv_flow_upgrade_trg<1 - 133> as below:

///////////////////////////////////////////////////////////////////////////////////////
-- Now beginning upgrade. This will take several minutes.--
-- Migrating metadata to new schema -------
ORA-24344: success with compilation error
...in create_upgrade_triggers for
...create or replace trigger wwv_flow_upgrade_trg1
before insert or update or
delete on WWV_FLOWS
begin

wwv_flow_error.raise_internal_error(p_error_code=>'WWV_FLOW_UPGRADE.METADATA_D
ML
_DISABLED');
end;
ORA-24344: success with compilation error
...in create_upgrade_triggers for
...create or replace trigger wwv_flow_upgrade_trg2
before insert or update or
delete on WWV_FLOW_APPLICATION_GROUPS
begin

:
:

ORA-24344: success with compilation error
...in create_upgrade_triggers for
...create or replace trigger wwv_flow_upgrade_trg133
before insert or update or
delete on WWV_PURGE_WORKSPACE_RESPONSES
begin

wwv_flow_error.raise_internal_error(p_error_code=>'WWV_FLOW_UPGRADE.METADATA_D
ML
_DISABLED');
end;
timing for: Upgrade metadata 1
Elapsed: 00:00:34.86

Cause

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