My Oracle Support Banner

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 later
Oracle 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


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