Oracle Apex 20.1 download page.

Installing Oracle Apex 20.1

by

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

3 thoughts on “Installing Oracle Apex 20.1”

  1. 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

    Reply

    • On multitenant architecture, you should install Oracle Apex on PDB not on CDB.

      So before running any script, you have to set your default PDB. For example:

      ALTER SESSION SET CONTAINER = YOURPDB12C;

      or if your PDF is down, then you have to start it. You can check the following post and see if it helps you Install Oracle Apex on Multitentant

Leave a Comment