How to Install Oracle APEX 21.2 | DB 18cXE [Pluggable] | Windows 10
Today we are going to Install Oracle APEX 21.2 and ORDS 21.4 with Database 18cXE [Pluggable] in Windows 10 InshaAllah.
Patreon: / omarbaig
a. Create folder with name "18cXE_21.2" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database [XE] 18c
c. Download ORDS 21.4 from this link
https://www.oracle.com/database/techn...
d. Unzip ords 21.4 in a folder "ords" (C:\18cXE_21.2\ords), so you do not need to copy & paste it (ords)
e. Download Oracle APEX 21.2 from this link
https://www.oracle.com/tools/download...
f. Unzip "apex_21.2" in a folder (C:\18cXE_21.2), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
g. Run database setup with "Administrator" rights.
h. Hit "Next" button.
i. Check on "I accept the terms..." & hit "Next" button.
j. Change Directory while hitting "Change" button & hit "Next" button.
k. Enter Database Pass.. & Confirm Pass.. for "SYS", "SYSTEM", & "PDBADMIN" from your choice, hit "Next" button.
l. Hit "Install" button.
m. Hit "Finish" button.
o. Open cmd prompt & reach where apex folder is available.
p. Run sqlplus /nolog
q. Connect as sys as sysdba
r. We will find pluggable database is in "READ WRITE" while running this command
SELECT name, open_mode
FROM v$pdbs;
s. If not in "READ WRITE" mode then we run this command
ALTER PLUGGABLE DATABASE XEPDB1 OPEN;
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 = XEPDB1;
(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", 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 this command & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Open cmd again with "Administrator" rights & reach where ords is available.
z. Run this command java -jar ords.war install advanced.
za. Provide Configuration path & hit "Enter" button. "C:\18cXE_21.2\ords"
zb. Enter number for... [1]: Hit "Enter" button.
zc. Database server is [localhost]: Hit "Enter" button
zd. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Specify Database SID [1]: provide option "1" and hit "Enter" button, my database service name is "XEPDB1"
zf Enter 1 if you want to verify... [1]: Hit "Enter" button.
zg. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zh. Enter administrator username, pass.., & Confirm pass...
zi. Enter the default... [SYSAUX]: Hit "Enter" button.
zj. Enter the temporary... [TEMP]: Hit "Enter" button.
zk. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zl. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zm. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zn. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zo. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zp. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button & specify pass.., & Confirm Pass.. for both "APEX_LISTENER" and "APEX_REST_PUBLIC_USER" from your choice.
zq. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zr. Go to apex folder copy "images" folder from "C:\18cXE_21.2\apex" & paste it to "C:\18cXE_21.2\ords"
zs. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zt. Enter the APEX static resources...: Provide "image" path "C:\18cXE_21.2\ords\images"
zu. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zv. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zw. Open cmd with administrator rights, reach where ORDS folder is available (C:\18cXE_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.
Search Tags:
Omar Baig, 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 #OracleAPEX212Installation #OracleDatabase18cXEInstallation