Скачать с ютуб How to Install Oracle APEX 20.2 | DB 18c [Pluggable] | ORDS 20.3 в хорошем качестве

How to Install Oracle APEX 20.2 | DB 18c [Pluggable] | ORDS 20.3

Today we are going to Install Oracle APEX 20.2 and ORDS 20.3 with Database 18c [Pluggable] in Windows 10 InshaAllah. patreon.com/OmarBaig a. Unzip it where you want to Install Oracle Database 18c 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 20.3 as well. d. Run database setup with "Administrator" rights. e. Create & configure a single instance database. f. Desktop Class. g. Use Windows Built-in Account (you can use other option as well) h. Assign "Global Database Name, Password, Confirm Password, & Pluggable Database Name" from your choice (orclpdb) i. Hit "Install" button. (Global Database Name is "orcl1822", & "Pluggable Database Name" is "orclpdb") j. Open SQL Plus & connect as sys / as sysdba k. 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; l. 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; (ORCLPDB is my pluggable database) (when we shut down & start database, its states will remain READ WRITE) & if it is close then run this command ALTER PLUGGABLE DATABSE ORCLPDB OPEN; 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. Run this command ALTER SESSION SET CONTAINER = ORCLPDB; (this command will run before every apex scripts @apexins, @apxchpwd.sql, @apex_rest_config.sql) (& make sure "Session altered" appear if not then connect again as sys / as sysdba) Make sure you are in "Pluggable Database" while running this command "show pdbs;" u. Install apex by running this command @apexins sysaux sysaux temp /i/ v. Run @apxchpwd.sql, username is "ADMIN", email, & password from your choice. w. Run @apex_rest_config.sql (provide password for APEX_LISTENER, & APEX_REST_PUBLIC_USER) x. Open SQL Plus connect sys as sysdba & run this command ALTER SESSION SET CONTAINER = ORCLPDB; ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK; y. Exit cmd. z. Open Cmd again with "Administrator" rights & reach where ords folder is available. za. Run this command java -jar ords.war install advanced. zb. Provide Configuration path & hit "Enter" button. "C:\18c_20.2\ords" zc. Enter number... [1]: Hit "Enter" button. zd. Database server is [localhost]: Hit "Enter" button ze. Enter listen port [1521]: Hit "Enter" button, my port is 1521 your port will be different. zf. Specify Database SID [1]: provide option "1"& hit "Enter" button, my database service name is "orclpdb" zg Enter 1 if you want... [1]: Hit "Enter" button. zh. Enter password & Confirm password for ORDS_PUBLIC_USER zi. Enter administrator username, password, & Confirm password. zj. Enter the... [SYSAUX]: Hit "Enter" button. zk. Enter the... [TEMP]: Hit "Enter" button. zl. Enter the default... ORDS_PUBLIC_USER [USERS]: Hit "Enter" button. zm. Enter the... ORDS_PUBLIC_USER [TEMP]: Hit "Enter" button. zn. If using Oracle Application Express... [1]: Hit "Enter" button zo. Enter the PL/SQL Gateway... [APEX_PUBLIC_USER]: Hit "Enter" button. zp. Specify password, & Confirm password for APEX_PUBLIC_USER. zq. Enter 1 to specify passwords... [1]: Hit "Enter" button & specify password, & Confirm Password for both "APEX_LISTENER" & "APEX_REST_PUBLIC_USER". zr. Enter a number to select a feature to enable... [1]: Hit "Enter" button. zs. Go to apex folder copy "images" folder from "C:\18c_20.2\apex" & paste it to "C:\18c_20.2\ords" zt. Enter 1 if you wish to start in standalone mode... [1]: Hit "Enter" button zu. Enter the APEX static...: Provide "image" path "C:\18c_20.2\ords\images" zv. Enter 1 if using HTTP.... [1]: Hit "Enter" button. zw. Enter the HTTP Port [8080]: Hit "Enter" button or define from your choice. zx. Open cmd with administrator rights, reach where ORDS folder is available (C:\18c_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, Install APEX 20.1, Oracle APEX 20.1 Installation, Oracle APEX Installation, How to Install Android Studio on Windows 10, Oracle APEX 20.2, Oracle APEX 20.2 Installation Chapters 00:00 Unzipping Folders 02:51 Database Installation 07:54 Pluggable Database Settings 13:18 Oracle APEX Installation 16:01 Oracle APEX Configuration 19:21 ORDS 20.3 #OmarBaig #OracleAPEX202 #OracleAPEX202Installation