Description

While upgrading APEX 4.1 to APEX 5.0 on database 11.2.0.3 and Oracle Embedded PL/SQL Gateway (EPG) an issue occurred. The installation didn’t work anymore. Following message was displayed before the login page was even loaded:

APEX 5 Upgrade Issue notification

Error popup before login page is displayed

The message says, in essence, that the static files of the APEX installation cannot be found. There is a solution shipped with the installation files, a script named apex_epg_config.sql. Run this and by this reconfigure the EPG. This should fix the APEX 5 upgrade issue.

Example

  1. Navigate to a directory where you unzipped the APEX sources.
  2. Login to database as user with sysdba priviliges using sqlplus.
  3. Execute the folling command in sqlplus, the directory shown here is an example. You have to enter the directory in which you unzipped the Apex sources.
@apex_epg_config.sql /app/oracle/apex

After that the issues with the configuration of the static files should be solved. The steps

You can find a detailed description in the documentation https://docs.oracle.com/cd/E59726_01/install.50/e39144/epg.htm#HTMIG29459

Wir bleiben für Sie da!

In unserem neusten Blog-Beitrag sprechen wir mit zwei neuen Mitarbeitern, die Mitten in der Corona-Krise bei virtual7 angefangen haben.

Welche Eigenheiten und Herausforderungen einen Jobwechsel in dieser Zeit bedeuten und wie ihr erster Arbeitstag im Home-Office ausgesehen hat, erfahren Sie in diesem Beitrag.