How to Install Oracle Apex 22.2 | Database 21c XE Pluggable | ORDS 22 | Tomcat | Windows

In this step-by-step tutorial, you will learn how to install the latest Oracle APEX version 22.2 on your own local Windows PC. This local Oracle APEX development environment setup will be created using Oracle Database 21c XE, the latest Oracle Rest Data Services (ORDS 22x), Java (JDK 17x), and Apache Tomcat.

Chapters
---------------
0:00 - Intro
0:28 - Download links
1:55 - Install Oracle Database 21c XE
4:04 - Install Oracle APEX 22.2
7:39 - Install JDK
8:21 - Install Oracle Rest Data Services
11:40 - Install Apache Tomcat
14:28 - Run Oracle APEX and create your first workspace
15:34 - Log in to the new workspace

Download Oracle XE 21c

Download Oracle APEX

Download ORDS

Download JAVA

Download Tomcat

Install Oracle APEX
-------------------------------
sqlplus /nolog
conn sys as sysdba
show pdbs;
alter session set container = XEPDB1; // Always execute this command when you open a new sqlplus session
column default_tablespace format A15
column temporary_tablespace format A15
alter user APEX_PUBLIC_USER account unlock;
alter user APEX_PUBLIC_USER identified by Manager_2023; // Used this password in this video for all accounts

Install ORDS
--------------------
sqlplus
sys as sysdba
alter user sys identified by Manager_2023 account unlock container=all;
alter session set container = xepdb1;
alter user apex_listener identified by Manager_2023 account unlock;
alter user apex_public_user identified by Manager_2023 account unlock;
alter user apex_rest_public_user identified by Manager_2023 account unlock;

----------------------------------------------------------------------------
----------------------------------------------------------------------------
set ORDS_HOME=c:\app\ords
set ORDS_CONFIG=c:\app\config\ords
set ORDS_LOGS=%ORDS_CONFIG%\logs
set DB_HOSTNAME=localhost
set DB_PORT=1521
set DB_SERVICE=XEPDB1
set SYSDBA_USER=SYS

--config %ORDS_CONFIG% install ^
--log-folder %ORDS_LOGS% ^
--admin-user %SYSDBA_USER% ^
--db-hostname %DB_HOSTNAME% ^
--db-port %DB_PORT% ^
--db-servicename %DB_SERVICE% ^
--feature-db-api true ^
--feature-rest-enabled-sql true ^
--feature-sdw true ^
--gateway-mode proxied ^
--gateway-user APEX_PUBLIC_USER ^
--proxy-user
------------------------------------------------------------------------------

setx PATH "%PATH%;c:\app\ords\bin"
set PATH="%PATH%;c:\app\ords\bin"

Install Apache Tomcat
--------------------------------------
set CATALINA_HOME="c:\Program Files\Apache Software Foundation\Tomcat 9.0"
mkdir %CATALINA_HOME%\webapps\i

Run Oracle APEX
-----------------------------

[helpingustayfit]

all steps are perfect, only condition applied is follow the version that you have shown in video, otherwise 404 not found error will display. Thank you for your efforts and explanation. in depth explanation.

[furiz-]

Thanks for this video, it helped me a lot! :D

[renot]

thank you very much! i finally installed apex!

[jsjndiy]

thank you so much is useful. Looking forward to see more video much especially on Oracle Database 21c, Apex, ords, jdk, tomcat and httpd on Linux 7 or 8.

[ahmedelgareep]

Thank you very much it’s very important video I love your channels It’s help me to understand the oracle apex Thank you thank you thank you very very very much❤❤❤❤

[mdgldcs]

thank you, but when i run it give me this error The requested resource [/ords/apex_admin] is not available

Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.how can i fix it.?

[nicknack]

May u upload a video showing a master detail form for data entry and on save page for re-entry ready...Dont lead to report..Also trigger in forms like post-query, when-new-form-instance and post-change may be explained....thanks

[yasserbadawy]

thank you very much it so useful and i do every thing but when execute url this message appear
404 Not Found
The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured

[leandromattioli]

Hello guys!
I'm using APEX 22.2.0 default version.. and occurs some calendar problem when shows days into week..
Reading about it.. seems to be solved with last version patch..
Someone has APEX 22.2 Patch 12 for download?
And how to install that?

[ivanpavlovic]

what about typing password through cmd during connecting with the database, i can't see any letter, and for that reason i can't establish connection

[safiullah]

great video. How can we enable SSL (https://) to access our APEX?

[mnypes]

Thanks but I still need resolution to this error: "The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured". Tried restarting Tomcat but I keep getting same error. Any assist?

[alieid]

Thank you so much it was helpful but when i try to run it i found error 404 so i cannot connect to apex can you help me please the message is " The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured"

[asifiqbal]

Thanks a lot for this video. I have followed but got an error on running. The error message is " The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured " . How can I fix this error? Please avise.

[bhasi]

Thank you so much it was helpful but when i try to run it i found error 404 so i cannot connect to apex can you help me please the message is " The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured", I followed your suggestion of "alter pluggable database all open; " still the problem remains, can you help?

Can we have video for push notifications on mobile?

[martinsantiago]

when I entered the command @apxchpwd.sql at 6:44
its says "user does not exist"
help me

[zsiptxw]

Tried using Tomcat v10.1 - did not work. Removed 10.1 installed Tomcat 9.0.83 - it worked!!
Thank you so much!
Used XE 21, Apex 23.2, Tomcat 9, Java JDK 21, ORDS 23
The error I got was..
HTTP Status 500 – Internal Server Error
Error Stack from catalina logs
Class is not a Servlet ...

[tanshanahmeed]

Enter the database password for SYS AS SYSDBA:
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Oracle REST Data Services - Non-Interactive Install
2023-04-16T06:39:13.017Z SEVERE Failed to connect to user: SYS AS SYSDBA url:
ORA-01017: invalid username/password; logon denied

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

i'm facing this kind of error which password i will give sys as sysdba?