My Oracle Support Banner

Primary Note for Oracle Application Express (APEX) Upgrades (Doc ID 1088970.1)

Last updated on SEPTEMBER 08, 2021

Applies to:

Oracle Application Express (APEX) - Version 1.5 and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Details

This Note answers the most frequently asked questions about Oracle Application Express (APEX) installation upgrades. In addition to the Support Notes below, you can find supplementary infomation here:

Discussion Forum
Certification
and <Note 1344948.1> - Application Express (APEX) Database and Web Server Certification Reference
Documentation, Technical Brief and Demos

Documentation and downloads for earlier releases of Application Express (formerly known as HTML DB) can be found here.

Audience

The information contained in this targets product administrators and installers. You can use this information when planning future upgrades and installations.

Actions

Getting Started


For upgrading an Application Express installation, the best place to begin is with the Installation Guide and Release Notes. The most current version of Application Express can be found at https://www.oracle.com/technetwork/developer-tools/apex/overview/index.html by clicking on the "Documentation and Tutorials" link. Previous versions of the Oracle Application Express installation Guides can be found here.

Upgrade Overview

The basic steps for upgrading APEX are:

  1. Run the APEX installation script against the target database. The same script is used for new installations and upgrades. The script automatically senses whether there is a version of APEX present and automatically takes the appropriate action.
  2. Update the existing version of the /i/ virtual directory with the images, javascript, css, etc. with the current versions APEX installation medium.

Check Your Version

Prior to the Application Express (APEX) upgrade, begin by identifying the version of the APEX currently installed and the database prerequisites. To do this run the following query in SQLPLUS as SYS or SYSTEM:

Where <SCHEMA> represents the current version of APEX and is one of the following:

 

If the query returns 0, it is a runtime only installation, and apxrtins.sql should be used for the upgrade. If the query returns 1, this is a development install and apexins.sql should be used.

 

Determine the Upgrade Media

NOTE: APEX patches are not database version specific. Though the patch lists a specific database version, it can be applied to all databases where APEX is supported. Supported database versions can be found in the installation guide for your version.

The downloads for the current version of APEX can be found here. Older versions can be found here.

 

 

FAQ

I have configured APEX to use the Embedded PL/SQL Gateway (EPG)?  Is it possible to configure another web server to run against the same EPG APEX?

    EPG has been deprecated and not supported stating with APEX 20.2 but Yes, it is possible to configure more than one HTTP Server to run against the same database containing APEX.

Is it possible to use the EPG on one database to run APEX on another database? This is not possible due to a software restriction of the EPG.

Known Problems

The APEX installation guides indicate that the databases not associated with the install should be shut down. This step is not necessary, and is documented in <Bug 8851768> INSTALLATION GUIDE IMPLIES OTHER DATABASES SHOULD BE DOWN DURING INSTALLATION

The installation guides for APEX 3.2 and below do not reflect the commands and file locations for the Fusion Middleware Oracle HTTP Server (OHS) supplied on OTN for the 11.2 database.  Due to the timing of the 11.2 database release, the configuration information associated with the Web Tier OHS could not be included in the 3.2.1 APEX documentation. <Note 1070034.1> APEX Installation Guide Is Missing Configuration Information for Fusion Middleware 11.1.1 OHS: contains information on configuring APEX with the  Oracle Fusion Middleware Web Tier Utilities 11g (11.1.1.2.0) software.

 

Troubleshooting

<Note 1254932.1> APEX Installation Verification Script

Other References

<Note 389839.1> DBA_REGISTRY Shows Oracle Application Express Invalid
<Note 1286029.1> How to Prevent APEX 3.2.1 Installation when 10.2 DB Containing APEX 4.0 is Upgraded
<Note 304645.1> Troubleshooting MOD_PLSQL DAD issues during Installation of APEX / HTMLDB
<Note 283234.1> Receiving Failed to Login to APEX / HTMLDB Page - You Don't Have Permission to Access /pls/apex
<Note 471983.1> How to find whether DAD is configured in 11g database?
<Note 457621.1> How to Configure Oracle Application Express (APEX) & the Embedded PL/SQL Gateway (EPG) in an 11G DB External
<Note 469342.1> ORA-22288 When Running apex_epg_config.sql or apxldimg.sql 
<Note 604859.1> Apex Login Problem Using Embedded Pl/Sql Gateway 
<Note 361581.1> How to Change the ADMIN User Password for the Workspace INTERNAL
<Note 565952.1> Troubleshooting: The XDB Login Appears When Running APEX with the 11g Enterprise PL/SQL Gateway (EPG)
<Note 361581.1> How to Change the ADMIN User Password for the Workspace INTERNAL
<Note 555856.1> Installation of APEX Fails When PL/SQL Web Toolkit not Available in DB
<Note 558340.1> How To Uninstall Oracle HTML DB / Application Express from the Database
<Note 749733.1> FAQ on APEX Runtime Installation

 

Contacts

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
Details
Actions
 Getting Started
 Upgrade Overview
 Check Your Version
 Determine the Installation Type
 Determine the Upgrade Media
 
 FAQ
 Known Problems
 Other References
Contacts
References

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