My Oracle Support Banner

500 Internal Server Error, Internally: ORA-04068 and ORA-04065: not executed, altered or dropped stored procedure "WWV_FLOW_IMAGE_PREFIX" entering APEX URL after DB Server Bounced (Doc ID 2379288.1)

Last updated on APRIL 28, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

After  server reboot and database restarted, APEX environment 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
"APEX_050100.WWV_FLOW_IMAGE_PREFIX"
ORA-06508: PL/SQL: could not find program unit being called:
"APEX_050100.WWV_FLOW_IMAGE_PREFIX"
ORA-06512: at "APEX_050100.WWV_FLOW_GLOBAL", line 44
ORA-06512: at "APEX_050100.WWV_FLOW", line 561
...

 

 

Changes

Reboot / restart of the database server and the database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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