Installing Oracle Apex 5.1.4 on Oracle Database 12c R2

This is a quick post on how to install Oracle Apex version 5.1.4 on Oracle Database 12.2 on Windows platform.

12cR2 Update:

From Oracle Database 12c Release 2 (12.2) onward APEX is not installed by default, so you no longer need to worry about uninstalling APEX before creating PDBs. The software is still shipped with the database ($ORACLE_HOME/apex), but not installed.

• In Oracle 12.2 you should always do the following.
  Download the latest version of APEX , rather than using the version shipped with the database from:

Downlaod the Latest Apex Release

• Install APEX locally in a PDB, rather than in the root container. You should not install APEX in the root container in Oracle 12.2.

Install Oracle Apex 5.1.4:

Open “cmd” window

cd d:\apex514\apex      — This is where you extracted the Apex software

sqlplus / as sysdba

CREATE TABLESPACE apex DATAFILE SIZE 300M AUTOEXTEND ON NEXT 10M;

@apexins.sql APEX APEX TEMP /i/

.

.

.

.

Thank you for installing Oracle Application Express 5.1.4.00.08
Oracle Application Express is installed in the APEX_050100 schema.
The structure of the link to the Application Express administration services is as follows: http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql) http://host:port/apex/apex_admin       (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

http://host:port/apex/apex_admin     (Oracle REST Data Services)
The structure of the link to the Application Express development interface is as follows: http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)

http://host:port/apex     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

http://host:port/apex     (Oracle REST Data Services)
timing for: Phase 3 (Switch)

Elapsed: 00:01:30.59

timing for: Complete Installation

Elapsed: 00:10:32.48
PL/SQL procedure successfully completed.

@apxchpwd.sql ============================================================================ This script can be used to change the password of an Application Express instance administrator. If the user does not yet exist, a user record will be created. ============================================================================ Enter the administrator’s username [ADMIN]

User “ADMIN” does not yet exist and will be created.

Enter ADMIN’s email [ADMIN]

Enter ADMIN’s password []

Created instance administrator ADMIN.
@apex_rest_config.sql

Enter a password for the APEX_LISTENER user              []

Enter a password for the APEX_REST_PUBLIC_USER user              []

…create APEX_LISTENER and APEX_REST_PUBLIC_USER users
@apex_epg_config.sql d:\apex514

. Loading images directory: d:\apex514/apex/images

timing for: Load Images

Elapsed: 00:01:46.18

SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

———–

0

EXEC DBMS_XDB.sethttpport(8080);

SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

———–

8080
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

ALTER USER XDB ACCOUNT UNLOCK;

ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK;

Thanks
Ahmed