How to Install Oracle APEX 22.1 | DB 19c | Windows 10
3.6 هزار بار بازدید -
2 سال پیش
-
Today we are going to
Today we are going to Install Oracle APEX 22.1 & ORDS 21.4 with Database 19c in Windows 10 InshaAllah.
Patreon: Patreon: OmarBaig
a. Create folder with name "19c_22.1" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 19c in (C:\19c_22.1\DB)
c. Download ORDS 21.4
https://www.oracle.com/tools/ords/ord...
d. Unzip ords 21.4 in "ords" folder (C:\19c_22.1\ords), so you do not need to copy & paste it (ords)
e. Download Oracle APEX 22.1 from this link
https://www.oracle.com/tools/download...
f. Unzip "V1020798-01" in a folder (C:\19c_22.1), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
g. Run database setup with "Administrator" rights.
h. Create and configure a single instance database.
i. Desktop Class.
j. Use Windows Built-in Account (you can use other option as well)
k. Assign "Global Database Name (orcl19), Pass.. & Confirm Pass.. from your choice, uncheck "Create as Container Database" option.
l. Hit "Install" button.
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 = 4000M 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 & reach where apex folder is available.
s. Run sqlplus /nolog
t. Connect as sys as sysdba
u. Install apex by running this command
@apexins sysaux sysaux temp /i/
v. Run @apxchpwd.sql, username is "ADMIN", email, & pass.. from your choice.
w. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
x. Run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Open cmd again with "Administrator" rights & reach where ords folder is available.
z. Run this command java -jar ords.war install advanced.
za. Provide Configuration path & hit "Enter" button. "C:\19c_22.1\ords"
zb. Enter number for... [1]: Hit "Enter" button.
zc. Database server is [localhost]: Hit "Enter" button
zd. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl19"
zf Enter 1 if you want to verify... [1]: Hit "Enter" button.
zg. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zh. Enter administrator username, pass.., & Confirm pass...
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.
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".
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:\19c_22.1\apex" & paste it to "C:\19c_22.1\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:\19c_22.1\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:\19c_22.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.
Search Tags:
Omar Baig, Oracle AEPX 22.1 Installation, How to Install Oracle AEPX 22.1, Oracle AEPX 22.1, How to Install Oracle AEPX 21.2, Oracle AEPX 21.2
Chapters
00:33 Creating Folders
01:18 Unzipping Folders
06:11 Database Installation
11:40 Oracle APEX Installation
12:52 Oracle APEX Configuration
15:12 ORDS 21.4 Installation
#OmarBaig #OracleAPEX221Installation #OracleDatabase19cInstallation
Patreon: Patreon: OmarBaig
a. Create folder with name "19c_22.1" under this folder we create 2 folder with name "DB" & "ords".
b. Unzip Oracle Database 19c in (C:\19c_22.1\DB)
c. Download ORDS 21.4
https://www.oracle.com/tools/ords/ord...
d. Unzip ords 21.4 in "ords" folder (C:\19c_22.1\ords), so you do not need to copy & paste it (ords)
e. Download Oracle APEX 22.1 from this link
https://www.oracle.com/tools/download...
f. Unzip "V1020798-01" in a folder (C:\19c_22.1), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
g. Run database setup with "Administrator" rights.
h. Create and configure a single instance database.
i. Desktop Class.
j. Use Windows Built-in Account (you can use other option as well)
k. Assign "Global Database Name (orcl19), Pass.. & Confirm Pass.. from your choice, uncheck "Create as Container Database" option.
l. Hit "Install" button.
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 = 4000M 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 & reach where apex folder is available.
s. Run sqlplus /nolog
t. Connect as sys as sysdba
u. Install apex by running this command
@apexins sysaux sysaux temp /i/
v. Run @apxchpwd.sql, username is "ADMIN", email, & pass.. from your choice.
w. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
x. Run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
y. Open cmd again with "Administrator" rights & reach where ords folder is available.
z. Run this command java -jar ords.war install advanced.
za. Provide Configuration path & hit "Enter" button. "C:\19c_22.1\ords"
zb. Enter number for... [1]: Hit "Enter" button.
zc. Database server is [localhost]: Hit "Enter" button
zd. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
ze. Specify Database SID [1]: provide option "2" & hit "Enter" button, my database SID is "orcl19"
zf Enter 1 if you want to verify... [1]: Hit "Enter" button.
zg. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zh. Enter administrator username, pass.., & Confirm pass...
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.
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".
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:\19c_22.1\apex" & paste it to "C:\19c_22.1\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:\19c_22.1\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:\19c_22.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.
Search Tags:
Omar Baig, Oracle AEPX 22.1 Installation, How to Install Oracle AEPX 22.1, Oracle AEPX 22.1, How to Install Oracle AEPX 21.2, Oracle AEPX 21.2
Chapters
00:33 Creating Folders
01:18 Unzipping Folders
06:11 Database Installation
11:40 Oracle APEX Installation
12:52 Oracle APEX Configuration
15:12 ORDS 21.4 Installation
#OmarBaig #OracleAPEX221Installation #OracleDatabase19cInstallation
2 سال پیش
در تاریخ 1401/02/30 منتشر شده
است.
3,638
بـار بازدید شده