D.1 Upgrading to the Latest Oracle Application Express Release

Learn how to upgrade to the latest Oracle Application Express release.

To upgrade to the latest Oracle Application Express release:

  1. Download the latest version of Oracle Application Express 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 Oracle Application Express 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 Oracle Application Express:
    @apexins.sql tablespace_apex tablespace_files tablespace_temp images

    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

    @apexins.sql SYSAUX SYSAUX TEMP /i/
  6. Log back into SQL*Plus (as described in step 4) and load images:
    @apex_epg_config.sql APEX_HOME

    Tip:

    APEX_HOME is the directory you specified when unzipping the file. For example, on Windows C:\.

  7. Upgrade the Oracle Application Express password by running apxchpwd.sql:
    @apxchpwd.sql
    

    When prompted, enter a password for the ADMIN account.

  8. Navigate to the Oracle Application Express 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 Oracle Application Express administrator account password you specified in step 4.

      • Click Sign In to Administration.

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