Oracle Application Express release 5.0 requires an Oracle Database Release 188.8.131.52 or later, including Enterprise Edition and Express Edition (Oracle Database XE). If you are upgrading an Oracle Database version 12c CDB, you must download from My Oracle Support the one off patch for bug 20618595. Search for 20618595 on the Patches tab.
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,
SHARED_POOL_SIZE) instead, for a similar result.
See Also:Oracle Database Administrator's Guide
To check the
MEMORY_TARGET of the target database:
Start the database:
If necessary, enter the following command to determine whether the system uses an initialization parameter file (
initsid.ora) or a server parameter file (
SQL> SHOW PARAMETER PFILE;
This command displays the name and location of the server parameter file or the initialization parameter file.
Determine the current values of the
SQL> SHOW PARAMETER MEMORY_TARGET
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;
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).
Shut down the database:
Restart the database:
Mozilla Firefox 35
Google Chrome 40
Apple Safari 7
Microsoft Internet Explorer 9
You can develop Oracle Application Express applications that support earlier web browser releases (such as Microsoft Internet Explorer 7 and 8) using legacy themes. However, the minimum supported version of Microsoft Internet Explorer to run Oracle Application Express applications is Microsoft Internet Explorer 9.0. Oracle Application Express has a number of advanced widgets, such as trees, menus, rich text editors, and other 3rd party components, which may not work correctly on earlier browsers.
In order to run Oracle Application Express you must have access to one of the following:
Oracle REST Data Services release 2.0.3 or later
Oracle REST Data Services Listener is a Java-based Web server. It features file system caching, offers improved file upload capability, and is certified with Oracle WebLogic Server, Oracle Glassfish Server, and Apache Tomcat.
Embedded PL/SQL Gateway
Oracle XML DB Protocol Server with the Embedded PL/SQL Gateway installs with Oracle Database 11g Release 1 (11.1). It provides the database with a Web server and the necessary infrastructure to create dynamic applications.
Oracle HTTP Server and
Oracle HTTP Server uses the
mod_plsql plug-in to communicate with the Oracle Application Express engine within the Oracle database.
See Also:"Choosing a Web Listener"
Oracle Application Express disk space requirements are as follows:
Free space for Oracle Application Express software files on the file system: 265 MB if using English only download (
apex_5.0_en.zip) and 630 MB if using full download (
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
Oracle XML DB must be installed in the Oracle database that you want to use. 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.
See Also:Oracle XML DB Developer's Guide for more information about manually adding Oracle XML DB to an existing database
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.