Oracle Application Express (APEX) Installation

To install Oracle Application Express (APEX), you can follow these general steps:

Download the APEX software.

• https://www.oracle.com/tools/downloads/apex-downloads.html

Unzip the software either on your client PC if you intend to install it from there using the SQL*Plus client on your PC, or on the database server if you intend to install it from there. The latter will be more efficient as you will reduce the network traffic between the SQL*Plus client and the database server.

Create a new tablespace to act as the default tablespace for APEX.

conn sys/pass as sysdba

1CREATE TABLESPACE apex 
2
3    LOGGING 
4
5    DATAFILE 'D:\Oracle\database\oradata\ORCL\apex.dbf' SIZE 500M 
6
7    AUTOEXTEND 
8
9    ON NEXT  100M MAXSIZE UNLIMITED;

Change directory to the directory holding the unzipped APEX software.

$ cd /home/oracle/apex

 CONN sys@pdb1 AS SYSDBA

1ALTER SESSION SET CONTAINER = <PDB_name>;

1@apexins.sql APEX APEX TEMP /i/

Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.

1@apxchpwd.sql

  Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.

1@apex_rest_config.sql

  Unlock the account.  

1ALTER USER APEX_LISTENER IDENTIFIED BY gooadmin ACCOUNT UNLOCK;
2ALTER USER APEX_PUBLIC_USER IDENTIFIED BY gooadmin ACCOUNT UNLOCK;
3ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY gooadmin ACCOUNT UNLOCK;
4ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY gooadmin ACCOUNT UNLOCK;