Installation of Oracle Database 23ai and APEX 24.2 and ORDS 24.4 on Windows Step-by-Step

👀Watch The below video in my YouTube channel about Installation of Oracle Database 23ai and APEX 24.2 on Windows Step-by-Step 

✅Before starting check the System Requirements:

1. Operating System: Windows 10-11 or Windows Server 19-22
2. Memory: At least 4 GB RAM (8 GB or more recommended).
3. Disk Space: At least 20 GB of free space.
4. Administrator Access: You need administrative privileges to install software.

•  Install  Oracle Database 23ai on Windows:

👀I suggest you watch this video on my YouTube channel about this article

my_video

step1:

Download  Oracle Database 23ai from below Link

https://www.oracle.com/database/free/get-started/

you can also see the Installation Guide for Microsoft Windows:

https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinw/index.html

step 2:

after unzipping downloaded files then click setup.exe

step 3:

This is mandatory to have at least one pluggable database

in this step oracle start to configure LISTENER

• Install  APEX24.2 on Windows:

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

SQL>Alter session set container=freepdb1;

If you do not want to specify a datafile manually, you can enable Oracle Managed Files (OMF) using the DB_CREATE_FILE_DEST parameter:

 
SQL>ALTER SYSTEM SET DB_CREATE_FILE_DEST='/u02/oradata';

SQL>CREATE TABLESPACE apex_tbs datafile size 100m autoextend on;

SQL>select tablespace_name from dba_tablespaces;

SQL>@apexins.sql apex_tbs apex_tbs temp Images
SQL>@apxchpwd.sql

SQL> @apex_rest_config.sql --✹ TIP: This command Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users  

SQL>ALTER USER APEX_PUBLIC_USER IDENTIFIED BY APEX_PUBLIC_USER

ACCOUNT UNLOCK;

•  CONFIG ORDS 

Now you should install ORDS and actually, you need to install ORDS. because Without ORDS, APEX applications would not be accessible via a web browser.

👀 For more detail about ORDS and configuration follow the below article:

Install and Configure Oracle ORDS:https://lidagholizadeh.blogspot.com/2024/12/configure-ords-for-apex-242.html