Today we are going to Install Oracle APEX 19.1 and ORDS 20.3 with Database [XE] 18c [Pluggable] in Windows 10 InshaAllah. [Quickly]

patreon.com/OmarBaig

a. Unzip it where you want to Install Oracle Database [XE] 18c
b. Unzip "apex_19.1" to the folder where you want to install it, so you do not need to copy & paste it (apex folder)
c. Unzip ords 20.3 as well.
d. Run database setup with "Administrator" rights.
e. Hit "Next" button.
f. Check on "I accept the terms..." & hit "Next" button.
g. Change Directory while hitting "Change" button & hit "Next" button.
h. Enter Database Password & Confirm Password from your choice, hit "Next" button.
i. Hit "Install" button.
j. Hit "Finish" button.
Pluggable Database name is "XEPDB1"
k. Open command prompt & reach where apex folder is available.
l. Run sqlplus /nolog
m. Connect as sys as sysdba
n. We will find pluggable databse is in "READ WRITE" while running this command
SELECT name, open_mode
FROM v$pdbs;
o. To open it we run this command
ALTER PLUGGABLE DATABASE XEPDB1 OPEN;
p. Find pluggable database name & check whether we connect with "Pluggable Database" or not while running this command
show pdbs;
q. Run this command before every apex scripts (@apexins, @apxchpwd.sql, @apex_rest_config.sql, @apex_epg_config.sql, @apxldimg.sql)
& make sure "Session altered" appear if not then connect again as sys / as sysdba
ALTER SESSION SET CONTAINER = XEPDB1;
r. Install apex by running this command
@apexins sysaux sysaux temp /i/
s. Run @apxchpwd.sql, username is "ADMIN", email, & password from your choice.
t. Run @apex_rest_config.sql (provide password for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
u. Run @apex_epg_config.sql & add path where apex folder is available.
v. Run @apxldimg.sql & add path where apex folder is available.
w. Open SQL Plus connect with sys / as sysdba & run these commands.
ALTER SESSION SET CONTAINER = XEPDB1;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
x. Open Command prompt again with "Administrator" rights & reach where ords is available.
y. Run this command java -jar ords.war install advanced.
z. Provide Configuration path & hit "Enter" button. "D:\18cXE_19.1_EV\ords"
za. Enter number for... [1]: Hit "Enter" button.
zb. Database server is [localhost]: Hit "Enter" button
zc. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zd. Specify Database SID [1]: provide option "1" and hit "Enter" button, my database service name is "XEPDB1"
ze Enter 1 if you want to verify... [1]: Hit "Enter" button.
zf. Enter password & Confirm password for ORDS_PUBLIC_USER
zg. Enter administrator username, password, & Confirm password.
zh. Enter the default... [SYSAUX]: Hit "Enter" button.
zi. Enter the temporary... [TEMP]: Hit "Enter" button.
zj. Enter the default... ORDS_PUBLIC_USER [USERS]: Hit "Enter" button.
zk. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zl. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zm. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zn. Specify password, & Confirm password for APEX_PUBLIC_USER from your choice.
zo. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button & specify password,
& Confirm Password for both "APEX_LISTENER" and "APEX_REST_PUBLIC_USER" from your choice.
zp. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zq. Go to apex folder copy "images" folder from "D:\18cXE_19.1_EV\apex" & paste it to "D:\18cXE_19.1_EV\ords"
zr. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zs. Enter the APEX static resources...: Provide "image" path "D:\18cXE_19.1_EV\ords\images"
zt. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zu. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zv. Open cmd with administrator rights, reach where ORDS folder is available (D:\18cXE_19.1_EV\ords) & run this command "java -jar ords.war",
when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt not close it.

Search Tags:
Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Email through Oracle Apex 20.1 4K, Email through Oracle Apex 19.2 4K, Email through Oracle Apex 19.1 4K, Email through Oracle Apex 18.2 4K, Email through Oracle Apex 18.1, HOW TO SEND EMAIL USING ORACLE APEX, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, How to Install Android Studio on Windows 10, Oracle APEX 20.2, Oracle APEX 20.2 Installation, install jdeveloper 12.2.1.4

Chapters
00:00 Unzipping Folders
05:00 Database Installation
07:02 Oracle APEX Installation
11:03 Oracle APEX Configuration
15:04 ORDS 20.3 Installation