Learn how to upgrade to the latest Oracle Application Express release.
To upgrade to the latest Oracle Application Express release:
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:\
.
apex
.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:\
.
@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/
@apex_epg_config.sql APEX_HOME
Tip:
APEX_HOME
is the directory you specified when unzipping the file. For example, on Windows C:\
.
apxchpwd.sql
:
@apxchpwd.sql
When prompted, enter a password for the ADMIN
account.
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 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.
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.