• Post author:
  • Post category:Apex
  • Reading time:2 mins read
Oracle Apex 20.1 download page.

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

Vinish Kapoor

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

This Post Has 3 Comments

  1. saiful

    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

    1. Vinish Kapoor

      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

  2. VC Devati

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

Comments are closed.