How to install Oracle Apex 24.1 with Apache Tomcat and Ords 24.1 in Database 19c on Windows

1. Required Downloads

1. Oracle Database 19c for Windows x64 (ZIP - 2.9 GB)

• Link: https://www.oracle.com/de/database/technologies/oracle19c-windows-downloads.html

2. Oracle APEX 24.1

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

3. Oracle REST Data Services (ORDS) 24.1

• link: https://www.oracle.com/database/sqldeveloper/technologies/db-actions/download/

4. SQL-Developer

• link: https://www.oracle.com/database/sqldeveloper/technologies/download/

5. Java

• Link: https://www.oracle.com/de/java/technologies/downloads/

6. Java

• Link: https://www.java.com/de/download/manual.jsp

7. XAMPP

• Link: https://www.java.com/de/download/manual.jsp

• XAMPP
• Link: https://www.apachefriends.org/de/download.html

2. Java Installation

To ensure your system is ready for Oracle Database and APEX installations, follow these steps to install Java:

1. Install the First Java File

• Run the installer and follow the on-screen instructions to complete the installation.

2. Install the Second Java File

• After the first file is installed, run the installer for the second file and follow the prompts.

3. Installation of Oracle DB 19c

Follow these steps to install Oracle Database 19c on your Windows system:

1. Unzip the Oracle Installation Folder

• After downloading, unzip the folder containing the Oracle Database 19c installation files.

2. Prepare the Installation Directory

• Move the unzipped files directly to your C: drive and rename the folder, for example, to C:\db_home.

3. Start the Installation

• Navigate to the C:\db_home directory and double-click the setup.exe file to start the setup process.

4. Enter Setup Details

• Base Path: Define the base directory for Oracle installations, e.g., C:\db_base
• Oracle Data Files Path: Specify the path for Oracle data files, e.g., C:\db_base\oradata
• Global Database Name: Set the global database name, e.g., orcl
• Database Name (PDB): Define the pluggable database name, e.g., orclpdb
• Administrator Password: Create a strong, secure password for the database administrator, e.g., Password1!

5. Installation Verification

• Review all settings before proceeding with the installation. Click 'Install' to begin the installation process.

6. Post-Installation Steps

• Ensure that the database services are running by checking the Services app in Windows.

4. Installation of SQL Developer

Follow these steps to install SQL Developer and test your database connection:

1. Unzip SQL Developer

• After downloading SQL Developer, unzip the folder to a convenient location on your system.

2. Move and Rename the Folder

• Move the unzipped SQL Developer folder directly to your C: drive and rename it, e.g., to C:\sql-developer.

3. Open SQL Developer and Set Up a New Connection

• Launch SQL Developer from the C:\sql-developer directory or from the desktop shortcut you created.
• Click on the "New Connection" button.
• Connection Name: Enter a descriptive name, e.g., db_sys_admin.
• Username: Use sys for administrative privileges.
• Password: Enter the password for your sys account, e.g., Password1!.
• Hostname: Enter localhost if your database is on the same machine as SQL Developer.
• Port: Typically, Oracle uses port 1521, but verify this during your Oracle installation.
• Service Name: Enter the service name of your database, e.g., orclpdb.

4. Save and Test the Connection

• Click "Save" to store the connection settings.
• Click "Test" to ensure that SQL Developer can connect to your Oracle database.

5. Why Test the Connection?

• Testing the connection ensures that all settings are correct and that SQL Developer can communicate with your Oracle database.

5. Setting Up Environment Variables

• 1. Create Environment Variables
• Action: Create environment variables for Java JDK paths such as C:\Program Files\Java\jdk-22 and C:\Program Files\Java\.
• 2. Set Environment Variables Before Installing APEX
• User Environment Variables:
• JAVA_HOME=C:\Program Files\Java\jdk-22
• ORDS_CONFIG=C:\ords\config
• JAVA_HOME: Sets the path to the Java JDK.
• ORDS_CONFIG: Sets the path to the ORDS configuration.
• System Environment Variables:
• JDK path → C:\Program Files\Java\jdk-22 JDK
• path → C:\Program Files\Java JDK
• path → C:\Program Files\Java\jdk-22\bin
• JAVA_TOOL_OPTIONS=-Dconfig.url=C:\ords\config
• JDK path: Sets various paths for the Java JDK.
• JAVA_TOOL_OPTIONS: Sets additional Java options, here the configuration URL for ORDS.

6.1 Installation Guide - Oracle APEX 24.1

Overview

This guide details the necessary steps to install Oracle Application Express (APEX) 24.1 on a Windows system, explaining the rationale behind each step to ensure a successful setup.

1. Unpacking and Relocating Installation Files

• Action: Unzip the Oracle APEX files and move them directly to the C: drive, renaming the folder for easier access, e.g., C:\apex.
• Why?: Placing the installation files on the C: drive in a specifically named folder (apex) simplifies navigation and future maintenance. It standardizes the installation path, which can help avoid path-related errors during the setup process.

2. Preparing the Database

• Action: Navigate to the directory containing apexins.sql, open a command prompt at this location, and prepare to run the SQL scripts.
• Why?: The apexins.sql script initializes the Oracle APEX environment within your Oracle Database. It sets up the necessary schemas and configurations.

3. Running SQL Scripts

• Commands to Execute:

 

SQL

xxxxxxxxxx

30

 

1

-- Connect to the database as sysdba

2

sqlplus sys as sysdba

3

-- Enter password when prompted

4

​

5

-- Show Pluggable Databases (PDBs)

6

Show pdbs;

7

​

8

-- Set the session to the target container

9

alter session set container = orclpdb;

10

​

11

-- Show PDBs again to confirm

12

Show pdbs;

13

​

14

-- Check Oracle Database version

15

SELECT * FROM v$version;

16

​

17

-- Check instance status

18

SELECT status FROM v$instance;

19

​

20

-- Check tablespace status

21

SELECT tablespace_name, status FROM dba_tablespaces;

22

​

23

-- Check free space in SYSAUX tablespace

24

SELECT tablespace_name, SUM(bytes)/1024/1024 AS Free_Space_MB FROM dba_free_space WHERE tablespace_name = 'SYSAUX' GROUP BY tablespace_name;

25

​

26

-- Check TEMP tablespace details

27

SELECT tablespace_name, file_name, bytes/1024/1024 AS MB FROM dba_temp_files WHERE tablespace_name = 'TEMP';

28

​

29

-- Run the APEX installation script

30

@apexins.sql SYSAUX SYSAUX TEMP /i/

6.2. Setting the Internal Password for Oracle APEX

• File to Run: apxchpwd.sql

 

SQL

xxxxxxxxxx

 

1

-- Run the script to set the internal password

2

@apxchpwd.sql

6.3. Checking APEX Users

• Command to Execute:

 

SQL

xxxxxxxxxx

 

1

-- Check APEX users

2

SELECT username, account_status FROM dba_users WHERE username LIKE 'APEX%';

6.4 Configuring REST

• File to Run: apex_rest_config.sql

 

SQL

xxxxxxxxxx

 

1

-- Run the script to configure REST

2

@apex_rest_config.sql

6.5 Unlocking Users

• Commands to Execute:

 

SQL

xxxxxxxxxx

16

 

1

-- Connect to SQL*Plus

2

sqlplus sys as sysdba

3

​

4

-- Unlock users without changing any container

5

ALTER USER ORDSYS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

6

ALTER USER ANONYMOUS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

7

ALTER USER ANONYMOUS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK CONTAINER=ALL;

8

​

9

-- Set the session to the target container

10

alter session set container = orclpdb;

11

​

12

-- Unlock APEX-related users

13

ALTER USER APEX_LISTENER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

14

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

15

ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

16

ALTER USER APEX_240100 IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

6.6 Configuring ORDS

• Commands to Execute:

 

SQL

xxxxxxxxxx

17

 

1

-- Open SQL*Plus and connect as sysdba

2

sqlplus sys as sysdba

3

​

4

-- Check the PDBs

5

SELECT name, open_mode FROM v$pdbs;

6

​

7

-- Ensure the target PDB is open

8

ALTER PLUGGABLE DATABASE orclpdb OPEN;

9

​

10

-- Register the database

11

ALTER SYSTEM REGISTER;

12

​

13

-- Exit SQL*Plus

14

exit

15

​

16

-- Check the listener status

17

lsnrctl status

7. Installation of ORDS 24.1

Installing ORDS

• Action: Navigate to the directory where you unzipped ORDS, e.g., C:\ords, and open a command prompt here.
• Command to Run:

 

Bash

xxxxxxxxxx

 

1

java -jar ords.war install

• Installation Prompts:
• Enter localhost for the hostname.
• Enter 1521 for the port.
• Use the service name entered during the Oracle DB installation (e.g., orclpdb).
• Username: sys
• Password: Enter the sys password.
• When asked if all is correct, press A to agree and proceed.

Finalizing the ORDS Installation

• Action: Confirm that the ORDS images are located in C:\ords\images.

8. Starting and Stopping ORDS with Batch Files

Starting ORDS

Create a batch file start_ords.bat with the following content:

 

Bash

xxxxxxxxxx

 

1

@echo off

2

REM Change directory to ORDS

3

cd /d C:\ords

4

REM Start ORDS

5

echo Starting ORDS...

6

start "" java -jar ords.war serve

7

echo ORDS started.

Stopping ORDS

Create a batch file stop_ords.bat with the following content:

 

Bash

xxxxxxxxxx

 

1

@echo off

2

REM Stop ORDS

3

echo Stopping ORDS...

4

taskkill /F /IM java.exe

5

echo ORDS stopped.

9. Testing the Installation

Accessing Oracle APEX

• Action: Open a web browser and navigate to http://localhost:8080.

Logging into Oracle APEX

• Steps:
• Log in using the workspace INTERNAL.
• Username: admin
• Password: Enter the admin password you set during the installation.

Creating a Test Workspace

• Action: Create a test workspace.

Using the Test Workspace

• Action: Log out from the admin account and log back into the newly created test workspace.
• Steps:
• Create a test application within this workspace.

10. Running APEX on Apache Tomcat

1. Install Apache Tomcat

• Install the Tomcat software and, if possible, change the port to 80.

2. Open the Webapps Directory

• Open the webapps directory of Tomcat.

3. Move Images and ORDS

• Move the images folder from Oracle APEX into the webapps directory and rename it to i.
• Copy the ords.war file into the webapps directory and rename it if needed, e.g., to apexnote.

4. Start Apache Tomcat

• Start Apache Tomcat and open localhost/apexnote in your browser.

I hope this structured guide helps you with the installation of Oracle APEX, Oracle DB, ORDS and Apache Tomcat. If you have any questions, please write them in the comments.

Thank you for reading!

 {fullWidth}