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 laterOracle 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 |