1. UNZIP 

   -  Oracle DB 11g

   -  APEX 5.1

   -  SQL Developer 4.2

2. Oracle DB 11g 설치

  C:\Users\Jong\Documents\OracleXE112_Win64 (1)\DISK1

  RUN SETUP

  PW: Kims123!  (case sensitive)

3. OPEN Folder

   C:\Users\Jong\Documents\sqldeveloper-4.2.0.17.089.1709-x64\sqldeveloper

   CREATE SHORT-CUT (SQL Developer) and move to FRONT WINDOW

4. RUN SQL Developer

   SQL Developer

5. Connection SYSTEM

   SYSTEM

   system

   Kims123!

6.create tablespace GPUSA Datafile

 'C:\oraclexe\APP\ORACLE\ORADATA\XE\GPUSA.DBF'  SIZE 20M AUTOEXTEND ON;

(* SQL Developer / SYSTEM 에서 )

7. SQL Developer USER Create (GPUSA) 

   Password는 맘대로 지정 

   Granted Role / System Privilege = Grant all /Admin all 

   Workspace = GPUSA

8. NEW CONNECTION

   GPUSA 

9 APEX 5.1 Configuration

CMD> cd c:\oraclexe\apex 

Step 2 - Upgrade to Version 

CMD> sqlplus system/password as sysdba

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

@apexins.sql APEX APEX TEMP /i/

Step 3 - Set images directory 

CMD> sqlplus system/password as sysdba

SQL> @apxldimg.sql c:\oraclexe

Step 4 - Set Admin password 

SQL> @apxchpwd.sql password

Step 5 - Enable remote http connections

SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);

Login

URL: http://127.0.0.1:8080/apex/f?p=4550:10:

Workspace: Internal 

Username: Admin 

Password: password

DUMP File >>>> IMPORT