D Upgrading Oracle APEX within Oracle Database Express Edition

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

Tip:

Upgrading Oracle 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 Oracle APEX on Oracle Database XE.

Tip:

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

• Upgrading to the Latest Oracle APEX Release
  Learn how to the latest Oracle APEX release.

D.1 Upgrading to the Latest Oracle APEX Release

Learn how to the latest Oracle APEX release.

To upgrade to the latest Oracle APEX release:

1. Download the latest version of Oracle APEX from the download page. See:

   http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

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 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 Oracle APEX:

   @apexins.sql tablespace_apex tablespace_files tablespace_temp images

   Where:

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

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

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

   • images is the virtual directory for Oracle APEX images. To support future Oracle 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 Oracle APEX and Oracle REST Data Services.
7. Upgrade the Oracle APEX password by running apxchpwd.sql:

   @apxchpwd.sql
   

   When prompted, enter a password for the ADMIN account.

8. Navigate to the Oracle 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 Oracle APEX 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.