Installing Oracle Apex 20.1

In this tutorial, I will show you how to install Oracle Apex 20.1 on Windows and Linux/Unix systems.

Installing Oracle Apex 20.1

Installation of Oracle Apex 20.1 is the same as the prior versions, such as 19.1. But there is slightly a difference in the network configuration.

So to install the Oracle Apex 20.1 on Windows and Linux/Unix systems, first download the Oracle Apex 20.1 and follow the steps from 1 to 10 from the below article:

• Install Oracle Apex 19.1 in Eleven Easy Steps

Enabling Network Services Prior to Oracle Database 12c

Then for the 11th step, run the following script for the Oracle database versions prior to 12c:

/* First connect as the SYS user with SYSDBA role */
sqlplus sys/syspsw@orcl as sysdba

/* 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:

Enabling Network Services for Oracle Database 12c and Later

/* First connect as the SYS user with SYSDBA role */ 
sqlplus sys/syspsw@orcl as sysdba

/* 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;
/

Now your installation and configuration are complete for Oracle Apex 20.1. You can open the Oracle Apex in a browser using the following URL:

http://localhost:8181/apex/apex_admin