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"
Last updated on APRIL 23, 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms