in

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:

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/[email protected] 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/[email protected] 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

Written by Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.org and orclqa.com a question and answer forum for developers.

guest

3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments