1- The installation requires
Before installing
Oracle Application Express (Oracle APEX)you need to:
- InstallOracle Database(10g,11g or 12c)
2- Download Oracle APEX
To download,you need to log in with an account of
Oracle,if not,you can register a free account.
3- Installing Oracle APEX
Decompress
zipfile you have downloaded in some position of hard disk drive. Here I decompress it at
C:/DevPrograms.
Note: Your folder must be named apex.This is compulsory.
Open
CMDand
CDto
apexdirectory:
Sign in to user
sys,as
sysdba.
Login successful:
Run script
apexins.sql
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
--
-- Run script apexins.sql with parameters:
--
-- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
--
-- Where:
-- tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
-- tablespace_files is the name of the tablespace for the Oracle Application Express files user.
-- tablespace_temp is the name of the temporary tablespace or tablespace group.
-- images is the virtual directory for Oracle Application Express images.
-- (To support future Oracle Application Express upgrades,define the virtual image directory as /i/.)
--
|
Wait for about 30 minutes until the above statement is completed.
The above script create some
SCHEMAon Database,you can test by querying view
ALL_USERSon
sqlPlus:
4- Configuring APEX
You need log in
sqlPlusagain from
CMDand sign in
sysuser as
sysdba.
apex_egp_config.sql
This script will load the
Application Expressimages into
XDBand then configure a
DADfor use by
Application Expressin the
Embedded PL/sql Gateway.
-- @apex_epg_config.sql <parent of apex directory>
--
@apex_epg_config.sql C:\DevPrograms
