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