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;

Donate to support our blogging work

$1.00

Thanks
Ahmed

3 thoughts on “Installing Oracle Apex 5.1.4 on Oracle Database 12c R2

  1. hello I have a problem installing APEX 5.0 on oracle 12c. Start the installation, put several things on the screen and it stops, when I go to the .log there is no error, but a file is also created coreins5_catcon …. lst that has:
    validate_con_names: PDBORA is not open
    catconInit: Unexpected error returned by validate_con_names
    Does anyone have a solution for this problem?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s