Database Server Bounced, APEX URL Get 500 Internal Server Error, Internally: ORA-04068 and ORA-04065: not executed, altered or dropped stored procedure "WWV_FLOW_IMAGE_PREFIX"
(Doc ID 2379288.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Application Express (APEX) - Version 5.1.0 and later
Information in this document applies to any platform.
After database restart and server reboot, APEX environment getting showing an "Internal Server 500" error and can't access APEX development or instance administration pages. In addition, running apxchpwd.sql, reset_image_prefix.sql or selecting most of the APEX views (ex. APEX_APPLICATIONS) get the following errors:
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "APEX_050100.WWV_FLOW_GLOBAL", line 44
ORA-06512: at "APEX_050100.WWV_FLOW", line 561
Reboot / restart of the database server and the database.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!