How to Install Oracle APEX 19.2 | DB 21c | Pluggable | Windows 10

Today we are going to Install Oracle APEX 19.2 & ORDS 21.1 with DB 21c [Pluggable] in Windows 10 InshaAllah.

Patreon:   / omarbaig  

a. We can download it from
https://www.oracle.com/database/techn...
b. Unzip Oracle DB 21c, & ORDS 21.1 where you want to Install them.
While extracting DB 21c [Pluggable] & ords 21.1 we will create separate folder with name "DB" & "ords" respectively, so all the respected files will extract in respected folders.
c. Unzip "apex_19.2" to the folder where you want to install it.
Java version is Java 8 update 211 (java -version)
d. Run db setup with "Administrator" rights.
e. Create & configure a single instance database.
f. Desktop Class.
g. Use Windows Built-in Account (you can use other option as well)
h. Assign "Global Database Name(orcl21), Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (orclpdb)
i. Hit "Install" button.
j. Open SQL Plus & connect as sys / as sysdba
k. 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 = 5000M SCOPE=SPFILE;
l. Check Pluggable database status by running this command
SELECT name, open_mode
FROM v$pdbs;
if it is OPEN (READ WRITE) then run this command
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE; (ORCLPDB is my pluggable database) (when we shut down & start database, its states will remain READ WRITE) & if it is close then run this command
ALTER PLUGGABLE DATABSE ORCLPDB OPEN;
m. Shut down database by running this command
shut immediate;
n. Start it by running this command
startup
o. Check sga_max_size again by running this command
show parameter sga;
p. Open cmd.
q. Reach where apex folder is available.
r. Run sqlplus /nolog
s. Connect with sys / as sysdba
t. 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 = ORCLPDB;
(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/
v. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
w. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
x. Run @apex_epg_config.sql & add path where apex folder is available.
y. Run @apxldimg.sql & add path where apex folder is available.
z. Open SQL Plus connect sys as sysdba & run this command
ALTER SESSION SET CONTAINER = ORCLPDB; then run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
za. Open cmd again with "Administrator" rights & reach where ords is available.
zb. Run this command java -jar ords.war install advanced.
zc. Provide Configuration path & hit "Enter" button. "C:\21c_19.2\ords"
zd. Enter number for... [1]: Hit "Enter" button.
ze. Database server is [localhost]: Hit "Enter" button
zf. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zg. Specify Database SID [1]: provide option "1" & hit "Enter" button, my database service name is "orclpdb"
zh. Enter 1 if you want to verify... [1]: Hit "Enter" button.
zi. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zj. Enter administrator username, pass.., & Confirm pass...
zk. Enter the default... [SYSAUX]: Hit "Enter" button.
zl. Enter the temporary... [TEMP]: Hit "Enter" button.
zm. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zn. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zo. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zp. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zq. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zr. Enter 1 to specify pass.. for Application Express... [1]: Hit "Enter" button, specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER" from your choice.
zs. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zt. Go to apex folder copy "images" folder from "C:\21c_19.2\apex" & paste it to "C:\21c_19.2\ords"
zu. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zv. Enter the APEX static resources...: Provide "image" path "C:\21c_19.2\ords\images"
zw. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zx. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zy. Open cmd with administrator rights, reach where ORDS folder is available (C:\21c_19.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.

#OmarBaig #OracleAPEX192Installation #OracleDatabase21cInstallation