1. Installation Guide
  2. Upgrading APEX within Oracle Database Express Edition

D Upgrading APEX within Oracle Database Express Edition

Learn how to upgrade Oracle APEX included with Oracle Database Express Edition (XE) .

Tip:

Upgrading APEX does not change the Oracle Support policy for Oracle Database XE. Oracle Database XE is only supported on the Oracle OTN forums. Oracle Support will not answer questions about APEX on Oracle Database XE.

Tip:

To learn more about Oracle Database XE, see https://www.oracle.com/database/technologies/appdev/xe.html

D.1 Upgrading to the Latest APEX Release

Learn how to the latest Oracle APEX release.

To upgrade to the latest APEX release:

  1. Download the latest version of APEX from the download page. See:
  2. Unzip downloaded zip file:
    • UNIX and Linux: $ unzip filename.zip
    • Windows: Double-click filename.zip in Windows Explorer

    Tip:

    Keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to C:\.
  3. Change your working directory to apex.
  4. Start SQL*Plus and connect to the Oracle Database XE where APEX is installed as SYS specifying the SYSDBA role. For example:

    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

    • On UNIX and Linux:

      $ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

      Tip:

      Keep the directory tree where you unzip the files short and not under directories that contain spaces. For example, within Windows unzip to C:\.
  5. Install APEX:
    @apexins.sql tablespace_apex tablespace_files tablespace_temp images

    Where:

    • tablespace_apex is the name of the tablespace for the APEX application user.

    • tablespace_files is the name of the tablespace for the APEX files user.

    • tablespace_temp is the name of the temporary tablespace or tablespace group.

    • images is the virtual directory for APEX images. To support future APEX upgrades, define the virtual image directory as /i/.

    Example

    @apexins.sql SYSAUX SYSAUX TEMP /i/
  6. Configure ORDS for HTTP(s) access. See Installing and Configuring APEX and Oracle REST Data Services.
  7. Upgrade the APEX password by running apxchpwd.sql:
    @apxchpwd.sql

    When prompted, enter a password for the ADMIN account.

  8. Navigate to the APEX Administration Services application:

    1. In a Web browser, navigate to:

      http://hostname:port/apex/apex_admin

      Where:

      hostname is the name of the system where Oracle XML DB Protocol server is installed.

      port is the port number assigned to HTTP on the Oracle XML DB Protocol server. In a default installation, this number is 8080. If you are using the Oracle Database 12c or later multitenant architecture, then each pluggable database (PDB) will have a distinct port number.

      apex is the database access descriptor (DAD) defined in the configuration file.

    2. On the Sign In page:

      • Username - Enter admin.
      • Password - Enter the APEX administrator account password you specified in step 4.
      • Click Sign In to Administration.

    Note:

    depending on your setup, you may be required to change your password when you log in for the first time.

Parent topic: Upgrading APEX within Oracle Database Express Edition