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

Today we are going to Install Oracle APEX 22.1 and ORDS 21.4 with Database 19c [Pluggable] in Windows 10 InshaAllah. [Quickly] not good Patreon: https://www.patreon.com/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:c_22.1\DB) c. Download ORDS 21.4 https://www.oracle.com/tools/ords/ords-downloads-2143.html d. Unzip ords 21.4 in "ords" folder (C:c_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/downloads/apex-downloads.html# f. Unzip "V1020798-01" in a folder (C:c_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 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) w. Install apex by running this command @apexins sysaux sysaux temp /i/ x. Run @apxchpwd.sql, username is "ADMIN", provide email, & pass.. from your choice. y. Run this command in cmd & make sure that you connect with "SYS" user ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle; z. Run @apex_rest_config.sql (provide pass.. for APEX_LISTENER, & APEX_REST_PUBLIC_USER) za. Open cmd again with "Administrator" rights & reach where ords is available. zb. Run this command java -jar ords.war install advanced. zc. Provide Configuration path & hit "Enter". "C:c_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:c_22.1\apex" & paste it to "C:c_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:c_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. zy. Open cmd with administrator rights, reach where ORDS folder is available (C:c_22.1\ords) & run this command "java -jar ords.war", when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize cmd do not close it. Chapters 00:34 Creating Folders 01:00 Unzipping Folders 03:48 Database Installation 05:53 Oracle APEX Installation 10:55 Oracle APEX Configuration 12:08 ORDS 21.4 Installation #OmarBaig #OracleAPEX221Installation #OracleDatabase19cInstallation