Скачать или смотреть How to Install Oracle APEX 21.2 | DB 19c | Windows 10

Today we are going to Install Oracle APEX 21.2 & ORDS 21.3 with Database 19c in Windows 10 InshaAllah.

Patreon:   / omarbaig  

a. Create folder with name "19c_21.2" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 19c in (C:\19c_21.2\DB)
c. Unzip ords 21.3 in a folder "ords" (C:\19c_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:\19c_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 (orcl19), Pass.., Confirm Pass.. from your choice, & uncheck "Create as Container Database"
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 = 5000M SCOPE=SPFILE;
n. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
o. Start it by running this command
startup
p. Check sga_max_size again by running this command
show parameter sga;
q. Open cmd & reach where apex folder is available
r. Run sqlplus /nolog
s. Connect as sys as sysdba
t. Install apex by running this command
@apexins sysaux sysaux temp /i/
u. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
v. 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;
w. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
x. Open cmd again with "Administrator" rights & reach where ords is available.
y. Run this command java -jar ords.war install advanced.
z. Provide Configuration path & hit "Enter" button. "C:\19c_21.2\ords"
za. Enter number for... [1]: Hit "Enter" button.
zb. Database server is [localhost]: Hit "Enter" button
zc. 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 "orcl19"
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 from your choice.
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" from your choice.
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:\19c_21.2\apex" & paste it to "C:\19c_21.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:\19c_21.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.
zv. Open cmd with administrator rights, reach where ORDS folder is available (C:\19c_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 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

Chapters
00:40 Creating Folders
01:23 Unzipping Folders
05:26 Database Installation
11:44 Oracle APEX Installation
13:15 Oracle APEX Configuration
15:44 ORDS 21.3 Installation

#OmarBaig #OracleAPEX212Installation #OracleDatabase19cInstallation