Oracle Apex Installation

Installation of Oracle APEX 18.2 with Database 18c [pluggable] in Windows 10 4K

Patreon:   / omarbaig  

a. Unzip database folder to the location where you want to install Oracle Database 18c so it will restrict installation automatically in one folder and it
will set "Software location" to this folder C:\18c_19.1\DB
b. Unzip apex folder as well so we can not copy and paste to apex folder.
c. Run this setup as administrator.
d. Create and configure a single instance database.
e. Desktop class.
f. Use Windows Built-in account (you can select other option as well)
g. select password, global database name, and pluggable database from your choice.
h. Connect with sys / as sysdba
i. Check sga_max_size by running this command
show parameter sga;
if it is less than 3000m then increase it to 4000m-5000m by running this command
ALTER SYSTEM SET MEMORY_TARGET = 5000M SCOPE=SPFILE;
j. Now shutdown database by running this command
shut immediate
k. Now startup by running this command
startup
l. Now again check sga_max_size by running this command
show parameter sga;
m. Check pluggable database 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; (ORCLPDB is my pluggable database.) run this command as well
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE; (when you shutdown database and start it so pluggable
database will start automatically.)
n. run command prompt and reach to the folder where apex is located.
o. Connect with sys / as sysdba
p. Run this command ALTER SESSION SET CONTAINER = ORCLPDB; (Run this command before every apex scripts
such as @apexins, @apxchpwd.sql, @apex_rest_config.sql, @apex_epg_config.sql, @apxldimg.sql) and make sure
"Session altered" appear after running this command ALTER SESSION SET CONAINER = ORCLPDB;
q. Run apex script for installation.
r. User ADMIN, email and password from your choice.
s. Give password to APEX_LISTENER and APEX_REST_PUBLIC_USER from your choice.
t. Give location where apex folder is available. (C:\18c_19.1)
u. Open SQL Plus and connect as sys / as sysdba and run this command
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, How to install Oracle Database 18c Express Edition, How to install Oracle Database 19c, How to Install Oracle Forms & Reports 11g in Windows 10, How to install Oracle Database 21c, Oracle Database 21c Installation, How to install Oracle Database 21c Express Edition, Oracle Database 21c Express Edition Installation, How to Deinstall Oracle Database 21c Express Edition, Oracle AEPX 21.2 Installation, How to Install Oracle AEPX 21.2, Oracle AEPX 21.2, How to Install Oracle Forms & Reports 12c in Windows 10, rep-50125 rwbuilder.conf java.lang.nullpointerexception 12c, ora-04091 mutating-table error

Chapters
0:00 Database Installation
10:01 Pluggable Database Settings
21:58 Oracle APEX Installation
28:46 Oracle APEX Configuration

#OmarBaig #OracleAPEX182 #OracleAPEX182Installation