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

9 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

  2. The following command is not working because datafile name is missing.
    CREATE TABLESPACE apex DATAFILE SIZE 300M AUTOEXTEND ON NEXT 10M;

    Like

  3. Datafile name is missing in folowing command.
    CREATE TABLESPACE apex DATAFILE SIZE 300M AUTOEXTEND ON NEXT 10M;
    I insurtted ‘APEX’ and use the following commad.
    CREATE TABLESPACE apex DATAFILE ‘apex’ SIZE 300M AUTOEXTEND ON NEXT 10M;
    Thanks

    Like

  4. I followed all the steps as stated in the post. After instalation is completed I tried following in my browser
    http://localhost:8080/apex/apex_admin
    It gave following message.
    There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it.
    Please guide me to solve this problem

    Like

  5. SQL>EXEC DBMS_XDB.sethttpport(8080);
    BEGIN DBMS_XDB.sethttpport(8080); END;
    *
    ERROR at line 1:
    ORA-44718: Port conflict in XDB Configuration file
    ORA-06512: at “XDB.DBMS_XDB”, line 560
    ORA-06512: at “XDB.DBMS_XDB”, line 585
    ORA-06512: at “XDB.DBMS_XDB”, line 640
    ORA-06512: at line 1

    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