How to Install Oracle APEX 20.2 | DB 12cR2 | Windows 10

Today we are going to Install Oracle APEX 20.2 & ORDS 21.4 with Database 12c Release 2 in Windows 10 InshaAllah.

a. Create folder with name "12cR2_20.2" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 12c
c. Download ORDS 21.4 from this link
d. Unzip ords 21.4 in a folder "ords" (C:\12cR2_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, 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. I do not wish to receive Security Updates.
h. Create & configure a database.
i. Desktop Class.
j. Use Windows Built-in Account (you can use other option as well)
k. Assign "Oracle base" while hitting "Browse" button till this folder (C:\12cR1_21.2\DB), "Global Database Name (orcl12),
Pass.. & Confirm Pass.. from your choice, uncheck "Create as Container Database" option.
l. Hit "Install" button.
m. Open SQL Plus & connect as sys / as sysdba
n. 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;
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. Install apex by running this command
@apexins sysaux sysaux temp /i/
x. Run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Open cmd again with "Administrator" rights & reach where ords is available.
za. Provide Configuration path & hit "Enter" button. "C:\12cR2_20.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.
zd. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl12"
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:\12cR2_20.2\apex" & paste it to "C:\12cR2_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:\12cR2_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.

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 #OracleDatabase12cR2Installation