How to Install Oracle APEX 22.1 | DB 21cXE | Executive | Windows 10

Today we are going to Install Oracle APEX 22.1 and ORDS 21.4 with Database [XE] 21c [Pluggable] in Windows 10 InshaAllah. [Quickly]

a. Create folder with name "21cXE_22.1" under this folder we create 2 folder with name "DB" & "ords".
b. Download Oracle Database [XE] 21c from
c. Unzip Oracle Database [XE] 21c in (C:\21cXE_22.1\DB)
d. Download ORDS 21.4
e. Unzip ords 21.4.
We extract ords 21.4 in a folder "ords" (C:\21cXE_22.1\ords), so you do not need to copy & paste it (ords)
f. Download Oracle APEX 22.1 from this link
g. Unzip "V1020798-01" in a folder (C:\21cXE_22.1), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
Remember
Before attempting to install Oracle Database XE 21c, uninstall any existing Oracle Database XE or database with the SID XE from the target system.
The installer will use SID XE for database creation. Any SID other than SID XE will not be allowed.
h. Run database setup with "Administrator" rights.
i. Hit "Next" button.
j. Check on "I accept the terms..." & hit "Next" button.
k. Change Directory while hitting "Change" button & hit "Next" button. (C:\21cXE_22.1\DB\)
l. Enter Database Pass.. & Confirm Pass.. for "SYS", "SYSTEM", & "PDBADMIN" from your choice, hit "Next" button.
m. Hit "Install" button.
n. Hit "Finish" button.
o. Open cmd & reach where apex folder is available.
p. Run sqlplus /nolog
q. Connect as sys as sysdba
r. We will find pluggable database is in "READ WRITE" while running this command
SELECT name, open_mode
FROM v$pdbs;
s. If not in "READ WRITE" mode then we run this command
ALTER PLUGGABLE DATABASE XEPDB1 OPEN;
t. Run this command
ALTER SESSION SET CONTAINER = XEPDB1;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
u. Install apex by running this command
@apexins sysaux sysaux temp /i/
w. Run this command & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Open cmd again with "Administrator" rights & reach where ords folder is available.
za. Provide Configuration path & hit "Enter". "C:\21cXE_22.1\ords"
zb. Enter number for... [1]: Hit "Enter".
zc. Database server is [localhost]: Hit "Enter".
zd. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Specify Database SID [1]: provide option "1" and hit "Enter" button, my database service name is "XEPDB1"
zf Enter 1 if you want to verify... [1]: Hit "Enter".
zg. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zh. Enter administrator username, pass.., & Confirm pass...
zi. Enter the default... [SYSAUX]: Hit "Enter".
zj. Enter the temporary... [TEMP]: Hit "Enter".
zk. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter".
zl. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter".
zm. If using Oracle Application Express or migrating from... [1]: Hit "Enter".
zn. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter".
zo. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zp. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button & specify pass.., & Confirm Pass.. for both "APEX_LISTENER" and "APEX_REST_PUBLIC_USER" from your choice.
zq. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zr. Go to apex folder copy "images" folder from "C:\21cXE_22.1\apex" & paste it to "C:\21cXE_22.1\ords"
zs. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zt. Enter the APEX static resources...: Provide "image" path "C:\21cXE_22.1\ords\images"
zu. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zv. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.

Chapters
00:46 Creating Folders
02:04 Unzipping Folders
05:56 Database Installation
09:31 Oracle APEX Installation
12:44 Oracle APEX Configuration
15:03 ORDS 21.4 Installation

#OmarBaig #OracleAPEX221Installation #OracleDatabase21cXEInstallation

[shmnsvcs]

does the same instruction can be used on linux ?

[pjstruk]

Assalamualaikum Wr Wb,

please help me again,
I have problem after command localhost:8080/ords

problem message:
the username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

[pjstruk]

please help, i have problem with step (Run this command java -jar ords.war install advanced), the error message "... this version of java runtime only recognizes class file up to 52.0", please help the solutions