Oracle Apex 23.2 Installation and configuration on Linux - Part I

Oracle Application Express 23.2 Installation Steps 

 

Before installing Oracle Application Express, you must verify your configuration meets the minimum installation requirements.

•                Oracle Database Requirements

Oracle Application Express release 23.2 requires an Oracle Database release 19c or later, including Enterprise Edition and Standard Edition (SE) and Database 23c Free. Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters (Oracle RAC) database.

 

·       Browser Requirements
Oracle APEX requires a JavaScript-enabled browser and supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, and Microsoft Edge.

 

·       Web Server Requirements
Oracle APEX requires Oracle REST Data Services (ORDS) 20.x or later. The use of Quick SQL requires Oracle REST Data Services (ORDS) 23.3 or later.

 

•        MEMORY_TARGET of the Target Database

Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB.

•                Checking the WORKAREA_SIZE_POLICY of the Target Database
For the Oracle APEX installation or upgrade process, the WORKAREA_SIZE_POLICY session parameter must be set to AUTO.

SQL> alter system set WORKAREA_SIZE_POLICY=auto scope=both;

 

•        Oracle XML DB Requirement

Oracle XML DB must be installed in the Oracle database that you want to use if you are installing a full development environment. Oracle XML DB is not required for runtime only installations. If you are using a preconfigured database created either during an installation or by Database Configuration Assistant (DBCA), Oracle XML DB is already installed and configured.

 

Download Link: -

Oracle Application Express can be downloaded from HERE 

Environment details: -

OS	RHEL 7.9
IP	192.168.0.106
HOSTNAME	Server3.soumya.com
APEX VERSION	23.2
DB VERSION	19.3.0

 Once downloaded, unzip the software to begin the installation.

Create a directory where the apex software will be installed.

[oracle@server3 u01]$ mkdir -p /u01/apex

[oracle@server3 apex]$ unzip apex_23.2.zip -d /u01/apex

 

 

Create a new tablespace for APEX.

[oracle@server3 apex]$ sqlplus / as sysdba  SQL> create tablespace APEX datafile '/u01/app/oradata/ORCL/apexd01.dbf' size 2G autoextend on;

 

Apex Installation: -

[oracle@server3 apex]$ cd /u01/apex/apex [oracle@ocisoumya apex]$sqlplus / as sysdba SQL>@apexins.sql APEX APEX TEMP /i/   -- i refers image location in application. APEX refers the tablespace name , TEMP refers the temporary tablespace name.

Once the installation is complete, confirm it by running following query

SYS> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';   COMP_NAME                      VERSION             STATUS ------------------------------ ------------------------------ ----------- Oracle APEX                            23.2.0                   VALID

To change the admin password using “apxchpwd.sql” script as sys user.

SQL> @apxchpwd.sql ...set_appun.sql ================================================================================ This script can be used to change the password of an Oracle APEX instance administrator. If the user does not yet exist, a user record will be created. ================================================================================ Enter the administrator's username [ADMIN] User "ADMIN" does not yet exist and will be created. Enter ADMIN's email [ADMIN] Enter ADMIN's password [] Created instance administrator ADMIN.

   For configuring static files, we must run apex_rest_config.sql after a new installation of Oracle          APEX.

SQL> @apex_rest_config.sql   Enter a password for the APEX_LISTENER user              [] Enter a password for the APEX_REST_PUBLIC_USER user              [] ...set_appun.sql ...setting session environment ...create APEX_LISTENER and APEX_REST_PUBLIC_USER users ...grants for APEX_LISTENER and ORDS_METADATA user

      Configure APEX

            Now there are two ways which we can use to access APEX.

1.    Oracle REST Data Services(ORDS)

2.    Embeded PL/SQL Gateway(EPG) Configuration

However Oracle recommendation is ORDS.

create  a custom profile and assign the profile to  standard users to avoid user lock issues.

CREATE PROFILE app_user1 LIMIT    FAILED_LOGIN_ATTEMPTS unlimited    PASSWORD_LIFE_TIME unlimited    PASSWORD_REUSE_TIME unlimited    PASSWORD_REUSE_MAX unlimited    PASSWORD_VERIFY_FUNCTION NULL    PASSWORD_LOCK_TIME unlimited    PASSWORD_GRACE_TIME unlimited;

Alter all apex related users to assign custom profile.

select username,account_status from dba_users where username like ('%APEX%');   ALTER USER APEX_230200 PROFILE app_user1; ALTER USER APEX_LISTENER PROFILE app_user1; ALTER USER APEX_REST_PUBLIC_USER PROFILE app_user1; ALTER USER APEX_PUBLIC_USER  PROFILE app_user1;

Unlock the users:-

ALTER USER APEX_LISTENER identified by Concept_ora1 account unlock; ALTER USER APEX_REST_PUBLIC_USER identified by Concept_ora1 account unlock; ALTER USER APEX_PUBLIC_USER  identified by Concept_ora1 account unlock;

 

Execute following to grant connect privileges to any host for the APEX_230200 database user. This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role.

BEGIN   DBMS_NETWORK_ACL_ADMIN.append_host_ace (     host       => '*',     ace        => xs$ace_type(privilege_list => xs$name_list('connect','resolve'),                               principal_name => 'APEX_230200',                               principal_type => xs_acl.ptype_db)); END; /