How to Install Oracle APEX on Oracle Linux 9

In this tutorial, we will learn how to install Oracle APEX on Oracle Linux 9. The version that we are going to install is APEX 24.2. Before we continue, you might wonder what is Oracle Apex? Oracle APEX (Application Express) is a low-code development platform for building web applications on Oracle Database. It allows users to create scalable and secure apps with minimal coding, using a browser-based interface.

Key Features:

Low-Code Development – Drag-and-drop UI with declarative components.
Rapid Application Development – Quickly build and deploy web apps.
Built-in Security – Integrated authentication, authorization, and data protection.
Responsive UI – Apps work on desktop, tablet, and mobile.
SQL & PL/SQL Integration – Natively supports Oracle Database features.
Cloud & On-Prem Deployment – Can run on Oracle Cloud, on-premises, or in a hybrid environment.

Ideal for business applications, dashboards, and internal tools, Oracle APEX simplifies database-driven web app development.

Steps to Install Oracle Apex on Oracle Linux 9

In this example, we are going to install Oracle Apex on local server. I installed my Oracle Linux 9 on Proxmox host.

Step 1. Install Oracle Database

Oracle Apex needs Oracle Database to run. APEX is a web-based development framework that is tightly integrated with the Oracle Database and relies on it for:

Why Oracle Database is Required?

Storage – APEX applications, users, and metadata are stored within the database.
Processing – APEX uses PL/SQL for logic execution and processing.
Security – Authentication and authorization are managed within the database.
Data Handling – Queries, reports, and dashboards are built directly on database tables.

Supported Oracle Database Editions for APEX:

Oracle Database Express Edition (XE) – Free and lightweight, good for small apps.
Oracle Database Standard Edition (SE) – For mid-sized applications.
Oracle Database Enterprise Edition (EE) – For large-scale, enterprise-grade applications.

APEX can run on-premises or in the cloud, including Oracle Autonomous Database, which comes pre-configured with APEX.

Read how to install Oracle Database on Oracle Linux 9.

Step 2. Download Oracle APEX

Download the latest version of Oracle APEX from the link below. Save it in your Download folder.

https://www.oracle.com/tools/downloads/apex-downloads

I use this command to download the Oracle APEX 24.2 – English language only version.

wget https://download.oracle.com/otn_software/apex/apex_24.2_en.zip

Step 3. Extract Oracle Apex package

I will extract the Oracle Apex files to /opt/oracle/product/APEX folder. First, I will create the folder. You can put your installation folder anywhere, doesn’t have to be the same as mine below.

mkdir /home/oracle/APEX

And then extract the zip file

sudo unzip apex_24.2_en.zip -d /home/oracle/APEX/

Step 4. Configure the Database and Install Apex

First change the working directory to the apex folder.

cd /home/oracle/APEX/apex

Connect to the database using sqlplus

sqlplus sys@localhost:1521/FREEPDB1 as sysdba

Once you are connected, let’s install the Apex with full development environment

@apexins.sql SYSAUX SYSAUX TEMP /i/

This process will take a while to complete.

Change Administrator Password

Use the command below to change the administrator password.

@apxchpwd.sql

Unlock APEX_PUBLIC_USER

Unlock the APEX_PUBLIC_USER account and set a new password using the following commands:

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <password>;

Finally, execute this command to configure APEX_Restful service

@apex_rest_config.sql

Step 4. Install Java

Please follow my previous guide to install Java on Oracle Linux 9. After installation, check your java version using this command

java --version

Step 5. Install ORDS (Oracle Rest Data Services) on Oracle Linux 9

First, add the repository

sudo tee /etc/yum.repos.d/oracle-software.repo <<EOF
[ol9_oracle_software]
name=Oracle Software for Oracle Linux 9 (\$basearch)
baseurl=https://yum.oracle.com/repo/OracleLinux/OL9/oracle/software/\$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=1
EOF

Install ORDS

sudo dnf install ords

Make sure there is no error

Now let’s configure ORDS. Use this command and then answer some questions during the interactive install

ords --config /etc/ords/config install

After this, we need to allow the firewall

firewall-cmd --permanent --zone=public --add-port=1521/tcp
firewall-cmd --permanent --zone=public --add-port=8080/tcp
firewall-cmd --reload

Step 6. Reset Image Prefix

In my case, when I try to open the ORDS web page, I got the following error:

To fix this issue, follow these steps:

In Terminal, change the working directory to the /home/oracle/APEX/apex/utilities

cd /home/oracle/APEX/apex/utilities

And then connect to the database

sqlplus sys@localhost:1521/FREEPDB1 as sysdba

And then execute this command

@reset_image_prefix.sql

And then enter the Oracle APEX image prefix, in my case : https://static.oracle.com/cdn/apex/24.2.0/

Now we can access our APEX admin. Use the admin user and password we created earlier.

http://192.168.100.246:8080/ords/apex_admin

Now we can start creating a new workspace for our users. I will not explain here about how to create a new workspace.

To access the ords, you can visit using the following address. Don’t forget to change the IP address with yours

http://192.168.100.246:8080/ords