Ameer Khan

Oracle Application Express 20.1 Installation Steps 

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

• Oracle Database Requirements

Oracle Application Express release 20.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE). Oracle Application Express can be installed in single-instance database and in Oracle Real Application Clusters (Oracle RAC) database.

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

• 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:-

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 u01]$ unzip apex_20.1_en.zip

[oracle@server3 apex]$ unzip apex_20.1_en.zip -d /u01/apex

Create a new tablespace for APEX.

oracle@server3 apex]$ sqlplus / as sysdba

 SQL> create tablespace apexdemo datafile ‘/u01/app/oracle/oradata/ora12c/apexd01.dbf’ size 2G autoextend on;

Installation

oracle@server3 apex]$ cd /u01/apex/apex

oracle@server3 apex]$ sqlplus / as sysdba

SQL> @apexins.sql

Enter value for 1: apexdemo

Enter value for 2: apexdemo

Enter value for 3: TEMP

Enter value for 4: /i/

P.S. For value 1 : Enter the tablespace name for apex application user

     For value 2 : Enter tablespace for apex file user

     For value 3 : Enter temporary tablespace for apex

     For value 4 : Enter virtual directory for apex images. Define the virtual   Directory as /i/

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 Application Express     20.1.0.00.13                   VALID

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

oracle@server3 apex]$ sqlplus / as sysdba

SQL>@apxchpwd.sql

Note: The password should contain one lower and uppercase character, one punctuation character, 

one numeric character and must not contain the username.

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

We will be using EPG configuration for this setup, however in release20.1 onwards the EPG configuration is deprecated. We will demonstrate ORDS configuration in another post.

Embedded PL/SQL Gateway (EPG) Configuration

So before moving ahead with the configuration make sure the following users are not locked.

SQL> ALTER USER anonymous ACCOUNT UNLOCK;

SQL> ALTER USER xdb ACCOUNT UNLOCK;

SQL> ALTER USER apex_public_user ACCOUNT UNLOCK;

SQL> ALTER USER flows_files ACCOUNT UNLOCK;

Change the following database parameters.

SQL>ALTER system SET shared_servers=5 scope=both;

Run the script “apex_epg_config.sql” from parent directory of apex installation directory.

SQL>@apex_epg_config.sql /u01/apex

Check the HTTP DB Port

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

———–

          0

As the port is currently set to ‘0’ Change it to a non-zero port.

SQL> EXEC DBMS_XDB.sethttpport(8080);

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

———–

       8080

Final Configuration Step

SQL>@/u01/apex/apex/apxconf.sql

      PORT

———-

      8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.

Default values are in brackets [ ].

Press Enter to accept the default value.

…set_appun.sql

================================================================================

This script can be used to change the password of an Application Express

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator’s username [ADMIN] User “ADMIN” exists.

Enter ADMIN’s email [admin]

Enter ADMIN’s password []

Changed password of instance administrator ADMIN.

Enter a port for the XDB HTTP listener [      8080]

…changing HTTP Port

SQL>

Login Page to APEX

From browser open the APEX login page

http://server3.soumya.com:8080/apex/apex_admin

Provide username: admin and password to login.

So this concludes the installation process of APEX in Linux.