Press "Enter" to skip to content

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

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
saiful
saiful
6 months ago

I am facing problem in installing oracle apex 20.1 after run command @apexins apex apex temp /i/ showing following error. can you help me please?

SQL> @apexins apex apex temp /i/
…set_appun.sql

PL/SQL procedure successfully completed.

…set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Performing installation in multitenant container database in the background.
The installation progress is spooled into apexins_cdb*.log files.

Please wait…

catcon: ALL catcon-related output will be written to [E:/apex_20.1/apexins_cdb_catcon_3896.lst]
catcon: See [E:/apex_20.1/apexins_cdb*.log] files for output generated by scripts
catcon: See [E:/apex_20.1/apexins_cdb_*.lst] files for spool files, if any
Use of uninitialized value $ENV{“ORACLE_HOME”} in concatenation (.) or string at D:\app\Dell\product\12.2.0\dbhome_1/rdbms/admin/catcon.pm line 8122.
catconInit: catcon_kill_sess_gen.sql not found at ORACLE_HOME, will instead use D:\app\Dell\product\12.2.0\dbhome_1\rdbms\admin/catcon_kill_sess_gen.sql

VC Devati
VC Devati
3 months ago

Is it correct to assume installing Apex 20.2 is also similar?