How to Install Oracle APEX 20.2 | DB 19c | Windows 10

Today we are going to Install Oracle APEX 20.2 & ORDS 21.4 with Database 19c in Windows 10 InshaAllah.
Patreon: / omarbaig
a. Create folder with name "19c_20.2" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 19c in (C:\19c_20.2\DB)
c. Download ORDS 21.4 from this link
www.oracle.com...
d. Unzip ords 21.4 in a folder "ords" (C:\19c_20.2\ords), so you do not need to copy & paste it (ords)
e. Unzip "apex_20.2" to the folder where you want to install it ((C:\19c_20.2\ords)), so you do not need to copy & paste it (apex)
Java version is Java 8 update 211 (java -version)
f. Run database setup with "Administrator" rights.
g. Create and configure a single instance database.
h. Desktop Class.
i. Use Windows Built-in Account (you can use other option as well)
j. Assign "Global Database Name (orcl19), Pass.. & Confirm Pass.. from your choice, uncheck "Create as Container Database" option.
k. Hit "Install" button.
l. Open SQL Plus & connect as sys / as sysdba
m. Check sga_max_size by running this command
show parameter sga;
if less than 3000m then increase it by running this command
ALTER SYSTEM SET MEMORY_TARGET = 4000M SCOPE=SPFILE;
n. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
o. Start it by running this command
startup
p. Check sga_max_size again by running this command
show parameter sga;
q. Open cmd & reach where apex folder is available.
r. Run sqlplus /nolog
s. Connect as sys as sysdba
t. Install apex by running this command
@apexins sysaux sysaux temp /i/
u. Run @apxchpwd.sql, username is "ADMIN", email, & pass.. from your choice.
v. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
w. Run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
x. Open cmd 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. "C:\19c_20.2\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 "2" & hit "Enter" button, my database SID is "orcl19"
ze Enter 1 if you want to verify... [1]: Hit "Enter" button.
zf. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zg. Enter administrator username, pass.., & Confirm pass...
zh. Enter the default... [SYSAUX]: Hit "Enter" button.
zi. Enter the temporary... [TEMP]: Hit "Enter" button.
zj. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: 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 pass.., & Confirm pass.. for APEX_PUBLIC_USER.
zo. Enter 1 to specify pass.. for Application Express... [1]: Hit "Enter" button & specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER".
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 "C:\19c_20.2\apex" & paste it to "C:\19c_20.2\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 "C:\19c_20.2\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 (C:\19c_20.2\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize cmd do not close it.
Search Tags:
Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, Oracle APEX Installation, Oracle APEX 20.2, Oracle APEX 20.2 Installation, Oracle APEX 21.1, Oracle APEX 21.1 Installation, How to Install Oracle APEX 21.1, How to install Oracle Database 19c, How to install Oracle Database 21c, Oracle Database 21c Installation, Oracle AEPX 21.2 Installation, How to Install Oracle AEPX 21.2, Oracle AEPX 21.2, APEX 21.2
#OmarBaig #OracleAPEX202Installation #OracleDatabase18cInstallation

[@Naveenkumar-vc1ef]

Hello omair, can you help me, I'm a oracle dba fresher, in my company they assigned a task apex installation and upgrade

[@omarbaigob]

Do it. My videos are available.

[@Naveenkumar-vc1ef]

@@omarbaigob yes man! Thanks for making those videos 💗