How to Install Oracle APEX 20.1 | DB 12cR1 | Windows 10

Today we are going to Install Oracle APEX 20.1 & ORDS 21.3 with Database 12c Release 1 in Windows 10 InshaAllah.

Patreon:   / omarbaig  

a. Create folder with name "12cR1_20.1" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip ords 21.3.
We extract ords 21.3 in a folder "ords" (C:\12cR1_20.1\ords), so you do not need to copy & paste it (ords)
c. Copy "apex" folder from "apex_20.1" & paste where we want to install it.
Java version is Java 8 update 211
d. Run database setup with "Administrator" rights.
e. I do not wish to receive Security Updates.
f. Create & configure a database.
g. Desktop Class.
h. Use Windows Built-in Account (you can use other option as well)
i. Click on "Browse" button & assign installation folder for "Oracle base" (C:\12cR1_21.1\DB)
j. Assign "Global Database Name, Pass.., Confirm Pass.., & uncheck "Create as Container database" option.
k. Hit "Install" button.
l. Click on "Password Management" button, Unlock "HR, & SCOTT" & provide pass.. for SYS, SYSTEM, HR, & SCOTT
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 = 5000M 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.
s. Reach apex directory in Database 12cR1 home. (C:\12cR1_21.1\DB\product\12.1.0\dbhome_1\apex)
t. Run sqlplus /nolog
u. Connect with sys / as sysdba
v. Oracle APEX 4.2 is available by default, check it while running this command
SELECT username, account_status
FROM dba_users
WHERE username LIKE 'APEX%';
w. Uninstall it while running this command
@apxremov.sql
x. Remain in cmd & reach where apex folder is available
y. Run sqlplus /nolog
z. Connect as sys as sysdba
za. Install apex by running this command
@apexins sysaux sysaux temp /i/
zb. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
zc. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
zd. Open SQL Plus connect sys as sysdba & run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
ze. Open cmd again with "Administrator" rights & reach where ords is available.
zf. Run this command java -jar ords.war install advanced.
zg. Provide Configuration path & hit "Enter" button. "C:\12cR1_20.1\ords"
zh. Enter number for... [1]: Hit "Enter" button.
zi. Database server is [localhost]: Hit "Enter" button
zj. Enter listen port [1521]: Hit "Enter" button, my port is 1523 your port will be different.
zk. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl"
zl. Enter 1 if you want to verify... [1]: Hit "Enter" button.
zm. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zn. Enter administrator username, pass.., & Confirm pass...
zo. Enter the default... [SYSAUX]: Hit "Enter" button.
zp. Enter the temporary... [TEMP]: Hit "Enter" button.
zq. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zr. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zs. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zt. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zu. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zv. 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.
zw. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zx. Go to apex folder copy "images" folder from "C:\12cR1_20.1\apex" & paste it to "C:\12cR1_20.1\ords"
zy. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zz. Enter the APEX static resources...: Provide "image" path "C:\12cR1_20.1\ords\images"
zza. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zzb. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zzc. Open cmd with administrator rights, reach where ORDS folder is available (C:\12cR1_20.1\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.

Chapters
00:39 Creating Folders
01:45 Unzipping Folders
04:19 Database Installation
18:40 Uninstall Oracle APEX
22:09 Oracle APEX Installation
24:46 Oracle APEX Configuration
26:31 ORDS 21.3 Installation

#OmarBaig #OracleAPEX201Installation #OracleDatabase12cInstallation