How to install Oracle Apex 24.1 and Ords 24.1 with Database 19c on Windows ~ APEX Note

Welcome to the installation guide for setting up Oracle Database 19c with Oracle APEX 24.1 and ORDS 24.1 on Windows. Below you will find the essential download links and documentation to get started with the installation. For a detailed, step-by-step tutorial, please refer to the accompanying video.

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

2. Installation Guides - Java Files

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

1. Install the First Java File

Begin by installing the first Java file. This is crucial for setting up the environment Oracle requires.
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, proceed with the second Java file.
Execute the downloaded installer and follow the prompts to ensure Java is properly set up on your system.

These installations prepare your system to handle the database and application express software smoothly.

3. Installation Guides - Oracle DB 19c

To install Oracle Database 19c on your Windows machine, follow these steps carefully:

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.
Rename the folder for easier access, for example to: C:\db_home

3. Start the Installation

Navigate to the C:\db_home directory.
Scroll to find the setup.exe file and double-click it 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, like C:\db_base\oradata
Global Database Name: Set the global database name, e.g., `orcl`.
Database Name (PDB): Define the pluggable database name, such as `orclpdb`.
Administrator Password: Create a strong, secure password for the database administrator, e.g., `Password1!`.

5. Installation Verification

Before proceeding with the installation, review all settings to ensure they are correct.
Check all the configurations and click 'Install' to begin the installation process.

6. Post-Installation Steps

After installation, ensure that the database services are running by checking the Services app in Windows.
Optionally, configure additional network settings or backup configurations as required.

By following these detailed steps, you will have a functional Oracle Database 19c setup on your Windows system, ready for further configuration and use.

4. Installation Guides - SQL Developer

Installing and setting up SQL Developer on your Windows system allows you to manage your Oracle databases efficiently. 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 for easy access.
Rename the folder simply to C:\sql-developer to keep it organized.
Consider making a shortcut on your desktop for quick access.

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.
To create a new connection for testing purposes:
Click on the "New Connection" button.
Connection Name: Enter a descriptive name, such as `db_sys_admin`.
Username: Use sys as the username for administrative privileges.
Password: Enter the password for your sys account, e.g., Password1! (Ensure this is the password you set during the Oracle installation).
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, such as `orclpdb`.

4. Save and Test the Connection

After entering all details, click "Save" to store the connection settings.
Click "Test" to ensure that SQL Developer can connect to your Oracle database using the provided credentials.
If the status shows "Success," your setup is correct, and you can now use this connection to execute SQL commands.

5. Why Test the Connection?

Testing the connection before proceeding with any database operations is crucial to ensure that all settings are correct and that SQL Developer can communicate with your Oracle database.
This step is essential as it verifies that your installation was successful and that you are ready to perform further SQL operations, which will be necessary for running SQL commands and managing your database.

By setting up SQL Developer and testing your connection, you are ensuring that you have the necessary tools ready for efficient database administration and development tasks.

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

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.

Setting Up Environment Variables

Action: Create environment variables for Java JDK paths such as C:\Program Files\Java\jdk-22 and C:\Program Files\Java\
Why?: Java JDK is critical for running Oracle APEX. Setting these environment variables ensures that all Java-dependent components of Oracle APEX can locate and use the correct Java executables, which is crucial for the functionality of many processes within APEX.

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.

Running SQL Scripts

Commands to Execute:

SQL

sqlplus sys as sysdba
-- Enter password when prompted
Show pdbs;
alter session set container = orclpdb;
Show pdbs;
SELECT * FROM v$version;
SELECT status FROM v$instance;
SELECT tablespace_name, status FROM dba_tablespaces;
SELECT tablespace_name, SUM(bytes)/1024/1024 AS Free_Space_MB FROM dba_free_space WHERE tablespace_name = 'SYSAUX' GROUP BY tablespace_name;
SELECT tablespace_name, file_name, bytes/1024/1024 AS MB FROM dba_temp_files WHERE tablespace_name = 'TEMP';
@apexins.sql SYSAUX SYSAUX TEMP /i/

6. Installation Guide - ORDS 24.1

Continuing from the Oracle APEX installation, the next step involves setting up Oracle REST Data Services (ORDS) to enable web-based functionalities for your Oracle database. Here’s how to properly install and configure ORDS 24.1 on your Windows system.

Unpacking and Preparing ORDS

Action: Unzip the ORDS installation files to a designated folder.
Why?: Unzipping the files prepares them for installation, ensuring all necessary files are accessible.

Update Environment Variables

Action: Add the Java JDK bin directory to your path in the environment variables, e.g., C:\Program Files\Java\jdk-22\bin.
Why?: Updating the environment variables with the Java path ensures that the Java executables are accessible from anywhere in the command line, which is crucial for running the ORDS installation.

Prepare the Database for ORDS

Pre-Installation Database Commands:

SQL

-- Open SQL Plus and connect as sysdba:
sqlplus sys as sysdba
-- Check the PDBs:
SELECT name, open_mode FROM v$pdbs;
-- Ensure the target PDB is open:
ALTER PLUGGABLE DATABASE orclpdb OPEN;
-- Register the database:
ALTER SYSTEM REGISTER;
-- Exit SQL Plus:
exit
-- Check the listener:
lsnrctl status

Why?: These commands ensure that the Oracle database pluggable database (PDB) is open and ready for connections, and that the system is registered with the listener, essential for ORDS functionality.

Installing ORDS

Action: Navigate to the directory where you unzipped ORDS, e.g., C:\ords, and open a command prompt here.
Command to Run:cmd
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.
Why?: Running java -jar ords.war install starts the interactive ORDS installation script, which guides you through setting up ORDS to connect to your Oracle database. This setup enables RESTful web services for the applications running on Oracle APEX.

Finalizing the ORDS Installation

Action: Confirm that the ORDS images are located in C:\ords\images.
Why?: Verifying the location of ORDS images ensures that the static files used by APEX are properly linked and accessible, facilitating the correct display and functionality of web applications.

This section of the installation guide provides detailed instructions on setting up ORDS to work seamlessly with Oracle APEX and your Oracle database, enhancing the capabilities of your Oracle environment.

7. Testing the Installation

After completing the installation of Oracle APEX and ORDS, you should now have a fully configured environment. Here's how you can verify that everything is set up correctly:

Accessing Oracle APEX

Action: Open a web browser and navigate to `http://localhost:8080`.
Why?: This URL points to the Oracle APEX application interface running on your local server.

Logging into Oracle APEX

Steps:
Log in using the workspace INTERNAL.
Username: admin
Password: Enter the admin password you set during the installation.
Why? Logging into the INTERNAL workspace allows you to manage Oracle APEX settings and user accounts.

Creating a Test Workspace

Action: Once logged in, proceed to create a test workspace.
Why?: Creating a test workspace enables you to experiment with APEX without affecting the production environment.

Logging Out and Testing with a New Application

Action: Log out from the admin account and log back into the newly created test workspace.
Steps:
Create a test application within this workspace.
Result: If you can successfully create and run a test application, it confirms that Oracle APEX has been installed and configured properly on your system.

Conclusion

By now, you should see that an application has been successfully created, indicating that Oracle APEX is fully operational. This confirms that the installation and configuration process was successful, and you are now ready to explore the full potential of Oracle APEX.

Congratulations on setting up Oracle APEX and ORDS! You are now equipped to start developing powerful applications seamlessly.

{fullWidth}

APEX Note