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

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

Patreon:   / omarbaig  

a. Unzip it where you want to Install Oracle Database 19c
b. Unzip ords 21.3 as well.
While extracting Database 19c & ords 21.3 we will create separate folder with name "DB" & "ords" respectively, so all the respected files will extract in respected folders.
c. Unzip "apex_21.1" 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)
d. Run database setup with "Administrator" rights.
e. Create and configure a single instance database.
f. Desktop Class.
g. Use Windows Built-in Account (you can use other option as well)
h. Assign "Global Database Name (orcl21), Pass.. & Confirm Pass.. from your choice, uncheck "Create as Container Database"
i. Hit "Install" button.
Database 19c Installation has completed
j. Open SQL Plus & connect as sys / as sysdba
k. 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;
l. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
m. Start it by running this command
startup
n. Check sga_max_size again by running this command
show parameter sga;
o. Open cmd & reach where apex folder is available.
p. Run sqlplus /nolog
q. Connect as sys as sysdba
r. Install apex by running this command
@apexins sysaux sysaux temp /i/
s. Run @apxchpwd.sql, username is "ADMIN", email, & pass.. from your choice.
t. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
u. Run these command with sys / as sysdba in SQLPlus
ALTER USER ANONYMOUS IDENTIFIED BY oracle ACCOUNT UNLCOK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
v. Open cmd prompt again with "Administrator" rights & reach where ords is available.
w. Run this command java -jar ords.war install advanced.
x. Provide Configuration path & hit "Enter" button. "C:\19c_21.1\ords"
y. Enter number for... [1]: Hit "Enter" button.
z. Database server is [localhost]: Hit "Enter" button
za. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zb. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl21"
zc Enter 1 if you want to verify... [1]: Hit "Enter" button.
zd. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
ze. Enter administrator username, pass.., & Confirm pass...
zf. Enter the default... [SYSAUX]: Hit "Enter" button.
zg. Enter the temporary... [TEMP]: Hit "Enter" button.
zh. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zi. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zj. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zk. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zl. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zm. Enter 1 to specify pass.. for Application Express... [1]: Hit "Enter" button & specify pass.., & Confirm Pass.. for both "APEX_LISTENER" and "APEX_REST_PUBLIC_USER" from your choice.
zn. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zo. Go to apex folder copy "images" folder from "C:\19c_21.1\apex" & paste it to "C:\19c_21.1\ords"
zp. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zq. Enter the APEX static resources...: Provide "image" path "C:\19c_21.1\ords\images"
zr. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zs. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zt. Open cmd with administrator rights, reach where ORDS folder is available (C:\19c_21.1\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt 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 18c Express Edition, How to install Oracle Database 19c, How to install Oracle Database 21c, Oracle Database 21c Installation, How to install Oracle Database 21c Express Edition, Oracle Database 21c Express Edition Installation, How to Deinstall Oracle Database 21c Express Edition

Chapters
00:40 Unzipping Folders
03:46 Database Installation
10:24 Oracle APEX Installation
12:05 Oracle APEX Configuration
14:27 ORDS 21.3 Installation

#OmarBaig #OracleAPEX211Installation #OracleDatabase19cInstallation