Database Upgrade To 18.3 Breaks APEX: WWV_FLOW_SESSION_RAS, WWV_FLOW_WIZARD_API Invalid
(Doc ID 2528176.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 4.2 and laterOracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.
Symptoms
After using the Database Upgrade Assistant (DBUA) to upgrade from the 11.2.0.4 to 18c / 18.3, APEX requests fails with the following:
Error processing request:
ORA-6508: Could not find program unit being called
The failing URL is: http://<HOSTNAME>:port/ords/
Prior to the upgrade, this URL brought up the APEX login page.
A query of the database objects shows that the following are invalid:
APEX_NNNNNN.WWV_FLOW_SESSION_RAS / APEX_NNNNNN.WWV_FLOW_WIZARD_API
Only the database was upgraded.
This was an in place upgrade following the documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-scenarios-non-cdb-oracle-databases.html
- The initial configuration was rolled back.
- A new system was tested.
** APEX_050100.WWV_FLOW_SESSION_RAS / APEX_050100.WWV_FLOW_WIZARD_API invalid.
__________
SQL> alter package APEX_050100.WWV_FLOW_SESSION_RAS compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY APEX_050100.WWV_FLOW_SESSION_RAS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
242/9 PL/SQL: SQL Statement ignored
244/18 PL/SQL: ORA-00942: table or view does not exist
SQL>
SQL> alter package APEX_050100.WWV_FLOW_WIZARD_API compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY APEX_050100.WWV_FLOW_WIZARD_API:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8379/16 PL/SQL: SQL Statement ignored
8380/27 PL/SQL: ORA-00942: table or view does not exist
8385/9 PL/SQL: Statement ignored
8385/12 PLS-00364: loop index variable 'C1' use is invalid
SQL>
__________
Other information
_________________
* Oracle Database 18c Enterprise Edition Release 18.0.0.0.0
* APEX 5.1.4.00.08
* Invalids: WWV_FLOW_SESSION_RAS / WWV_FLOW_WIZARD_API
* The documents followed:
https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrade-scenarios-non-cdb-oracle-databases.html > "Manually Upgrading Non-CDB Architecture Oracle Databases"
Doc ID 2418045.1 (Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 18c).
Changes
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 |