Скачать или смотреть Oracle APEX 20.2 Installation | Executive

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

Today we are going to Install Oracle APEX 20.2 and ORDS 20.3 with Database 12c Release 2 in Windows 10 InshaAllah. 4K

patreon.com/OmarBaig

a. Unzip it where you want to Install Oracle Database 12 R2
b. Unzip "apex_20.2" to the folder where you want to install it, so you do not need to copy & paste it (apex)
c. Unzip ords 19.4 as well.
d. Run database setup from "Administrator"
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. Assign "Global Database Name, & Pass.. from your choice, uncheck "Create as Container Database"
j. Hit "Install" button.
k. Open SQL Plus & connect as sys / as sysdba
l. 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;
m. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
n. Open SQL Plus again & connect as sys / as sysdba
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", email, & pass.. from your choice.
v. Run @apex_rest_config.sql (provide password for APEX_LISTENER, & APEX_REST_PUBLIC_USER from your choice)
w. Run these command with sys / as sysdba in SQL Plus
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
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:\12c_20.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 1523 your port will be different.
zd. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl1222"
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 1 if you want to install... [1]: Hit "Enter" button.
zi. Enter the default... [SYSAUX]: Hit "Enter" button.
zj. Enter the temporary... [TEMP]: Hit "Enter" button.
zk. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter" button.
zl. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button.
zm. If using Oracle Application Express or migrating from... [1]: Hit "Enter" button
zn. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button.
zo. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER from your choice.
zp. 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.
zq. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zr. Go to apex folder copy "images" folder from "C:\12c_20.2\apex" & paste it to "C:\12c_20.2\ords"
zs. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zt. Enter the APEX static resources...: Provide "image" path "C:\12c_20.2\ords\images"
zu. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zv. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zw. Open cmd with administrator rights, reach where ORDS folder is available (C:\12c_20.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.

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, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Create Page Navigation, How to Create Link, How to Create Interactive Grid, Oracle APEX - Interactive Grid, Intro to Interactive Grid in Oracle APEX, HOW TO CREATE BUTTON IN ORACLE APEX, How to Create Button - Oracle APEX 20.1, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, Oracle APEX - Complete Guide to Dynamic Actions, Oracle APEX 20.1 - Format all Forms, Oracle APEX Installation, How to Install Android Studio on Windows 10, Oracle APEX 20.2, Oracle APEX 20.2 Installation, install jdeveloper 12.2.1.4, install jdeveloper 12.2.1.3, install iReport 5.6.0

Chapters
00:00 Unzipping Folders
02:18 Database Installation
04:37 Database Settings
06:33 Oracle APEX Installation
07:19 Oracle APEX Configuration
08:39 ORDS 20.3

#OmarBaig #OracleAPEX202 #OracleAPEX202Installation