Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page.
- For installations where the development will be in English only, download the file
apex_5.1_en.zip
from the Oracle Application Express download page. If the development will include languages other than English, downloadapex_5.1.zip
from the Oracle Application Express download page. See:Note that the actual file name may differ if a more recent release has shipped since this document was published.
- Unzip downloaded zip file:
If English only, unzip
apex_5.1_en.zip
as follows, preserving directory names:UNIX and Linux:
$ unzip apex_5.1_en.zip
Windows: Double click the file
apex_5.1_en.zip
in Windows Explorer
If multiple languages, unzip
apex_5.1.zip
as follows, preserving directory names:UNIX and Linux:
$ unzip
apex_5.1.zip
Windows: Double click the file
apex_5.1.zip
in Windows Explorer
Note:
You should keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to
C:TEMP
. - Change your working directory to
apex
. - Start SQL*Plus and connect to the database where Oracle Application Express is installed as
SYS
specifying theSYSDBA
role. For example: - Disable any existing password complexity rules for the default profile. See “Configuring Password Protection” in Oracle Database Security Guide.
- Select the appropriate installation option.
Full development environment provides complete access to the App Builder environment to develop applications. A Runtime environment enables users to run applications that cannot be modified.
Available installation options include:
Full development environment. Run
apexins.sql
passing the following four arguments in the order shown:Where:
tablespace_apex
is the name of the tablespace for the Oracle Application Express application user.tablespace_files
is the name of the tablespace for the Oracle Application Express files user.tablespace_temp
is the name of the temporary tablespace or tablespace group.images
is the virtual directory for Oracle Application Express images. For installations using EPG,/i/
is the required value for the images argument. To support future Oracle Application Express upgrades, define the virtual image directory as/i/
.
Example:
Note:
If you receive the following error, exit SQL*Plus and change your working directory to where you unzipped the installation file, for example
C:TEMP
in Windows, before starting SQL*Plus:SP2-0310: unable to open file 'apexins.sql
'Runtime environment. Run
apxrtins.sql
passing the following arguments in the order shown:Where:
tablespace_apex
is the name of the tablespace for the Oracle Application Express application user.tablespace_files
is the name of the tablespace for the Oracle Application Express files user.tablespace_temp
is the name of the temporary tablespace or tablespace group.images
is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as/i/
.
Example:
- XE Windows Client Download. Oracle Express Edition (XE) 10g Release 2 (10.2.0.1) Client for Microsoft Windows – OracleXEClient.exe (30,943,220 bytes) For installation on machines needing acces to XE (other than computer XE is installed on itself) Oracle XE 10G Windows Installation Tutorial.
- An Oracle Database XE installation will consume around 9 gigabytes of disk space under /opt.If this disk partition does not have the required disk space available, you must add space or mount an alternative partition as /opt/oracle.This disk partition is the defined Oracle Base where the.
When Oracle Application Express installs, it creates three new database accounts:
APEX_050100
- The account that owns the Oracle Application Express schema and metadata.FLOWS_FILES
- The account that owns the Oracle Application Express uploaded files.APEX_PUBLIC_USER
- The minimally privileged account is used for Oracle Application Express configuration with Oracle REST Data Services or Oracle HTTP Server andmod_plsql
.
Feb 10, 2017. Sep 26, 2013.
Note:
Download Oracle Xe 11
In an environment where EPG is used to access Oracle Application Express, the existing minimally privileged account ANONYMOUS
is used.
If you are upgrading from a previous release, then FLOWS_FILES
already exists and APEX_PUBLIC_USER
is created if it does not already exist.
Tip:
Oracle Application Express must be installed from a writable directory on the file system. See 'Reviewing a Log of an Installation Session.'
Oracle Xe Download Windows
See Also:
'Configuring Password Protection' in Oracle Database Security Guide
'About the Oracle Application Express Runtime Environment'
'SQL*Plus User's Guide and Reference for more information about SQL*Plus'
'Reviewing a Log of an Installation Session'