APEX Version 4/5/../18 on 12c database

 

Install APEX 

@apexins.sql sysaux syaux temp /i/

SQL> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';

COMP_NAME                             VERSION                        STATUS
-----------------------------------------------------------------------------------

Oracle Application Express          4.2.5.00.08                        VALID

Change the APEX admin Password

@apxchpwd.sql

Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users

@apex_rest_config.sql

Decide the gateway to use to access APEX.

Here we are using Embedded PL/SQL Gateway (EPG) Configuration.

@apex_epg_config.sql O:\XX_APEX\apex_18.2  --> It is used to load the images.

col USERNAME for a30
set pages 1000 lines 1000
select username,created,account_status,default_tablespace,temporary_tablespace from dba_users where username like '%APEX%';

User Accounts Settings
alter user APEX_REST_PUBLIC_USER identified by Oracle#123 account unlock;
alter user APEX_PUBLIC_USER identified by Oracle#123 account unlock;
alter user APEX_INSTANCE_ADMIN_USER identified by Oracle#123 account unlock;
alter user APEX_180200  identified by Apex#123 account unlock;
ALTER USER anonymous identified by Oracle#123;

ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;

CREATE ACL to add APEX User
begin

  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
    acl => 'network_services.xml',
    description => 'NETWORK ACL',
    principal => 'APEX_180200',
    is_grant => true,
    privilege => 'connect');
 
  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
    acl => 'network_services.xml',
    principal => 'APEX_180200',
    is_grant => true,
    privilege => 'resolve');
 
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'network_services.xml',
    host => '*');
   COMMIT;
 END;
 /

Access APEX using URL

  < http:hostname:PORT/apex >