How to Install Oracle APEX 22.2 | DB 23ai Pluggable | Windows 10 | Omar Baig | Part 2

Today we are going to Install Oracle APEX 22.2 and ORDS 25.1 with Database 23ai Express Edition [Pluggable] in Windows 10 InshaAllah.

Patreon: https://www.patreon.com/OmarBaig

a. Create folder with name "23ai_22.2" under this folder we create 3 folder with the name "DB" & "ords", and "ordsconf".
b. Under "ordsconf" create folder with the name "config"
c. Download Oracle Database 23ai from this link
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
d. Unzip Oracle Database 23ai in (D:\Oracle\Database)
e. Download ORDS from this link
https://www.oracle.com/database/sqldeveloper/technologies/db-actions/download/
f. Unzip ORDS
We extract ORDS in a folder "ords" (C:\23ai_22.2\ords), so we do not need to copy & paste it (ords)
g. Download Oracle APEX 22.2 from this link
https://www.oracle.com/tools/downloads/apex-222-downloads.html
h. Unzip "apex_22.2" in a folder (C:\23ai_22.2), so we do not need to copy & paste it (apex folder)
Java version is Java 24 (java -version) (For ORDS 22.1, 22.2 & 23.1, 24.4, 25.1 install Java 11 at least.)
Remember
Before attempting to install Oracle Database XE 23ai, uninstall any existing Oracle Database XE or database with the SID FREEPDB1 from the target system.
The installer will use SID "FREE" for database creation. Any SID other than SID "FREE" will not be allowed.
i. Run database setup with "Administrator" rights.
j. Hit "Next" button.
k. Check on "I accept the terms..." & hit "Next" button.
l. Change Directory while hitting "Change" button & hit "Next" button. (C:\23ai_22.2\DB\)
m. Enter Database Password & Confirm Password for "SYS", "SYSTEM", & "PDBADMIN" from your choice, hit "Next" button.
n. Hit "Install" button.
o. Hit "Finish" button.
Pluggable Database name is "FREEPDB1" & port is 1521
p. Open command prompt & reach where apex folder is available. (C:\23ai_22.2)
q. Run sqlplus /nolog
r. Connect as sys as sysdba
s. We will find pluggable database is in "READ WRITE" while running this command
SELECT name, open_mode
FROM v$pdbs;
t. If not in "READ WRITE" mode then we run this command
ALTER PLUGGABLE DATABASE FREEPDB1 OPEN;
u. Run this command
show pdbs; (this command will run before every apex scripts @apexins, @apxchpwd.sql, @apex_rest_config.sql to make sure that we connect with pluggable database or not, if we connect it then run apex scripts, if not then run below command)
ALTER SESSION SET CONTAINER = FREEPDB1;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
v. Install apex by running this command
@apexins sysaux sysaux temp /i/
w. Run @apxchpwd.sql, username is "ADMIN", email, & password from your choice.
x. Run this command & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Run @apex_rest_config.sql (provide password for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
z. Open Command prompt again with "Administrator" rights & reach where "bin" folder is available under ORDS. (C:\23ai_22.2\ords)
za. Run this command ords.exe --config C:\23ai_22.2\ordsconf\config install
zb. Basic (...) [1]: Hit "Enter" button.
zc. Enter the Database ... [localhost]: Hit "Enter" button
zd. Enter the database listen ... [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Enter the database service ... [...]: provide FREEPDB1, because my database service name is "FREEPDB1"
zf. Enter administrator username, password.
zg. Choose [A]: Enter "3"
zh. Choose [G]: Enter "s"
zi. Enter database password and Confirm Password for ORDS_PUBLIC_USER from your choice.
zj. Choose [A]: Enter "9"
zk. Copy images folder from "C:\23ai_22.2\apex" and paste it to "C:\23ai_22.2\ords"
zl. Enter the APEX static resources...: Provide "image" path "C:/23ai_22.2/ords/images"
zm. If you want other changes do it pressing desire number.
zn. Choose [A]: Enter "A"
zo. Once "Oracle REST Data Services initialized" appear use Oracle APEX through this link (localhost:8080/ords/apex)
zp. Open cmd with administrator rights, reach where "bin" folder is available under ORDS (C:\23ai_22.2\ords) & run this command "ords.exe --config C:\23ai_22.2\ordsconf\config serve", when "Oracle REST Data Services initialized" appear use Oracle APEX,
minimize command prompt do not close it.

Search Tags:
Omar Baig, How to Install Oracle APEX 22.2, Oracle APEX 22.2 Installation, How to Uninstall Oracle APEX 24.1, Uninstall Oracle APEX 24.1, How to Install Oracle APEX 24.1, Oracle APEX 24.1 Installation, How to Uninstall Oracle APEX 23.2, Uninstall Oracle APEX 23.2, How to Install Oracle APEX 23.2, Oracle APEX 23.2 Installation, How to Install Oracle APEX 23.1, Oracle APEX 23.1 Installation, Uninstall Oracle APEX 24.2, How to Uninstall Oracle APEX 24.2, Oracle APEX 24.2 Installation, How to Install Oracle APEX 24.2

Chapters
00:08 Oracle APEX 22.2 Configuration
01:57 ORDS 25.1 Installation
14:42 Copy Images Folder
08:19 How to Start ORDS 25.1

#OmarBaig #oracleapex

Видео How to Install Oracle APEX 22.2 | DB 23ai Pluggable | Windows 10 | Omar Baig | Part 2 канала Omar Baig عمر بیگ