2 Oracle Application Express Installation Requirements

Before installing Oracle Application Express in a on-premises (or local) installation you must verify your configuration meets the minimum installation requirements.

• Oracle Database Requirements
  Oracle Application Express release 20.2 requires an Oracle Database release 11.2.0.4 or later. Application Express runs on all database editions, including Enterprise Edition (EE), Standard Edition (SE) and Express Edition (XE). Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters (Oracle RAC) database.
• Checking the MEMORY_TARGET of the Target Database
  Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.
• Browser Requirements
  Oracle Application Express requires a JavaScript-enabled browser and supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.
• Web Listener Requirements
  Oracle Application Express requires access to the Web listener, Oracle REST Data Services (ORDS) 19.x or later.
• Disk Space Requirement
  Oracle Application Express disk space requirements are described in this section.
• Oracle XML DB Requirement
  Oracle XML DB must be installed in the Oracle database that you want to use if you are installing a full development environment. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

2.1 Oracle Database Requirements

Oracle Application Express release 20.2 requires an Oracle Database release 11.2.0.4 or later. Application Express runs on all database editions, including Enterprise Edition (EE), Standard Edition (SE) and Express Edition (XE). Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters (Oracle RAC) database.

If you are upgrading an Oracle Database version 12.1 CDB, you must download from My Oracle Support the one off patch for bug 20618595. Search for 20618595 on the Patches tab.

2.2 Checking the MEMORY_TARGET of the Target Database

Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.

Databases typically use automatic memory management, where the memory can be controlled by the server parameter MEMORY_TARGET. If your database does not use automatic memory management, consult the Oracle Database Administrator's Guide to find out how to configure manual memory parameters (for example, SGA_TARGET, PGA_AGGREGATE_TARGET, SHARED_POOL_SIZE) instead, for a similar result.

To check the MEMORY_TARGET of the target database:

1. Start the database:

   SQL> STARTUP
   

2. If necessary, enter the following command to determine whether the system uses an initialization parameter file (initsid.ora) or a server parameter file (spfiledbname.ora):

   SQL> SHOW PARAMETER PFILE;
   

   This command displays the name and location of the server parameter file or the initialization parameter file.

3. Determine the current values of the MEMORY_TARGET parameter:

   SQL> SHOW PARAMETER MEMORY_TARGET
   

4. If the value is 0, your database is using manual memory management. Consult the Oracle Database Administrator’s Guide to learn how to configure an equivalent memory size using manual memory management, instead of continuing with the steps that follow.

   If the system is using a server parameter file, set the value of the MEMORY_TARGET initialization parameter to at least 300 MB:

   SQL> ALTER SYSTEM SET MEMORY_TARGET='300M' SCOPE=spfile;
   

5. If the system uses an initialization parameter file, change the value of the MEMORY_TARGET parameter to at least 300 MB in the initialization parameter file (initsid.ora).
6. Shut down the database:

   SQL> SHUTDOWN
   

7. Restart the database:

   SQL> STARTUP
   

See Also:

Oracle Database Administrator’s Guide

2.3 Browser Requirements

Oracle Application Express requires a JavaScript-enabled browser and supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.

2.4 Web Listener Requirements

Oracle Application Express requires access to the Web listener, Oracle REST Data Services (ORDS) 19.x or later.

Oracle REST Data Services (ORDS) is Java-based Web Server. ORDS features the ability to emit RESTful web services, offers improved file upload capability, and is certified with Oracle WebLogic Server and Apache Tomcat.

2.5 Disk Space Requirement

Oracle Application Express disk space requirements are described in this section.

Oracle Application Express disk space requirements are as follows:

• Free space for Oracle Application Express software files on the file system: 310 MB if using English only download (apex_20.2_en.zip) and 705 MB if using full download (apex_20.2.zip).

• Free space in Oracle Application Express tablespace: 220 MB

• Free space in SYSTEM tablespace: 100 MB

• Free space in Oracle Application Express tablespace for each additional language (other than English) installed: 60 MB

2.6 Oracle XML DB Requirement

Oracle XML DB must be installed in the Oracle database that you want to use if you are installing a full development environment. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

Tip:

The installer does a prerequisite check for Oracle XML DB and will exit if it is not installed.

Tip:

The installation of Oracle XML DB creates the user ANONYMOUS. In order for Oracle Application Express workspace provisioning to work properly, the ANONYMOUS user must not be dropped from the database.

Tip:

For more information about manually adding Oracle XML DB to an existing database, see "Administration of Oracle XML DB"in Oracle XML DB Developer’s Guide