APEX 20.1 Installation steps for Windows

1- After download the apex_20.1.zip file extract the contents to c:\apex201\apex folder.
2- Open cmd and go  inside this path C:\apex201\apex
3- Connect as sys user:  sqlplus / as sysdba
4- After connecting to sqlplus run the installation script: @apexins.sql SYSAUX SYSAUX TEMP /i/
At the end of the script you will receive as below output:
Oracle Application Express is installed in the APEX_200100 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:35.41
timing for: Complete Installation
Elapsed: 00:23:58.38

PL/SQL procedure successfully completed.





1 row selected.

Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

C:\apex201\apex>


5- Connect again as sys user:  sqlplus / as sysdba
6- After connecting to sqlplus run the installation script: @apxchpwd.sql, provide instance admin password:
...set_appun.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" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.



7- Connect again as sys user:  sqlplus / as sysdba  and run script
@apex_epg_config.sql  C:\apex201

8- Unlock users  users by run below scripts:

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Tahaluf_123;

9- Configure Apex RESTful Services, run and provide passwords:
@apex_rest_config.sql

10- Set the http port:

EXEC DBMS_XDB.SETHTTPPORT(9191);

11- Run below script to configure ACL Prior to Oracle Database 12c database:
/* Then run the below script */
Declare
    acl_path Varchar2(4000);
Begin
  -- Look for the ACL currently assigned to '*' and give APEX_200100
  -- the "connect" privilege if APEX_200100 does not have the privilege yet.
    Select
        acl
    Into acl_path
    From
        dba_network_acls
    Where
        host = '*'
        And lower_port Is Null
        And upper_port Is Null;

    If dbms_network_acl_admin.check_privilege(acl_path, 'APEX_200100', 'connect') Is Null Then
        dbms_network_acl_admin.add_privilege(acl_path, 'APEX_200100', true, 'connect');
    End If;

Exception
  -- When no ACL has been assigned to '*'.
    When no_data_found Then
        dbms_network_acl_admin.create_acl('power_users.xml', 'ACL that lets power users to connect to everywhere', 'APEX_200100',
        true, 'connect');
        dbms_network_acl_admin.assign_acl('power_users.xml', '*');
End;
/

Commit;

for Oracle Database 12c or later run the following script:
/* Then execute the below script */
Begin
    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
        host => '*',
        ace => xs$ace_type(privilege_list => xs$name_list('connect'),
                           principal_name => 'APEX_200100',
                           principal_type => xs_acl.ptype_db));
End;
/


11- Access using the url http://localhost:8181/apex/apex_admin

12 - Execute the following as sys user:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
ALTER USER ANONYMOUS IDENTIFIED BY Tahaluf_123;