KWCR3.0 instration

KeyWeb Creator R3.0 R3.0 for MS-Windows 2005 10 B25586-01 Oracle Oracle Oracle Corporation Copyright 2005, Oracle Corporation All Right Reserved

KeyWeb Creator R3.0 2005 10 Copyright 1997-2005 KeyWeb Creator ORACLE Oracle Corporation 2 KeyWeb Creator R3.0

HTML SQL KeyWeb Creator KeyWeb Creator HTML WYSIWYG HTML SQL HTML Portal WebCache WebCache 3

... 3... 5 KeyWeb Creator... 6 KeyWeb Creator... 9 KeyWeb Creator... 10... 11... 11... 14... 19 KeyWeb Creator R3.0... 23... 24 WebCache... 34 Web... 37... 39 Not... Found 40 ORA-12899... 41 A... 42 B... 44 4 KeyWeb Creator R3.0

KeyWeb Creator 5

KeyWeb Creator KeyWeb Creator Oracle Oracle Net Web 1 HTML WebCache HTML 6 KeyWeb Creator R3.0

KeyWeb Creator HTML SQL HTML HTML HTML 7

2 3 HTML HTML SQL SQL SQL HTML PL/SQL PL/SQL 4 8 KeyWeb Creator R3.0

KeyWeb Creator 1. Pentium Windows95/98 NT4.0Windows2000/XP 8MB 12MB Oracle Net 8.0 2. Oracle Oracle 8 Oracle8 Oracle9i Database Release1(9.0.1) Oracle8i R8.1.7 HTTP Oracle9i Application Server 1.0.2 Oracle9i Application Server Release 2(9.0.2) Oracle Application Server 10g(9.0.4) Oracle Application Server 10g(10.1.2.0.0) 9

KeyWeb Creator KeyWeb Creator 10 KeyWeb Creator R3.0

KeyWeb Creator 1. 2. DLL Windows DLL Mfc42.dll Ctl3d32.dll Msvcrt.dll Msvcrt40.dll 3. 4. HKEY_CURRENT_USER Software Tenik KeyWeb Creator KeyWeb Creator KeyWeb Creator 11

1. Oracle Net KeyWeb Creator Oracle Net Oracle Net 2. TNS KeyWeb Creator Oracle Net KeyWeb Creator Oracle Net 3. DLL Windows Inloader.dll Wininet.dll Schannel.dll Jawint.exe KeyWeb Creator KeyWeb Creator Jawint.exe Jawint Jawint.exe Microsoft 12 KeyWeb Creator R3.0

4. WWW KeyWeb Creator Web Netscape Navigator 1 Microsoft 2 1Netscape Communications Corporation 2Microsoft Corporation KeyWeb Creator 13

KeyWeb Creator Setup.exe 1. CD-ROM KWC30 Setup.exe 2. 3. 14 KeyWeb Creator R3.0

4. [ ] [ ] [ ] 5. KeyWeb Creator 15

6. [ ] 7. 16 KeyWeb Creator R3.0

8. [ ] KeyWeb Creator 17

9. [ ] 18 KeyWeb Creator R3.0

KeyWeb Creator KeyWeb Creator KeyWeb Creator Oracle Net Oracle KeyWeb Creator KeyWeb Creator Oracle Net Install.sql SQL*Plus SQL*Plus S system 1. <KeyWebCreator > SQL*Plus > <KeyWebCreator 5 2. 3. scott Oracle KeyWeb Creator 19

KWC_USER USERS TEMP TABLESPACE SQL> CREATE USER KWC_USER IDENTIFIED BY KWC_USER SQL> DEFAULT TABLESPACE USERS SQL> TEMPORARY TABLESPACE TEMP; 3. TABLE SPACE UNLIMITED TABLESPACE CREATE TABLE CREATE VIEW 2 Install.sql REVOKE SQL> GRANT UNLIMITED TABLESPACE TO KWC_USER; SQL> GRANT CREATE SESSION TO KWC_USER; SQL> GRANT CREATE PROCEDURE TO KWC_USER; SQL> GRANT CREATE TABLE TO KWC_USER; SQL> GRANT CREATE VIEW TO KWC_USER; SQL> GRANT CREATE ANY TRIGGER TO KWC_USER; SQL> GRANT SELECT ANY TABLE TO KWC_USER; SQL> GRANT DROP ANY TRIGGER TO KWC_USER; SQL> GRANT CREATE TRIGGER TO KWC_USER; SQL> GRANT CREATE ANY SYNONYM TO KWC_USER; SQL> GRANT EXECUTE ANY PROCEDURE TO KWC_USER; 4. SQL> CONNECT 5. Install.sql SQL><KeyWebCreator> INSTALL.SQL 6. SQL*Plus SQL*Plus KeyWeb Creator Web KWC_USER GRANT 20 KeyWeb Creator R3.0

Portal Oracle9iAS Portal 1. SQL*Plus 2. 3. ORACLE_HOME portal30 admin plsql wwc provsyns.sql SQL>@provsyns 4. SQL*Plus KeyWeb Creator 21

Oracle WebCache Oracle9iAS WebCache Oracle9iAS WebCache Oracle9i Application Server Enterprise Edition http://9ias_node:4000/webcacheadmin / administrator/administrator 1. Application Web Servers Oracle HTTP Server Cacheablity Rules Cache select 1Insert above... URL Expression WebCache URL DAD kwc order Cache ^/pls/kwc/order.*$ Cache Submit WebCache Listen Ports WebCache 1100 2. Apply Chan 3. WebCache WebCache Start Operations Oracle WebCache 22 KeyWeb Creator R3.0

KeyWeb Creator R3.0 KeyWeb Creator R3.0 23

KeyWeb Creator R3.0 KeyWeb Creator PL/SQL 1. KeyWeb Creator F 24 KeyWeb Creator R3.0

2. F 3. KeyWeb Creator R3.0 25

4. 26 KeyWeb Creator R3.0

5. 300 KeyWeb Creator R3.0 27

6. 7. SQL 28 KeyWeb Creator R3.0

8. SQL SQL SQL 1 SELECT KeyWeb Creator R3.0 29

9. 10. 30 KeyWeb Creator R3.0

11. 1 2 KeyWeb Creator R3.0 31

12. 32 KeyWeb Creator R3.0

13. KeyWeb Creator DAD DatabaseAccessDescriptor DAD Oracle Portal KeyWeb Creator R3.0 33

WebCache KeyWeb Creator R3.0 WebCache KeyWeb Creator R3.0 PL/SQL WebCache 1. KeyWeb Creator F KeyWeb Creator 2. WebCache WebCache WebCache Oracle9iAS 34 KeyWeb Creator R3.0

3. KeyWeb Creator R3.0 35

4. WebCache WebCache 5. T WebCache 36 KeyWeb Creator R3.0

Web KeyWeb Creator R3.0 Web KeyWeb Creator Web Web 1. Web Web Web KeyWeb Creator R3.0 37

2. Web 38 KeyWeb Creator R3.0

39

Not Found DAD DAD 40 KeyWeb Creator R3.0

ORA-12899 JA16SJIS Web ORA-12899 KeyWebCreator JA16SJIS KeyWebCreator Web JA16SJIS 15 30 JA16EUC 15 30 15 AL32UTF8 10 30 10 41

A KWCSYS_DIC_WSP KWCSYS_DIC_PVD KWCSYS_DIC_COM KWCSYS_DIC_ARG KWCSYS_DIC_LNK KWCSYS_DIC_INL KWCSYS_DIC_FRM KWCSYS_DIC_HTM KWCSYS_DIC_LCK KWCSYS_DIC_RUR KWCSYS_DIC_RIN KWCSYS_DIC_CAL KWCSYS_DIC_SCR KWCSYS_DIC_WCC KWCSYS_DIC_TNM KWCSYS_DIC_PTI KWCSYS_DIC_PTH KWCSYS_DIC_PTF KWCSYS_DIC_PTC KWCSYS_DIC_OBJ HTML URL CALL WebCache WebCache KWCSYS_DIC_PRC KWCSYS_DIC_PKG KWCSYS_TRG_WSP KWCSYS_TRG_PVD Web KWCSYS_API KWC 42 KeyWeb Creator R3.0

UQ_WCC UQ_SCR UQ_RURL UQ_RINL UQ_RTI UQ_PTH UQ_LNK UQ_LCK UQ_INL UQ_HTM UQ_FRM UQ_COM UQ_CAL UQ_ARG PK_WSP PK_PVD PK_OBJ WebCache URL HTML CALL A 43

B 1. PL/SQL 2. WWW 3. WWW 4. URL 44 KeyWeb Creator R3.0