Oracle Apex Installation
Installation of Oracle APEX 19.1 with Database 19c [pluggable] in Windows 10 4K patreon.com/OmarBaig a. Unzip Oracle Database 19c into location where you want to install it, so automatically it will restrict "Software location" to this folder (D:\app\19cp_19.1\DB) b. Unzip apex folder as well so we do not need to copy and paste it. c. Run setup as administrator. d. Create and configure a single instance database e. Desktop class. f. Use Windows Built-in Account. (you can use other option as well) g. Global database name, password, and Pluggable database name from your choice. h. Now open SQL Plus and connect as sys / as sysdba i. Check sga_max_size by running this command show parameter sga; Less than 3000M now increase it between 4000 - 5000M by running this command ALTER SYSTEM SET MEMORY_TARGET = 5000M SCOPE=SPFILE; j. Now shut down database by running this command shut immediate; k. Now start database by running this command startup l. After it starts check sga_max_size by running this command again show parameter sga; m. Now check pluggable database status by running this command SELECT name, open_mode FROM v$pdbs; if it is mounted then open it by running this command ALTER PLUGGABLE DATABASE ORCLPDB OPEN; ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE; (ORCLPDB is my pluggable database) this command will start pluggable database automatically when you start database. n. Now open command prompt and reach where apex folder is available. o. Connect as sys / as sysdba p. Now run this command before every apex scripts (@apexins, @apxchpwd.sql, @apex_rest_config.sql, @apex_epg_config.sql, @apxldimg.sql) ALTER SESSION SET CONTAINER = ORCLPDB; and make sure "Session altered" appear after running this command (ALTER SESSION SET CONTAINER = ORCLPDB;) if not then connect again as sys user. q. Now install apex. r. User ADMIN recommended, email and password from your choice. s. Give password for APEX_LISTENER and APEX_REST_PUBLIC_USER from your choice. t. Give path where apex folder is available. ALTER USER ANONYMOUS IDENTIFIED BY oracle ACCOUNT UNLOCK; Search Tags: Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Email through Oracle Apex 20.1 4K, Email through Oracle Apex 19.2 4K, Email through Oracle Apex 19.1 4K, Email through Oracle Apex 18.2 4K, Email through Oracle Apex 18.1, HOW TO SEND EMAIL USING ORACLE APEX, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, Create Setup Page in an Oracle APEX 20.1, Create Setup Form in an Oracle APEX 20.1, How to Create Setup Page in an Oracle APEX 20.1, How to Create Setup Form in an Oracle APEX 20.1, Create Master Detail Page in an Oracle APEX 20.1, Create Master Detail Form in an Oracle APEX 20.1, How to Create Master Detail Page in an Oracle APEX 20.1, How to Create Master Detail Form in an Oracle APEX 20.1, How to Create Dashboard in Oracle APEX, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Create Page Navigation, How to Create Link, How to Create Interactive Grid, Oracle APEX - Interactive Grid, Intro to Interactive Grid in Oracle APEX, HOW TO CREATE BUTTON IN ORACLE APEX, How to Create Button - Oracle APEX 20.1, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, Oracle APEX - Complete Guide to Dynamic Actions, Oracle APEX 20.1 - Format all Forms, Oracle APEX Installation, How to Install Android Studio on Windows 10, install android studio, Oracle APEX 20.2, Oracle APEX 20.2 Installation, How to Install Oracle JDeveloper 12c, install jdeveloper 12.2.1.4, install jdeveloper 12.2.1.3, install iReport 5.6.0, How to Install iReport 5.6.0 in Windows 10, Oracle APEX 21.1, Oracle APEX 21.1 Installation, How to Install Oracle APEX 21.1 Chapters 0:00 Database Installation 8:12 Pluggable Database Settings 21:33 Oracle APEX Installation 24:36 Oracle APEX Configuration #OmarBaig #OracleAPEX191Installation #OracleDatabase19cInstallation
Installation of Oracle APEX 19.1 with Database 19c [pluggable] in Windows 10 4K patreon.com/OmarBaig a. Unzip Oracle Database 19c into location where you want to install it, so automatically it will restrict "Software location" to this folder (D:\app\19cp_19.1\DB) b. Unzip apex folder as well so we do not need to copy and paste it. c. Run setup as administrator. d. Create and configure a single instance database e. Desktop class. f. Use Windows Built-in Account. (you can use other option as well) g. Global database name, password, and Pluggable database name from your choice. h. Now open SQL Plus and connect as sys / as sysdba i. Check sga_max_size by running this command show parameter sga; Less than 3000M now increase it between 4000 - 5000M by running this command ALTER SYSTEM SET MEMORY_TARGET = 5000M SCOPE=SPFILE; j. Now shut down database by running this command shut immediate; k. Now start database by running this command startup l. After it starts check sga_max_size by running this command again show parameter sga; m. Now check pluggable database status by running this command SELECT name, open_mode FROM v$pdbs; if it is mounted then open it by running this command ALTER PLUGGABLE DATABASE ORCLPDB OPEN; ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE; (ORCLPDB is my pluggable database) this command will start pluggable database automatically when you start database. n. Now open command prompt and reach where apex folder is available. o. Connect as sys / as sysdba p. Now run this command before every apex scripts (@apexins, @apxchpwd.sql, @apex_rest_config.sql, @apex_epg_config.sql, @apxldimg.sql) ALTER SESSION SET CONTAINER = ORCLPDB; and make sure "Session altered" appear after running this command (ALTER SESSION SET CONTAINER = ORCLPDB;) if not then connect again as sys user. q. Now install apex. r. User ADMIN recommended, email and password from your choice. s. Give password for APEX_LISTENER and APEX_REST_PUBLIC_USER from your choice. t. Give path where apex folder is available. ALTER USER ANONYMOUS IDENTIFIED BY oracle ACCOUNT UNLOCK; Search Tags: Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Email through Oracle Apex 20.1 4K, Email through Oracle Apex 19.2 4K, Email through Oracle Apex 19.1 4K, Email through Oracle Apex 18.2 4K, Email through Oracle Apex 18.1, HOW TO SEND EMAIL USING ORACLE APEX, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, Create Setup Page in an Oracle APEX 20.1, Create Setup Form in an Oracle APEX 20.1, How to Create Setup Page in an Oracle APEX 20.1, How to Create Setup Form in an Oracle APEX 20.1, Create Master Detail Page in an Oracle APEX 20.1, Create Master Detail Form in an Oracle APEX 20.1, How to Create Master Detail Page in an Oracle APEX 20.1, How to Create Master Detail Form in an Oracle APEX 20.1, How to Create Dashboard in Oracle APEX, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Create Page Navigation, How to Create Link, How to Create Interactive Grid, Oracle APEX - Interactive Grid, Intro to Interactive Grid in Oracle APEX, HOW TO CREATE BUTTON IN ORACLE APEX, How to Create Button - Oracle APEX 20.1, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, Oracle APEX - Complete Guide to Dynamic Actions, Oracle APEX 20.1 - Format all Forms, Oracle APEX Installation, How to Install Android Studio on Windows 10, install android studio, Oracle APEX 20.2, Oracle APEX 20.2 Installation, How to Install Oracle JDeveloper 12c, install jdeveloper 12.2.1.4, install jdeveloper 12.2.1.3, install iReport 5.6.0, How to Install iReport 5.6.0 in Windows 10, Oracle APEX 21.1, Oracle APEX 21.1 Installation, How to Install Oracle APEX 21.1 Chapters 0:00 Database Installation 8:12 Pluggable Database Settings 21:33 Oracle APEX Installation 24:36 Oracle APEX Configuration #OmarBaig #OracleAPEX191Installation #OracleDatabase19cInstallation