How to Install Oracle APEX 21.2 | DB 12cR1 Pluggable | Executive | Windows 10
Today we are going to Install Oracle APEX 21.2 and ORDS 21.4 with Database 12c Release 1 [Pluggable] in Windows 10 InshaAllah. [Quickly]
Patreon: / omarbaig
a. Create folder with name "12cR1_21.2" under this folder we create 2 folder with name "DB" & "ords".
b. Download ORDS 21.4 from this link
https://www.oracle.com/database/techn...
c. Unzip ords 21.4 in a folder "ords" (C:\12cR1_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/download...
e. Unzip "apex_21.2" in a folder (C:\12cR1_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. 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" (C:\12cR1_21.2\DB) while hitting "Browse" button, "Global Database Name, Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (pdborcl)
l. Hit "Install" button.
m. Click on "Password Management" button, and provide pass.. (SYS & SYSTEM)
n. Open cmd & reach apex directory in Database 12cR1 home. (C:\12cR1_21.2\DB\product\12.1.0\dbhome_1\apex)
o. Run sqlplus /nolog
p. Connect with sys / as sysdba
q. 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;
r. Check Pluggable database status by running this command
SELECT name, open_mode
FROM v$pdbs;
if it is OPEN (READ WRITE) mode then run this command
ALTER PLUGGABLE DATABASE PDBORCL SAVE STATE;
& if it is close then run this command
ALTER PLUGGABLE DATABSE PDBORCL OPEN;
s. Shut down database by running this command
shut immediate;
t. Start it by running this command
startup
u. Check sga_max_size again by running this command
show parameter sga;
v. Remain in cmd.
w. Connect with Root Container while running this command
ALTER SESSION SET CONTAINER = CDB$ROOT;
x 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%'; uninstall it while running this command
@apxremov_con.sql
y. Remain in cmd & reach where apex folder is available
z. Run sqlplus /nolog
za. Connect as sys as sysdba
zb. Run this command
show pdbs;
ALTER SESSION SET CONTAINER = PDBORCL;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
zc. Install apex by running this command
@apexins sysaux sysaux temp /i/
zd. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
ze. Run these commands in cmd & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
zf. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
zg. Open cmd again with "Administrator" rights & reach where ords is available.
zh. Run this command java -jar ords.war install advanced.
zi. Provide Configuration path & hit "Enter". "C:\12cR1_21.2\ords"
zj. Enter number for... [1]: Hit "Enter".
zk. Database server is [localhost]: Hit "Enter".
zl. Enter listen port [1521]: Hit "Enter"
zm. Specify Database SID [1]: provide option "1" & hit "Enter"
zn. Enter 1 if you want to verify... [1]: Hit "Enter".
zo. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zp. Enter administrator username, pass.., & Confirm pass...
zq. Enter the default... [SYSAUX]: Hit "Enter".
zr. Enter the temporary... [TEMP]: Hit "Enter".
zs. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter".
zt. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter".
zu. If using Oracle Application... [1]: Hit "Enter".
zv. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter".
zw. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER
zx. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button, specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER"
zy. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter".
zz. Go to apex folder copy "images" folder from "C:\12cR1_21.2\apex" & paste it to "C:\12cR1_21.2\ords"
zza. Enter 1 if you wish to start... [1]: Hit "Enter".
zzb. Enter the APEX static resources...: Provide "image" path "C:\12cR1_21.2\ords\images"
zzc. Enter 1 if using HTTP.... [1]: Hit "Enter".
zzd. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zze. Open cmd with administrator rights, reach where ORDS folder is available (C:\12cR1_21.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 #OracleAPEX212Installation #OracleDatabase12cR1Installation