How to install Oracle Apex 18.1

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

CREATE TABLESPACE apex DATAFILE 'F:\app\Administrator\oradata\TEMPDB\apex_01.dbf' SIZE 1000M AUTOEXTEND ON NEXT 1M;

02 - Installation:
------------------

Change directory to the directory holding the unzipped APEX software.

D:\apex_18.1_en\apex

F:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus.exe /nolog

CONN sys/sys@tempdb AS SYSDBA

@apexins.sql APEX APEX TEMP /i/

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

CONN sys/sys@tempdb AS SYSDBA

@apxchpwd.sql

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

CONN sys/sys@tempdb AS SYSDBA

@apex_rest_config.sql

05 - Embedded PL/SQL Gateway (EPG) Configuration :
--------------------------------------------------

CONN sys/sys@tempdb AS SYSDBA

@apex_epg_config.sql D:\apex_18.1_en

06 - Unlock the ANONYMOUS account :
-----------------------------------

CONN sys/sys@tempdb AS SYSDBA

ALTER USER ANONYMOUS IDENTIFIED BY a;

alter user anonymous account unlock;


DECLARE
  l_passwd VARCHAR2(40);
BEGIN
  l_passwd := DBMS_RANDOM.string('a',10) || DBMS_RANDOM.string('x',10) || '1#';
  -- Remove CONTAINER=ALL for non-CDB environments.
  EXECUTE IMMEDIATE 'ALTER USER anonymous IDENTIFIED BY ' || l_passwd || ' ACCOUNT UNLOCK CONTAINER=ALL';
END;
/

07 - Check the port setting for XML DB Protocol Server:
-------------------------------------------------------

CONN sys/sys@tempdb AS SYSDBA

SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
          0

CONN sys/sys@tempdb AS SYSDBA

EXEC DBMS_XDB.sethttpport(8080);

08- Find the URL here :
-----------------------

http://localhost:8080/apex

workspace : TEST
UserName  : TEST
Password  : TEST

Schema    : Test/t@tempdb