How to Install Oracle APEX 22.1 | DB 19c [Pluggable] | Windows 10

Today we are going to Install Oracle APEX 22.1 and ORDS 21.4 with Database 19c [Pluggable] in Windows 10 InshaAllah.

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
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
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, Pass.., Confirm Pass.., & Pluggable Database Name" from your choice (orclpdb)
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. 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;
(when we shut down & start database, its states will remain READ WRITE)
& if it is close then run this command
ALTER PLUGGABLE DATABASE ORCLPDB OPEN;
p. Shut down database by running this command (we shutdown database to reflect the changes we did it in sga_max_size)
shut immediate;
q. Start it by running this command
startup
r. Check sga_max_size again by running this command
show parameter sga;
s. Open cmd & reach where apex folder is available
t. Run sqlplus /nolog
u. Connect as sys as sysdba
v. Run this command
ALTER SESSION SET CONTAINER = ORCLPDB;
(Make sure "Session altered" appear if not then connect again as sys / as sysdba)
w. Install apex by running this command
@apexins sysaux sysaux temp /i/
y. Run this command in cmd & make sure that you connect with "SYS" user
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle;
za. Open cmd again with "Administrator" rights & reach where ords is available.
zc. Provide Configuration path & hit "Enter". "C:\19c_22.1\ords"
zd. Enter number for... [1]: Hit "Enter".
ze. Database server is [localhost]: Hit "Enter".
zf. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different.
zg. Specify Database SID [1]: provide option "1" & hit "Enter", my database service name is "orclpdb"
zh. Enter 1 if you want to verify... [1]: Hit "Enter".
zi. Enter pass.. & Confirm pass.. for ORDS_PUBLIC_USER
zj. Enter administrator username, pass.., & Confirm pass...
zk. Enter the default... [SYSAUX]: Hit "Enter".
zl. Enter the temporary... [TEMP]: Hit "Enter".
zm. Enter the default... ORDS_PUBLIC_USER [SYSAUX]: Hit "Enter".
zn. Enter the temporary... ORDS_PUBLIC_USER [TEMP]: Hit "Enter".
zo. If using Oracle Application Express or migrating from... [1]: Hit "Enter".
zp. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter".
zq. Specify pass.., & Confirm pass.. for APEX_PUBLIC_USER.
zr. Enter 1 to specify pass.. for Application Express... [1]: Hit "Enter", specify pass.., & Confirm Pass.. for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER" from your choice.
zs. Enter a number to select a feature to enable [1] SQL Developer Web... [1]: Hit "Enter" button.
zt. Go to apex folder copy "images" folder from "C:\19c_22.1\apex" & paste it to "C:\19c_22.1\ords"
zu. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter".
zv. Enter the APEX static resources...: Provide "image" path "C:\19c_22.1\ords\images"
zw. Enter 1 if using HTTP.... [1]: Hit "Enter".
zx. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice.

Chapters
00:46 Creating Folders
02:04 Unzipping Folders
05:56 Database Installation
09:31 Oracle APEX Installation
12:44 Oracle APEX Configuration
15:03 ORDS 21.4 Installation

#OmarBaig #OracleAPEX221Installation #OracleDatabase19cInstallation

[basimfk]

how can i fix this

C:\19c_22.1\ords>java -jar ords.war install advanced
Error: Invalid or corrupt jarfile ords.war

[aamirhalai]

thodi detail me video bana samaj me aaye aesi