today:
248
yesterday:
251
Total:
1,112,182

General Process

admin 2018.05.05 14:35 Views : 267

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 에서 )

 

7SQL 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