My Oracle Support Banner

Upgrade development APEX installation to 5.0X on 12c DB fails and switch instance to Runtime Type (Doc ID 2191621.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Application Express (APEX) - Version 5.0.4.00.12 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
The required Patch 20618595 is listed by "opatch lsinventory -details" in the DB Oracle_Home

Symptoms


ACTUAL BEHAVIOR
---------------
After the Apex 5 upgrade using apexins.sql script

        - If one try to access the main admin page using http://<HOST>:<PORT>/ords/apex_admin one gets

                "Error ERR-7620 Could not determine workspace for application (4500). ORA-1403: no data found"

        - The development installation was converted to runtime only

        - Converting a Runtime Environment to a Full Development Environment using apxdvins.sqlin

                  Result on users and apex applications being removed



EXPECTED BEHAVIOR
-----------------------
Upgraded instance should be development too and users and applications should be available.



STEPS
-----------------------
1.- Bring in a Database from another environment (clone using datafiles) with apex 4.2.5 development in CDB
2. Upgrade APEX to 5.0.4 on the CDB (as the Installation is Multitenant with Apex on CDB)
3. Check the upgraded instance trying to access the main admin page: http://<HOST>:<PORT>/ords/apex_admin

LOGS

-----------------

In the Installation (Upgrade) logs one can see:

Changes

 DB Upgraded to 12c (12.1.0.2.X)

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.