How to Install Oracle APEX 22.1 | DB 21c [Pluggable] | Windows 10
3.8 هزار بار بازدید -
2 سال پیش
-
Today we are going to
Today we are going to Install Oracle APEX 22.1 and ORDS 21.4 with Database 21c [Pluggable] in Windows 10 InshaAllah.
Patreon: Patreon: OmarBaig
a. Create folder with name "21c_22.1" under this folder we create 2 folder with name "DB" & "ords".
b. We can download Oracle Database 21c from
https://www.oracle.com/database/techn...
c. Unzip Oracle Database 21c in (C:\21c_22.1\DB)
d. Download ORDS 21.4
https://www.oracle.com/tools/ords/ord...
e. Unzip ords 21.4 in "ords" folder (C:\21c_22.1\ords), so we do not need to copy & paste it (ords)
f. Download Oracle APEX 22.1 from this link
https://www.oracle.com/tools/download...
g. Unzip "V1020798-01" in a folder (C:\21c_22.1), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
h. Run db setup with "Administrator" rights.
i. Create & configure a single instance database.
j. Desktop Class.
k. Use Windows Built-in Account (you can use other option as well)
l. Assign "Global Database Name(orcl21), Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (orclpdb).
m. Hit "Install" button.
n. Open SQL Plus & connect as sys / as sysdba
o. 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;
p. Check Pluggable database status by running this command
SELECT name, open_mode
FROM v$pdbs;
if it is OPEN (READ WRITE) then run this command
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;
& if it is close then run this command
ALTER PLUGGABLE DATABASE ORCLPDB OPEN;
q. Shut down database by running this command
shut immediate;
r. Start it by running this command
startup
s. Check sga_max_size again by running this command
show parameter sga;
t. Open cmd & reach where apex folder is available.
u. Run sqlplus /nolog
v. Connect with sys / as sysdba
w. Run this command
show pdbs; (this command will run before every apex scripts @apexins, @apxchpwd.sql, @apex_rest_config.sql to make sure that we connect with pluggable database or not, if we connect it then run apex scripts, if not then run below command)
ALTER SESSION SET CONTAINER = ORCLPDB;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
x. Install apex by running this command
@apexins sysaux sysaux temp /i/
y. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
z. Unlock user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
za. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
zb. Open cmd t again with "Administrator" rights & reach where ords folder is available.
zc. Run this command java -jar ords.war install advanced.
zd. Provide Configuration path & hit "Enter" button. "C:\21c_22.1\ords"
ze. Enter number for... [1]: Hit "Enter".
zf. Database server is [localhost]: Hit "Enter".
zg. Enter listen port [1521]: Hit "Enter", my port is 1521 your port will be different.
zh. Specify Database SID [1]: provide option "1" & hit "Enter" button, my database service name is "orclpdb"
zi. Enter 1 if you want to verify... [1]: Hit "Enter".
zj. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zk. Enter administrator username, pass.., & Confirm pass...
zl. Enter the default... [SYSAUX]: Hit "Enter".
zm. Enter the temporary... [TEMP]: Hit "Enter".
zn. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter".
zo. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter".
zp. If using Oracle Application Express or migrating from... [1]: Hit "Enter".
zq. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter".
zr. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER.
zs. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button, specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER" from your choice.
zt. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zu. Go to apex folder copy "images" folder from "C:\21c_22.1\apex" & paste it to "C:\21c_22.1\ords"
zv. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zw. Enter the APEX static resources...: Provide "image" path "C:\21c_22.1\ords\images"
zx. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zy. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zz. Open cmd with administrator rights, reach where ORDS folder is available (C:\21c_21.2\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize cmd not close it.
Chapters
00:41 Creating Folders
01:53 Unzipping Folders
08:52 Database Installation
11:35 Pluggable Database Setting
16:37 Oracle APEX Installation
19:34 Oracle APEX Configuration
21:15 ORDS 21.4 Installation
#OmarBaig #OracleAPEX221Installation #OracleDatabase21cInstallation
Patreon: Patreon: OmarBaig
a. Create folder with name "21c_22.1" under this folder we create 2 folder with name "DB" & "ords".
b. We can download Oracle Database 21c from
https://www.oracle.com/database/techn...
c. Unzip Oracle Database 21c in (C:\21c_22.1\DB)
d. Download ORDS 21.4
https://www.oracle.com/tools/ords/ord...
e. Unzip ords 21.4 in "ords" folder (C:\21c_22.1\ords), so we do not need to copy & paste it (ords)
f. Download Oracle APEX 22.1 from this link
https://www.oracle.com/tools/download...
g. Unzip "V1020798-01" in a folder (C:\21c_22.1), so we do not need to copy & paste it (apex folder)
Java version is Java 8 update 211 (java -version)
h. Run db setup with "Administrator" rights.
i. Create & configure a single instance database.
j. Desktop Class.
k. Use Windows Built-in Account (you can use other option as well)
l. Assign "Global Database Name(orcl21), Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (orclpdb).
m. Hit "Install" button.
n. Open SQL Plus & connect as sys / as sysdba
o. 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;
p. Check Pluggable database status by running this command
SELECT name, open_mode
FROM v$pdbs;
if it is OPEN (READ WRITE) then run this command
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;
& if it is close then run this command
ALTER PLUGGABLE DATABASE ORCLPDB OPEN;
q. Shut down database by running this command
shut immediate;
r. Start it by running this command
startup
s. Check sga_max_size again by running this command
show parameter sga;
t. Open cmd & reach where apex folder is available.
u. Run sqlplus /nolog
v. Connect with sys / as sysdba
w. Run this command
show pdbs; (this command will run before every apex scripts @apexins, @apxchpwd.sql, @apex_rest_config.sql to make sure that we connect with pluggable database or not, if we connect it then run apex scripts, if not then run below command)
ALTER SESSION SET CONTAINER = ORCLPDB;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
x. Install apex by running this command
@apexins sysaux sysaux temp /i/
y. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice.
z. Unlock user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
za. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER)
zb. Open cmd t again with "Administrator" rights & reach where ords folder is available.
zc. Run this command java -jar ords.war install advanced.
zd. Provide Configuration path & hit "Enter" button. "C:\21c_22.1\ords"
ze. Enter number for... [1]: Hit "Enter".
zf. Database server is [localhost]: Hit "Enter".
zg. Enter listen port [1521]: Hit "Enter", my port is 1521 your port will be different.
zh. Specify Database SID [1]: provide option "1" & hit "Enter" button, my database service name is "orclpdb"
zi. Enter 1 if you want to verify... [1]: Hit "Enter".
zj. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zk. Enter administrator username, pass.., & Confirm pass...
zl. Enter the default... [SYSAUX]: Hit "Enter".
zm. Enter the temporary... [TEMP]: Hit "Enter".
zn. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter".
zo. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter".
zp. If using Oracle Application Express or migrating from... [1]: Hit "Enter".
zq. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter".
zr. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER.
zs. Enter 1 to specify passwords for Application Express... [1]: Hit "Enter" button, specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER" from your choice.
zt. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zu. Go to apex folder copy "images" folder from "C:\21c_22.1\apex" & paste it to "C:\21c_22.1\ords"
zv. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button
zw. Enter the APEX static resources...: Provide "image" path "C:\21c_22.1\ords\images"
zx. Enter 1 if using HTTP.... [1]: Hit "Enter" button.
zy. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.
zz. Open cmd with administrator rights, reach where ORDS folder is available (C:\21c_21.2\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize cmd not close it.
Chapters
00:41 Creating Folders
01:53 Unzipping Folders
08:52 Database Installation
11:35 Pluggable Database Setting
16:37 Oracle APEX Installation
19:34 Oracle APEX Configuration
21:15 ORDS 21.4 Installation
#OmarBaig #OracleAPEX221Installation #OracleDatabase21cInstallation
2 سال پیش
در تاریخ 1401/02/13 منتشر شده
است.
3,828
بـار بازدید شده