How to Install Oracle APEX 21.2 | DB 12c | Pluggable | Windows 10

Today we are going to Install Oracle APEX 21.2 and ORDS 21.3 with Database 12c Release 2 [Pluggable] in Windows 10 InshaAllah.

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

a. Create folder with name "12c_21.2" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 18c in (C:\12c_21.2\DB)
c. Unzip ords 21.3 in a folder "ords" (C:\12c_21.2\ords), so you do not need to copy & paste it (ords)
d. Download Oracle APEX 21.2 from this link
https://www.oracle.com/tools/downloads/apex-downloads.html
e. Unzip "apex_21.2" in a folder (C:\12c_21.2), so we do not need to copy & paste it (apex folder)
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, Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (orclpdb)
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 = 3000M SCOPE=SPFILE;
n. 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;
o. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
p. Start it by running this command
startup
q. Check sga_max_size again by running this command
show parameter sga;
r. Open cmd & reach where apex folder is available
s. Run sqlplus /nolog
t. Connect as sys as sysdba
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 = ORCLPDB;
(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", provide email, & pass.. from your choice.
x. Run these commands in cmd & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle;
y. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
z. Open cmd again with "Administrator" rights & reach where ords is available.
za. Run this command java -jar ords.war install advanced.
zb. Provide Configuration path & hit "Enter" button. "C:\12c_21.2\ords"
zc. Enter number for... [1]: Hit "Enter" button.
zd. Database server is [localhost]: Hit "Enter" button
ze. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zf. Specify Database SID [1]: provide option "1" & hit "Enter" button, my database service name is "orclpdb"
zg. Enter 1 if you want to verify... [1]: Hit "Enter" button.
zh. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zi. Now enter administrator username, pass.., & Confirm pass...
zj. Enter the default... [SYSAUX]: Hit "Enter" button.
zk. Enter the temporary... [TEMP]: Hit "Enter" button.
zl. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zm. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zn. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zo. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zp. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zq. 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.
zr. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zs. Go to apex folder copy "images" folder from "C:\12c_21.2\apex" & paste it to "C:\12c_21.2\ords"
zt. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zu. Enter the APEX static resources...: Provide "image" path "C:\12c_21.2\ords\images"
zv. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zw. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zx. Open cmd with administrator rights, reach where ORDS folder is available (C:\18c_21.2\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt do not close it.

#OmarBaig #OracleAPEX212Installation #OracleDatabase12cInstallation

Видео How to Install Oracle APEX 21.2 | DB 12c | Pluggable | Windows 10 канала Omar Baig عمر بیگ