Oracle Application Express

Info

This installation steps are based on Oracle APEX Version 24.2

Installing Oracle APEX into a PDB

Download Oracle APEX

Download Oracle APEX version 24.2 from https://www.oracle.com/tools/downloads/apex-downloads/

You can also use the direct link to download Oracle APEX version 24.2 https://download.oracle.com/otn_software/apex/apex_24.2_en.zip

After downloading upload apex_24.2_en.zip to /usr/local/src on the Server.

scp apex_24.2_en.zip root@<HOSTNAME>:/usr/local/src

Check the checksum of apex_24.2_en.zip

sudo -s
cd /usr/local/src

sha256sum apex_24.2_en.zip
6ffdc0cfc85d08015db2aaac5ae6b7b313adc764e183667120768111d7e1f8d2

Install Oracle APEX 24.2 into a PDB

su - oracle
cdb     # Change to Oracle Base (/opt/oracle)
unzip /usr/local/src/apex_24.2_en.zip

cd.apex     # Change to ${APEX_HOME}

sq
SQL> alter session set container=PDBICATSTST;
Session altered.

-- IMPORTANT: Choose the correct PDB
-- apexins.sql: Development environment
-- apxrtins.sql: Production environment (should be used on a production environment)
SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

Oracle APEX is installed in the APEX_240200 schema.

The structure of the link to the Oracle APEX Administration Services is as follows:
http://host:port/ords/apex_admin

The structure of the link to the Oracle APEX development environment is as follows:
http://host:port/ords/apex

SQL> exit

Creating Instance Administration Account

Run the apxchpwd.sql script to create and update your Instance Administrator account.

cd.apex_home     # ${APEX_HOME}
sq

SQL> alter session set container=PDBICATSTST;
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]
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Created instance administrator ADMIN.

Configuring the APEX_PUBLIC_USER Account

warning

It is important to correctly configure the APEX_PUBLIC_USER account to enable proper operation of Oracle APEX.

sq
SQL> alter session set container=PDBICATSTST;
SQL> alter user APEX_PUBLIC_USER account unlock;
SQL> alter user APEX_PUBLIC_USER identified by "pwd"; 

Configuring RESTful Services

Execute SQL script apex_rest_config.sql

sq
SQL> alter session set container=PDBICATSTST;
SQL> @apex_rest_config.sql
PL/SQL procedure successfully completed.

Enter a password for the APEX_LISTENER user              []
Enter a password for the APEX_REST_PUBLIC_USER user              []