new_logo.eps

Transcription

1 Oracle Application Server : J

2 Oracle Application Server : J Oracle Application Server Administration Guide, Release A Sheryl Maring Contributing Authors: Tom Van Raalte, Dave Stahler, Sanjay Singh, Janice Nygard, Pooja Sharma, Betsy Mooney Charlie Shapiro, Jun Wang, Seshu Adunuthula, Eric Deslauriers, Scott Christly, Ramani Jagadeba, Loc Nhan, Sajjad Rahman Copyright 1999, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Legend Restricted Rights Legend Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication and disclosure of the Programs shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication and disclosure of the Programs shall be subject to the restrictions in FAR , Rights in Data -- General, including Alternate III (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA

3 ... xi Oracle Application Server Oracle Application Server Welcome Welcome Oracle Application Server Manager (OAS Manager) Node Manager Oracle Application Server Oracle Application Server OAS Log Analyzer Web Oracle Application Server OAS Manager Node Manager Administration Utility iii

4 Oracle Application Server Manager Web Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server HTTP IP Oracle Application Server HTTP HTTP HTTP / MIME SSL CA HTTP Netscape Server OAS Netscape Server Netscape Server iv

5 Microsoft Internet Information Server NT IIS IIS Apache UNIX Apache Apache OAS Apache Apache Apache JCO Object Request Broker Object Request Broker (ORB) ORB ORB ORB Database Access Descriptor (DAD) DAD DAD DAD ORACLE_SID DAD DAD DAD v

6 IIOP HTTP CORBA/IIOP ECO/Java EJB Web Java vi

7 CORBA C eb C++ CORBA JServlet JWeb LiveHTML Perl PL/SQL CORBA C JWeb LiveHTML ODBC Perl PL/SQL ECO/Java EJB CORBA vii

8 / XLF : Logger : PL/SQL Toolkit : Log Analyzer : : DAD Log Analyzer viii

9 Object Transaction Service DAD/ Distributed Transaction Coordinator HO OTS OTS OTS Oracle Application Server A owsctl... A-2... A-3 version... A-3 start... A-3 stop... A-5 status... A-8 reload... A-11 dump... A-12 monitor... A-14 getior... A-16 WRB ORB... A A-18 owsstat... A A A A-20 ix

10 ... A A-21 oasnetconf... A A A-23 oaspasswd... A A A-25 oaspasswd... A A-26 oasmcastcfg... A A A A-28 B Windows NT... B-1 UNIX... B-2 x

11 Oracle Application Server HTTP Oracle Application Server Oracle Application Server Oracle Application Server J Oracle Application Server for Sun SPARC Solaris J Oracle Application Server for Windows NT J Oracle Application Server for Sun SPARC Solaris J Oracle Application Server for Windows NT J Oracle Application Server J Oracle Application Server J Oracle Application Server J Oracle Application Server PL/SQL ODBC J Oracle Application Server JServlet J Oracle Application Server LiveHTML Perl J Oracle Application Server EJB ECO/Java CORBA J xi

12 Oracle Application Server C++CORBA J Oracle Application Server PL/SQL Web Toolkit J Oracle Application Server PL/SQL Web Toolkit J Oracle Application Server JServlet Toolkit J Oracle Application Server JServlet Toolkit J Oracle Application Server J Oracle Application Server J oas.h owsctl wrbcfg URL file1 <filename> owsctl start wrb [-c string] [on off] ( ) 1 {yes no} ( ) n,... xii

13 1 Oracle Application Server Oracle Application Server Manager Oracle Application Server Oracle Application Server Oracle Application Server Welcome Oracle Application Server Manager (OAS Manager) Oracle Application Server OAS Web Web Request Broker (WRB) Web Request Broker Oracle Application Server Web : : Object Request Broker (ORB): : : 1 1-1

14 1-1 Oracle Application Server Web OAS Node Manager Admin HTTP OAS HTTP Oracle Application Server Oracle Application Server Oracle Application Server 1-2 miranda Web 1-1 Oracle Application Server Node Manager 8888 Admin 8889 www 80 HelloCart JServlet Hello World Java hello.class 1-2 Oracle Application Server

15 Oracle Application Server 1-2 : miranda 1 Node Mgr (8888) Admin (8889) OAS 3 HelloWorld 4 www (80) 2 HelloCart 5 hello.class www 2. HelloWorld HelloCart HelloCart 3. OAS HelloWorld HelloCart HelloCart JServlet Java 4. HelloCart HelloWorld 5. HelloCart hello.class Oracle Application Server Oracle Application Server Web 1. Web 2 2. HTTP 3 HTTP 3. Object Request Broker 1-3

16 Oracle Application Server Welcome Object Request Broker 5 Object Request Broker Web Web 10 Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server Welcome Oracle Application Server WelcomeNode Manager Oracle Application Server Welcome OAS ManagerOAS Oracle Application Server

17 Oracle Application Server Welcome 1-3 Oracle Application Server Welcome OAS Manager Web OAS Manager Web Request Broker (WRB) Oracle Application Server OAS Manager OAS Log Analyzer Welcome Oracle Application Server Welcome 1. Web URL Welcome hostname.domain port Node Manager

18 Oracle Application Server Manager (OAS Manager) : Oracle Application Server Welcome Node Manager Node Manager 2-3 Node Manager 2. Node Manager admin Oracle Application Server Manager Welcome Oracle Application Server Manager (OAS Manager) Oracle Application Server Manager Web Oracle Application Server Web Web 1-4 Oracle Application Server Manager Web 1-6 Oracle Application Server

19 Oracle Application Server Manager (OAS Manager) Node Manager Node Manager 1-2 Oracle Application Server Site Manager Oracle Application Server HTTP 1-2 Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server Web 1-7

20 Oracle Application Server OAS Oracle Application Server Oracle Application Server Oracle Application Server [Shift] Web HTTP Oracle Application Server OAS OAS Web 1-5 Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server

21 Oracle Application Server OAS / / Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server WRB Oracle Application Server Oracle Application Server Log Analyzer Log Analyzer Log Analyzer 10 PL/SQL

22 Oracle Application Server OAS 1-10 Oracle Application Server

23 2 Web Oracle Application Server Web Oracle Application Server OAS Manager Oracle Application Server Manager Web Oracle Application Server Oracle Application Server Oracle Application Server Web Oracle Application Server Oracle Application Server Manager Oracle Application Server Oracle Application Server Web website 40 Site Manager Site Manager Web 2-1

24 Web Oracle Application Server 2-1 Site Manager Web Web Oracle Application Server 2-2 Oracle Application Server Oracle Application Server 2-9 Oracle Application Server 2-2 Oracle Application Server

25 OAS Manager OAS Manager Oracle Application Server Manager 2 Node Manager Administration Utility Administration Utility Web Node Manager : Oracle Application Server 3 HTTP 3 HTTP Node Manager Node Manager Web Node Manager Node Manager % owsctl status -nodemgr Node Manager Node Manager % owsctl start -nodemgr Node Manager % owsctl stop -nodemgr Oracle Application Server 3 HTTP owsctl A 2-3

26 OAS Manager Administration Utility Administration Utility Oracle Application Server Manager Log Analyzer Oracle Application Server Administration Utility Node Manager Administration Utility Oracle Application Server Administration Utility Oracle Application Server Administration Utility Administration Utility 1. OAS Manager 2. HTTP 2-3 HTTP 3. hostname:adminadministration Utility Administration Utility HTTP 2-4 Oracle Application Server

27 Oracle Application Server Manager Administration Utility Administration Utility 1. Node Manager Web HTTP 2. hostname:admin Admin Utility 3. admin Oracle Application Server Manager Site Manager 2-5Web Site Manager 1. Oracle Application Server Manager Welcome 1-5 Welcome 2. Oracle Application Server Manager OAS Manager Oracle Application Server OAS 3. OAS Manager Web OAS Manager 2-4 : [Shift] 2-5

28 Web 2-4 OAS Manager Web Web Web Request Broker (WRB) 2 WRB WRB Site Manager WRB Oracle Application Server 2-6 Oracle Application Server

29 . Web 2-5 Site Manager Site Manager WRB Object Request Broker (ORB) Oracle Application Server 1. Oracle Application Server Manager Web

30 Web 2-6 Web miranda.us.oracle.com miranda : DNS us.oracle.com Node Manager Node Manager TCP/IP Node Manage ID Node Manager Node Manager Node Manage 2-8 Oracle Application Server

31 Oracle Application Server Oracle Application Server : HTTP HTTP WRB : WRB Log Analyzer RM : Oracle Application Server Oracle Application Server WRB Oracle Application Server Oracle Application Server oassrv Logger Oracle Application Server Oracle Application Server Oracle Application Server Web 1 Web Request Broker (WRB) Oracle Application Server Oracle Application Server 2-7 WRB WRB 1. Web 2. Oracle Application Server Oracle Application Server 2-9

32 Oracle Application Server 2-7 Oracle Application Server Oracle Application Server WRB ID wrblog miranda ID 2342: ID 1 ID wrbmon wrbmon wrbmon oassrv oassrv 2-10 Oracle Application Server

33 Oracle Application Server Oracle Application Server Oracle Application Server 1. Node Manager Web Oracle Application Server 2. Oracle Application Server 3. Oracle Application Server 4. Oracle Application Server Oracle Application Server Oracle Application Server Oracle Application Server : Oracle Application Server 2-11

34 Oracle Application Server 2-8 Oracle Application Server SID CPU ID ID : 1/100 : KB : wrbmon Oracle Application Server Manager oassrv Oracle Application Server 2-7 oassrv 2-12 Oracle Application Server

35 Oracle Application Server :[[ ] : : ] Oracle Application Server Oracle Application Server Manager 1. Oracle Application Server Web Oracle Application Server 2-13

36 Oracle Application Server 2-14 Oracle Application Server

37 3 HTTP HTTP HTTP HTTP CGI HTTP HTTP 1 HTTP HTTP 1 IP / / 1 / Oracle Application Server HTTP 3-1

38 3-8 IP 1 IP 1 IP IP 2 Address Port Security Host Name Base Dir Log Info Authen NORM /scripts/ /tmp/mylogs/ NONE NORM /sample/a/ /tmp/mylogs/ NONE NORM /scripts/ /tmp/mylogs/ NONE NORM foo.xyz.com /sample/a/ /tmp/mylogs/ NONE NORM /scripts/ /tmp/mylogs/ NONE NORM /sample/a/ /tmp/mylogs/ NONE Oracle Application Server Oracle Application Server 1 1 Oracle Application Server Oracle Application Server

39 HTTP HTTP HTTP 3-1 HTTP HTTP HTTP 1. WelcomeOAS Manager 2. website40 3. HTTP HTTP 3-1 HTTP HTTP / 5555/ Netscape Enterprise 5555 Netscape Enterprise apcnmsun.au.oracle.com HTTP 3-3

40 HTTP ID ID 2342: ID 1 ID HTTP HTTP HTTP : Oracle Application Server 3-2 HTTP SID ID ID 3-4 Oracle Application Server

41 CPU : 1/100 : KB :[[ ] : : ] HTTP Oracle Application Server Manager 1. HTTP Web HTTP Web HTTP 3-1 HTTP 3-3 HTTP 3-5

42 3-3 HTTP HTTP 6 HTTP TCP/IP HTTP ID ID HTTP HTTP Oracle Application Server 3-6 Oracle Application Server

43 miranda.us.oracle.com miranda.us.oracle.com URL HTTP URL "/" /private/oracle/ows/4.0/doc/ ID UNIX HTTP ID ID ID 0 root 3-15 / ID UNIX HTTP ID ID 3-15 / HTTP 3-1 URL 1. website40 2. HTTP 3. < > HTTP 3-7

44 / MIME SSL CA 3-5 HTTP ID HTTP 3-5 Oracle Application Server HTTP HTTP Oracle Application Server

45 3-1 HTTP Windows NT UNIX DNS IP DNS ALWAYS : IP DNS LAZY : Application Development Interface ADI DNS IP DNS LAZY_WITH_CGI : CGI DNS IP DNS NEVER : DNS DNS ALWAYS HTTP DNS Oracle Application Server DNS DNS NEVER DNS LAZY_WITH_CGI URL HTTP URL URL HTTP HTTP URL Oracle Application Server HTTP 3-9

46 : HTTP HTTP PID UNIX HTTP ID PID : HTTP PID HTTP HTTP HTTP HTTP TCP/IP 3-1 HTTP ID IP IP IP 0( ) ANY HTTP IP HTTP TCP/IP HTTP NORM : Secure-Sockets Sockets Layer SSL SSL : SSL 2.0 SSL 3.0 SSLV2 Hello SSL 3.0 SSL 3.0 SSL 2.0 SSL_V2 : SSL 2.0 SSL Oracle Application Server

47 SSL_V2 : SSL 3.0 SSL3 SSL_V3_V2H : SSL 3.0 SSL 2.0 SSLV2 Hello SSL 3.0 SSL3.0 HTTP DNS 3-2 IP DNS IP Oracle Application Server URL /public_html URL : / Web Oracle Application Server SSL NONE : OPT : HTTP 3-11

48 REQ : SSL * * CA SSL 3.0 Oracle Application Server SSL NORM 3-6 HTTP Oracle Application Server

49 URL wwwindex.html index.html URL UNIX URL /public_html URL CGI HTTP URL HTTP : / MIME MIME Multipurpose Internet Mail Extensions (MIME) application/octet-stream HTTP MIME MIME RFC RFC 1521 iso RFC 1766 ID "en" HTTP HTTP HTTP 3-13

50 map URL HTTP FALSE URL URL FALSE TRUE FALSE Windows NT HTTP ON : OFF : Oracle Application Server OFF Windows NT CGI Oracle HTTP CGI WinCGI CGI WinCGI Oracle Application Server Oracle HTTP 10 : 3-14 Oracle Application Server

51 0 0 Oracle Application Server / UNIX / 3-7 HTTP ID ID ID ID ID UNIX HTTP HTTP ID ID ID ID ID HTTP HTTP Oracle Application Server HTTP root oracle ID dba ID HTTP nobody ID HTTP 3-15

52 3-7 / ID HTTP HTTP ID ID ID 0 root ID HTTP HTTP ID ID 3-8 URL Oracle Application Server

53 HTTP HTTP HTTP 404: Not found UNIX NT /private1/oracle/app/oracle/product/7.3.2/ows/4.0/ bin/ CGI N CGI : CGI C CGI: CGI S : Java Servlets W (WinCGI) : Windows NT WinCGI 2 R: N : "/" /oas/oas-bin/ Windows NT Windows NT 1. HTTP 3-17

54 2. HTTP 3. OK > > > OK Oracle Application Server

55 3-9 MIME image.en.jpg image.uc.jpg RFC 1766 en ID RFC 1521 iso eng / MIME 3-10 HTTP Multipurpose Internet Mail Extension MIME HTTP 3-19

56 3-10 MIME MIME RFC text/html MIME htm html MIME / MIME 8 UNIX / Windows NT / Oracle Application Server

57 3-11 SSL CA compress gzip Z gz CA Web Oracle Application Server SSL CA HTTP 3-21

58 3-12 CA SSL : Trusted Untrusted Trusted CA CA Untrusted CA CA Update CloseDo Not Trust Add CA : Oracle Application Server

59 3. 2 Base64 Delete Oracle Application Server HTTP HTTP /support/news: 1 /support/partners/: /support/crypt*: /support/ crypt HTTP 3-23

60 Windows NT : (/) ( ) R W D GET HEAD POST PUT DELETE / /Crypt Crypto SSl 1 &/ '&' HTTP ' ' 2 IP IP 1 Oracle Application Server 3-24 Oracle Application Server

61 Oracle HTTP Oracle Application Server Netscape FastTrack Netscape Enterprise Server Microsoft Internet Information Server (for NT) Apache (UNIX ) 4 HTTP HTTP 3-25

62 3-26 Oracle Application Server

63 4 HTTP Netscape Server Microsoft Internet Information Server NT Apache UNIX Oracle Application Server HTTP Oracle Application Server Oracle Web Listener HTTP Oracle Application Server Oracle Application Server Netscape FastTrack Netscape Enterprise Server Apache Microsoft Internet Information Server(IIS) Oracle Application Server Oracle Application Server HTTP 4-1

64 Netscape Server Netscape Server Oracle Installer Netscape FastTrack Server Enterprise Server 1 Netscape Server obj.conf.sav Netscape FastTrack Server Enterprise Server obj.conf OAS Netscape Server 1. Oracle Application Server Welcome port OAS 3. >> Netscape 4-1 Netscape 4. Netscape 5. Netscape 4-2 Oracle Application Server

65 Netscape Server Netscape Server Admin Netscape Server Netscape Server 1. OAS Manager 2. Web HTTP Netscape Netscape Netscape Server obj.conf %NS_HOME% httpd-server config (FastTrack Server) %NS_HOME% https-server config (Enterprise) Oracle Web Request Broker filename.sav Netscape Server init WRB obj.conf magnus.conf Netscape FastTrack Init fn=load-modules shlib=%oraweb_home% lib [ndwfn21040.dll (.so for UNIX) ndwfn3040.dll (.so for UNIX)] funcs="oracle-adp-init,oracle-adp-auth-trans, oracle-adp-service,oracle-adp-addlog,oracle-adp-error, oracle-adp-name-trans,oracle-adp-path-check,oracle-adp- object-type" Init fn=oracle-adp-init HTTP 4-3

66 Netscape Server serverconf="%ns-home% httpd-[server] config obj.conf" servererrfile="%ns-home% httpd-[server] logs errors" ORACLE_HOME="%ORACLE_HOME%" ORAWEB_HOME="%ORAWEB_HOME%" mimetypesfiles="%ns-home% httpd-[server] config mime.types" Netscape Enterprise Init fn=load-modules shlib=%oraweb_home% lib [ndwfn21040.dll (.so for UNIX) ndwfn3040.dll (.so for UNIX)] funcs="oracle-adp-init,oracle-adp-auth-trans, oracle-adp-service,oracle-adp-addlog,oracle-adp-error, oracle-adp-name-trans,oracle-adp-path-check,oracle-adp- object-type" Init fn=oracle-adp-init serverconf="%ns-home% https-[server] config obj.conf" servererrfile="%ns-home% https-[server] logs errors" ORACLE_HOME="%ORACLE_HOME%" ORAWEB_HOME="%ORAWEB_HOME%" mimetypesfiles="%ns-home% https-[server] config mime.types" : ndwfn21040.dll UNIX.so Oracle Application Server 4.0 FastTrack/Enterprise ndwfn3040.dll UNIX.so Oracle Application Server 4.0 FastTrack/Enterprise 3.0 Oracle Application Server Netscape Server obj.conf NameTrans fn=pfx2dir from= ows-bin dir="%oraweb_home% bin" name="cgi" NameTrans fn=pfx2dir from= ows-doc dir="%oraweb_home% doc" NameTrans fn=pfx2dir from= ows-img dir="%oraweb_home% img" NameTrans fn=pfx2dir from= tr-img dir="%oraweb_home% demo img" NameTrans fn=pfx2dir from= sample bin dir="%oraweb_home% sample bin"name="cgi" NameTrans fn=pfx2dir from= sample dir="%oraweb_home% sample" NameTrans fn=pfx2dir from= oracle dir="%oraweb_home% doc" 4-4 Oracle Application Server

67 Microsoft Internet Information Server NT obj.conf NameTrans fn="oracle-adp-name-trans" AuthTrans fn="oracle-adp-auth-trans" PathCheck fn="oracle-adp-path-check" ObjectType fn="oracle-adp-object-type" Service fn="oracle-adp-service" AddLog fn="oracle-adp-addlog" text/plain Oracle Application Server Java WRB HTML ## ##ObjectType fn=force-type type=text/plain Microsoft Internet Information Server NT Oracle Application Server IIS 3.0 IIS 4.0 IIS 3.0 Oracle Application Server Oracle Application Server IIS 4.0 Oracle Application Server Oracle Application Server OAS Manager IIS 4.0 Microsoft Management Console IIS IIS 3.0 IIS 4.0 IIS Oracle Application Server Welcome port OAS 3. >> Microsoft HTTP 4-5

68 Microsoft Internet Information Server NT 4-2 MIIS 4. Oracle Application Server Microsoft 5. OK IIS IIS 3.0 IIS 1. OAS Manager 2. Web HTTP 3. IIS IIS Microsoft IIS 4.0 ISAPI 2 In-Process Out-of-Process Oracle Application Server In-Process 4-6 Oracle Application Server

69 Microsoft Internet Information Server NT In-Process.dll IIS IIS 4.0 Oracle Application Server Microsoft Management Console ISAPI 1. Microsoft Management Console IIS Properties 4-3 IIS Management Console 2. ISAPI FiltersAdd 4-4 ISAPI Oracle Application Server ISAPI.dll Filter Name : Executable :%ORAWEB_HOME% bin libndwfis40.dll %ORAWEB_HOME% Oracle Application Server 4.0 c: orant ows 4.0 HTTP 4-7

70 Microsoft Internet Information Server NT 3. OK Apply 4. ISAPI Microsoft Management Console Oracle Application Server Web "Default Web Site" New > Virtual Directory 4-5 New Virtual Directory Wizard 5. "ows" 4-8 Oracle Application Server

71 Microsoft Internet Information Server NT %ORAWEB_HOME% bin c: orant ows 4.0 bin Allow Execute Access Finish HTTP 4-9

72 Microsoft Internet Information Server NT Run in separate memory space : IIS 4.0 lazy Oracle Application Server IIS 4.0 Oracle Application Server IIS 4.0 IIS 4.0 OAS Node Manager Oracle Application Server Microsoft Management Console IIS 4.0 Oracle Application Server / DAD Node Manager Oracle Application Server IIS Oracle Application Server

73 Microsoft Internet Information Server NT : WRB Microsoft Management Console IIS 4.0 WRB Microsoft Management Console IS 4.0 IIS 4.0 WRB IIS 4.0 net stop iisadmin /y world wide web publishing service WRB IIS NT IIS NT NT.dll Oracle Application Server NT HTML CGI ASP Oracle Application Server : IIS Oracle Application Server.dll NT Oracle Application Server IIS Oracle Application Server IIS NT IIS "ows" Oracle Application Server HTTP 4-11

74 Apache UNIX OAS_IIS_AUTH_ENABLED TRUE 2 System Environment HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE> OAS40 Oracle Application Server IIS OAS_IIS_AUTH_ENABLED FALSE Oracle Application Server Apache UNIX Apache Oracle Application Server Apache HTTP Apache 4-9 Apache Apache L1 L2 L3 L4 CORBA D1 D2 Apache HTTP (L1, L2,...) Apache 4-12 Oracle Application Server

75 Apache UNIX Apache libapadp.so: Apache HTTP ndwfapd.so: ows_module 1. mod_so Apache httpd.conf LoadModule ows_module ndwfapd.so 3. OAS Apache OAS Apache 1. Oracle Application Server Welcome port OAS 3. >>Apache HTTP 4-13

76 Apache UNIX 4-10 Apache Oracle Application Server

77 Apache UNIX Apache Apache : bin httpd /private/home/apache/bin/httpd : conf httpd.conf /private/home/apache/conf/httpd.conf 6. Apache : Apache 60 APACHE_MASTER_DISP_TIMEOUT Apache 1. OAS Manager HTTP 4-15

78 Apache UNIX 2. Web HTTP Apache Apache Apache 4-1 Apache MaxRequestsPerChild MinSpareServers 5 MaxSpareServers 50 MaxClients 100 Apache JCO Apache JCO $ORAWEB_HOME/bin /ows-bin/ Apache 4-16 Oracle Application Server

79 5 Object Request Broker Oracle ORB Object Request Broker (ORB) ORB ORB Object Request Broker (ORB) Oracle ORB Object Request Broker (ORB) ORB Object Request Broker 5-1

80 ORB 5-1 ORB / Object Request Broker (ORB) ORB Oracle ORB CORBA IIOP 1 ORB ORB Oracle Application Server Manager ORB : ORB 1. Oracle Application Server ORB 5-2 Oracle Application Server

81 ORB 5-2 ORB 2. ORB ORB : ORB TCP ORB 5512 ORB TCP UNIX super-user root 1023 : IIOP/SSL IIOP/IP ORB ORB : ORB SSL IIOP + IP ACL : IIOP/IP IP IP ORB IIOP/SSL + ACL : SSL SSL ORB Wallet Wallet Oracle Wallet Manager Wallet ORB 3. ORB Object Request Broker 5-3

82 ORB ORB ORB Oracle ORB ORB Oracle Application Server Manager ORB ORB 1. Oracle Application Server website Oracle Application Server Manager 3. Oracle Application Server Oracle Application Server 4. ORB Server orb 5-4 Oracle Application Server

83 6 Database Access Descriptor (DAD) Database Access Descriptor(DAD) DAD DAD DAD DAD Database Access Descriptor(DAD) Oracle Application Server Oracle DAD DAD DAD SQL*Net V2 Net8 DAD DAD DAD DAD Database Access Descriptor (DAD) 6-1

84 DAD : PL/SQL DAD Oracle Application Server PL/SQL ODBC PL/SQL DAD : tnsnames.ora SID DAD 1. DAD Oracle Application Server ORACLE_HOME (NT) %ORACLE_HOME% net80 admin tnsnames.ora (UNIX) $ORACLE_HOME/network/admin/tnsnames.ora ORACLE_HOME Oracle Application Server ORACLE_HOME 6-1 tnsnames.ora demo 6-1 tnsnames.ora # Installation Generated Net8 Configuration # Version Date: Nov # Filename: Tnsnames.ora demo = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = db_machine)(port= 1521)) (CONNECT_DATA = (SID = orcl)) ) demo 6-2 Oracle Application Server

85 DAD TCP db_machine 1521 orcl 2. UNIX tnsnames.ora TNS_ADMIN echo $TNS_ADMIN 3. $ORACLE_HOME/bin/tnsping ORACLE_HOME Oracle Application Server ORACLE_HOME tnsping demo TNS Ping Utility for Solaris: Version Production on 14-APR-99 11:10:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP) (Host=db_machine)(Port=1521)) OK (20 msec) 4. WelcomeOAS Manager 5. website40 6. Oracle Application Server 7. DB Access Descriptor 8. DAD: Database Access Descriptor (DAD) 6-3

86 DAD 6-1 Database Access Descriptor (DAD) : DAD DAD DAD: DAD DAD DAD / "_" 6-4 Oracle Application Server

87 DAD DAD ID PL/SQL Toolkit SYS SVRMGR> grant ows_standard_role to <user> SVRMGR> grant all on websys.owa_content to <user> : Oracle Application Server Operating System Authentication (ops$) john-sun ORACLE_SID / ORCL 1 demo Database Access Descriptor (DAD) 6-5

88 DAD DAD DAD PL/SQL Toolkit DAD Database Access Descriptor DAD PL/SQL /DAD 10. DBA 6-2 DBA 11. SYS 6-6 Oracle Application Server

89 DAD ! SID tnsnames.ora TNS_ADMIN Oracle Application Server $ORACLE_HOME/network/ admin tnsnames.ora tnsnames.ora ORACLE_HOME Oracle Application Server ORACLE_HOME : TNS_ADMIN Oracle Application Server 13. OK DAD Database Access Descriptor (DAD) 6-7

90 DAD DAD DAD DAD DAD : Oracle Application Server Enterprise Edition 2 DAD DAD DAD 6-3 DAD OAS ManagementDB Access Descriptor DAD 6-5 DAD: DAD: 6-8 Oracle Application Server

91 DAD DAD 1 1 : 11 DAD : DAD : DAD DAD Oracle 8 : DAD Oracle8.x Oracle 7 : DAD Oracle7.x RM : 600 DTC DTC (Distributed Transaction Coordinator) DAD DAD <SID>.<hostname> Database Access Descriptor (DAD) 6-9

92 DAD OTS RM Oracle7 Object Transaction Service OTSHO Oracle8 Distributed Transaction Coordinator (DTC) Oracle7 RM Oracle7 RM HO HO HO Oracle8 DTC tnsnames.ora 11 DAD NLS DAD : NLS OAS Manager 1. OAS ManagerDB Access Descriptor DAD 6-10 Oracle Application Server

93 DAD 6-5 DAD 2. DAD: Database Access Descriptor (DAD) 6-11

94 DAD 6-6 DAD: NLS NLS NLS SYSTEM Oracle SYSTEM / DAD AMERICAN_AMERICA.US7ASCII TO_CHAR TO_DATE "MM/DD/YYYY" AM PM AD BC 6-12 Oracle Application Server

95 DAD NLS NLS NLS NLS ISO NLS BINARY BINARY ORDER BY L 'L099' L FRANCE C 'C099' C FRANCE NLS_CALENDAR Japanese ImperialYY-MM- DD Database Access Descriptor (DAD) 6-13

96 DAD 6-14 Oracle Application Server

97 7 Oracle Application Server Oracle Application Server HTTP CORBA/IIOP 7-7 Oracle Application Server Web Netscape Navigator Microsoft Internet Explorer Java Java Oracle Application Server IIOP Oracle Application Server 1 7-1

98 Oracle Application Server Manager Oracle Application Server Oracle Application Server A Oracle Application Server 7-1 HTTP Oracle Application Server 7-1 C JServlet JWeb LiveHTML ODBC UNIX DLL (NT) Java HTML Sybase Informix ODBC 7-2 Oracle Application Server

99 7-1 Perl PL/SQL Perl SQL A IIOP Oracle Application Server IIOP CORBA Oracle Application Server ECO/Java Enterprise JavaBeans (EJB) C++ CORBA 7-3

100 ECO/Java EJB Java Java CORBA CORBA ECO/Java EJB Oracle Application Server ECO/Java EJB ECO/Java EJB Oracle Application Server Manager Oracle Application Server ECO/Java EJB Oracle Application Server Manager ECO/Java EJB ECO/Java EJB IIOP ECO/Java EJB 9 ECO/ Java EJB Oracle Application Server Manager ECO/Java EJB 3 ECO/Java EJB Oracle Application Server 1 ECO/Java ECO/Java Java CORBA ECO/Java Java Oracle Application Server ECO/Java ECO/Java 1 ECO/Java 7-4 Oracle Application Server

101 ECO/Java JServlet Java Java Web CORBA CORBA CORBA Java Java ORB ECO/Java ECO/Java Web Web ORB IIOP Oracle Application Server 7-3 Enterprise JavaBeans (EJB) Enterprise JavaBeans (EJB) JavaSoft Enterprise Beans Beans EJB Oracle Application Server EJB Oracle Application Server EJB CORBA Bean CORBA CORBA Bean CORBA Oracle Application Server C++ CORBA C++ CORBA C++ C++ CORBA C++ CORBA C++ CORBA Oracle Application Server C++ C++ 1 C++ C++ C++ 7-5

102 Oracle Application Server 3 ECO/Java/EJB HTTP HTML Oracle Application Server 7-6 Oracle Application Server

103 1 : HTTP API Oracle Application Server Enterprise Edition API 11 : Oracle Application Server Web HTTP CORBA CORBA/IIOP ORB 7-7

104 HTTP 7-2 Web HTTP HTTP HTTP Oracle Application Server CORBA/IIOP 7-3 Java ECO/Java CORBA/IIOP RM CORBA EJB ECO/Java RM EJB EJB CORBA/IIOP Oracle Application Server ECO/Java EJB 7-8 Oracle Application Server

105 7-3 CORBA/IIOP Java IIOP IIOP ECO/EJB 4. RM 7-9

106 7-10 Oracle Application Server

107 8 Oracle Application Server Manager Oracle Application Server Manager 2 ECO/Java EJB Oracle Application Server Manager Web Oracle Application Server Manager 2 8-1

108 8-1 PL/SQL PL/SQL 8-1 PL/SQL Oracle Application Server Manager 8-1 Web Oracle Application Server Oracle Application Server 8-1 DB Browser Log Analyzer 2 DB Utilities 8-2 Oracle Application Server

109 Oracle Application Server 1 PL/SQL Perl 9 ECO/Java EJB Oracle Application Server Manager ECO/Java EJB ECO/Java 8-2 ECO/Java 8-3

110 Oracle Application Server Manager 8-1 Web Oracle Application Server ECO/Java EJB ECO/Java EJB ECO/Java EJB 9 ECO/Java EJB ECO/Java EJB ECO/Java EJB ECO/Java EJB ECO/ Java EJB Oracle Application Server

111 8-1 MIME MIME Web Web Web Web Web Web Web Web Web Web Tx jpeg gif 15 Database Access Descriptor DAD Tx 6 Database Access Descriptor (DAD) DAD : ECO/Java EJB 9 8-5

112 Web HTTP Oracle Apprication Server Database Access Descriptor Database Access Descriptor (DAD) 6 Database Access Descriptor (DAD) : C++ CORBA PL/SQL JServlet JWeb LiveHTML Perl CWeb DAD Java LiveHTML Perl CWeb 8-6 Oracle Application Server

113 ECO/Java EJB CORBA EJB ECO/Java ECO/Java EJB ORB Oracle Application Server ORB ORB ORB ORB 5 Object Request Broker 11 Oracle Application Server 10 1 ECO/Java EJB Java OAS Java Java 1 Oracle Application Server Oracle Application Server Manager 9 1 Oracle Application Server Oracle Application Server

114 Oracle Application Server Manager Web Oracle Application Server Manager 1 Welcome 2. "+" website40 Oracle Application Server HTTP : : 8-13 : EJB ECO/Java 8-8 Oracle Application Server

115 C++ CORBA CWeb Enterprise JavaBeans ECO/Java JServlet JWeb LiveHTML Perl PL/SQL C++ CORBA EJB ECO/Java EJB ECO/Java 8-4 CWeb JServlet JWeb LiveHTML Perl PL/SQL C++ CORBA ECO/Java EJB 8-9

116 8-4 3 Oracle Application Server Manager OK 2 OK 9 60 Oracle Application Server Manager 1.0 EJB ECO/Java 8-5 EJB ECO/Java 8-10 Oracle Application Server

117 JAR EJB JAR ECO/Java EJB JAR JAR JAR : JAR 60 ECO/Java EJB

118 JAR JAR JAR JAR JAR Oracle Application Server Manager C++ CORBA C++ CORBA C++ CORBA C++ CORBA C++ CORBA.so (UNIX).dll (NT) 8-12 Oracle Application Server

119 JAR 8-7.app <application>.app Oracle Application Server 8-7 <application>.app $ORACLE_HOME/ows/cartx/ plsql/install/myapplication.app <application>.app Oracle Application Server Oracle Application Server

120 $ORACLE_HOME/../cartx/livehtml/samples $ORACLE_HOME/../cartx/livehtml/samples : ECO/Java EJB C++ CORBA ECO/Java EJB 2 PL/SQL Java ECO/Java / 8-14 Oracle Application Server

121 Oracle Application Server wrb.app C.so.dll ECO/Java EJB JServlet JWeb LiveHTML LiveHTML Perl ECO/Java EJB Java Java LiveHTML LiveHTML Perl Perl Perl ECO/Java EJB PL/SQL : Oracle Application Server Manager Oracle Application Server 8-4 Oracle Application Server 8-15

122 Manager Oracle Application Server Manager 8-4 Oracle Application Server Oracle Application Server 8-31 : Oracle Application Server 8-4 (RM) RM RM RM RM RM 8-16 Oracle Application Server

123 8-4 RM RM RM Oracle Application Server Manager Oracle Application Server Manager Web Java :

124 8-8 / Oracle Application Server Oracle Application Server

125 ECO/Java EJB 8-10 ECO/Java EJB Oracle Application Server / 8-19

126 is-system31 Oracle Application Server / / Oracle Application Server 1 9 Oracle Application Server Oracle Application Server Oracle Application Server 5 Oracle Application Server 8-11 Logger Logger Oracle Application Server

127 8-11 %ORAWEB_ADMIN%/website40/log /private/oas/logs/ wrb.log %ORAWEB_ADMIN%/website40/log Logger 3 Logger

128 Web 8-12 Web Web HTTP ECO/Java EJB HTTP Web MIME + + html, txt - -jpeg, gif URL SSL SSL SSL 8-22 Oracle Application Server

129 Oracle Application Server True Oracle Application Server JServlet Oracle Application Server JServlet 4 JServlet 15 HTML Oracle Application Server $ORAWEB_HOME/admin/doc/wrberr.html 8-23

130 PL/SQL JServlet EJB ECO/Java C++ CORBA LiveHTML JCORBA CWeb JWeb Java 8-24 Oracle Application Server

131 LD_LIBRARY_PATH (UNIX ) 8-6 Java CLASSPATH PATH JAR %ORAWEB_HOME%/classes/ ejbapi.jar CLASSPATH JAR UNIX CLASSPATH JAR first.jar:second.jarwindows NT CLASSPATH JAR first.jar;second.jar UNIX NT %ORAWEB_HOME% jdk bin 8-25

132 8-6 Java JAVA_HOME THREADS_FLAG Java %ORAWEB_HOME% jdk (UNIX )Java "native" Java 8-14 Java Java Java Java 8-14 Java Oracle Application Server Manager 8-26 Oracle Application Server

133 "+" JAR EJB

134 8-7 Web CORBA wrks -s JAR JAR JAR JAR.app MyApplication/MyCartridge Oracle Application Server

135 : SID CPU ID ID : 1/100 : KB 8-9 :[[ ] : : ] 8-29

136 Oracle Application Server 1. "+" Oracle Application Server Oracle Application Server Oracle Application Server 1. Oracle Application Server Manager Oracle Application Server Oracle Application Server Oracle Application Server Manager Oracle Application Server

137 Oracle Application Server Manager Oracle Application Server Manager Oracle Application Server 8-31

138 Oracle Application Server 1. website Oracle Application Server Oracle Application Server : Oracle Application Server HTTP 8-31 Oracle Application Server 1. Oracle Application Server Oracle Application Server Manager Application Server Manager Oracle Application Server

139 HTTP

140 8-34 Oracle Application Server

141 9 Oracle Application Server Manager CORBA CORBA ECO/Java EJB CORBA Oracle Application Server 9-1 Oracle Application Server 9-1

142 . 9-1 C C++ Enterprise JavaBeans (EJB) ECO/Java JServlet JWeb LiveHTML ODBC Perl PL/SQL UNIX DLL(NT) CORBA Enterprise JavaBeans CORBA Java Java HTTML Sybase Informix ODBC Perl CORBA PL/SQL Oracle PL/SQL Oracle Perl Perl Perl CORBA Java ECO/Java EJB CORBA IIOP Oracle Application Server CORBA Oracle Application Server Manager CORBA Oracle Application Server EJB ECO/Java CORBA Oracle Application Server C++ CORBA 9-2 Oracle Application Server

143 Web HTTP Oracle Apprication Server Database Access Descriptor Database Access Descriptor (DAD) 6 Database Access Descriptor (DAD) CORBA a. PL/SQL JServlet JWeb LiveHTML Perl CWeb PL/SQL JServlet JWeb LiveHTML Perl CWeb DAD Java LiveHTML Perl CWeb b. ECO/Java EJB * * 9-3

144 EJB ECO/Java 9-29 ECO/Java EJB ORB Oracle Application Server ORB ORB ORB ORB 5 Object Request Broker 11 Oracle Application Server 10 1 Oracle Application Server Oracle Application Server Manager : Oracle Application Server

145 Oracle Application Server Manager Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" <cartridge>.app.app <cartridge>.app Oracle Application Server 9-5

146 CWeb C++ CORBA Enterprise JavaBeans ECO/Java JServlet JWeb LiveHTML Perl PL/SQL 9-6 C eb 9-8 C++ CORBA 8 EJB ECO/Java 8 EJB ECO/Java 9-8 JServlet 9-9 JWeb C eb CWeb CWeb Oracle Application Server

147 9-2 CWeb myccartridge.so (UNIX).dll (NT).so.dll URL /myapp/test 9-7

148 C /<appname>/<cartname> URL C %ORAWEB_HOME%/bin Oracle Application Server C++ CORBA C++ CORBA C++ CORBA C++ CORBA C++ CORBA JServlet JServlet JServlet myjservletcartridge 9-8 Oracle Application Server

149 URL /myapp/jservlettest Java CLASSPATH CLASSPATH JWeb JWeb JWeb 9-9

150 myjwebcartridge Java CLASSPATH CLASSPATH URL /myapp/jwebtest LiveHTML LiveHTML LiveHTML 9-10 Oracle Application Server

151 mylivehtmlcartridge URL LiveHTML LiveHTML LiveHTML : ".." ".." "routines/../lib/" Perl Perl

152 9-6 Perl myperlcartridge URL Perl Perl Perl : ".." ".." "routines/../lib/" 9-12 Oracle Application Server

153 PL/SQL PL/SQL PL/SQL PL/SQL URL PL/SQL /<appname>/<cartname> PL/SQL PL/SQL ".sql" PL/SQL PL/SQL Oracle Application Server PL/SQL ODBC SQL 9-13

154 DAD PL/SQL Database Access Descriptor DAD DAD DAD DAD DAD PL/SQL DAD DAD 6 Database Access Descriptor (DAD).app <cartridge>.app /private/oracle/ows/cartx/plsql/install/ cartridge.app <cartridge>.app Oracle Application Server 9-14 Oracle Application Server

155 CORBA CORBA ECO/Java EJB CORBA ECO/Java EJB ECO/Java PL/ SQL Perl 2 C JWeb LiveHTML ODBC Perl PL/SQL 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 9-15

156 4. "+" 5. "+" 6. "+" 7. "+" Oracle Application Server Oracle Application Server / Oracle Application Server

157 9-9 / 9-10 / / Oracle Application Server 9-17

158 9-10 / (MT) Oracle Application Server

159 Oracle Application Server 9-11 URL /myapp/ test %ORAWEB_HOME%/test 9-19

160 URL 1 : /A/B/C 1. /A/B/C URL /A/B/C 2. /A/B/C/D55 URL /A/B/C/D55 3. /A/B/C/ URL /A/B/C URL/A/B/C/D55 /A/B/ C/E/F 4. /A/B/C3* /A/B/C3 URL /A/B/C327 /A/B/C/D 2 Oracle Application Server URL URL URL /plsql_dba/plsql /plsql_dba/plsql/ Basic_ Oracle Crypt 9-20 Oracle Application Server

161 Basic_Oracle &/ 1 '&' ' ' 2 1 IP/ IP IP C C CWeb Oracle Application Server 9-19 CWeb CWeb CWeb 9-3 CWeb CWeb 9-21

162 9-3 CWeb DLL DLL C CWeb C 9-22 Oracle Application Server

163 9-13 JWeb JWeb Oracle Application Server 9-19 LiveHTML LiveHTML LiveHTML Parameters 2 Oracle Application Server

164 . LiveHTML Parameters LiveHTML Parameters LiveHTML LiveHTML Parameters LiveHTML 9-14 LiveHTML 9-4 LiveHTML LiveHTML LiveHTML LiveHTML SSI Web Application Object LiveHTML LiveHTML LiveHTML 9-24 Oracle Application Server

165 9-4 LiveHTML LiveHTML LiveHTML HTML "html" HTML SSI html shtml lhtml exec ICX ICX <BODY> exec SSI request ICX <BODY> ICX request ICX <BODY> request HTML ICX <BODY> ICX HTML URL HTML index.html Perl Oracle Application Server LiveHTML Perl hsp hsa asp asa Perl 9-25

166 9-4 LiveHTML LiveHTML HTML Perl Perl Perl Perl 1 Perl Perl Perl "/" ODBC Oracle Application Server Manager OBDC Perl Perl Perl Parameters 2 Oracle Application Server 9-19 Perl Parameters Perl Parameters Perl Perl 9-26 Oracle Application Server

167 9-15 Perl 9-5 Perl PERLLIB %ORAWEB_HOME%/../cartx/perl/ lib Perl Perl Perl Perl pl Perl Perl txt %ORAWEB_HOME%/../cartx/perl/ lib/perlinit.pl 9-27

168 9-5 Perl Perl Perl Perl Perl Perl 1 PL/SQL PL/SQL PL/SQL Oracle Application Server 9-19 PL/SQL PL/SQL PL/SQL Oracle Application Server

169 ECO/Java EJB 9-16 PL/SQL 9-17 PL/SQL DAD PL/SQL DAD HTML URI HTML ECO/Java EJB ECO/Java EJB CORBA 9-29

170 ECO/Java EJB 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. CORBA 9-18 / Oracle Application Server 9-30 Oracle Application Server

171 ECO/Java EJB Oracle Application Server CGI HTML

172 ECO/Java EJB 9-19 Oracle Application Server Oracle Application Server <scheme>(<realm>) [ {" " "&"} & <scheme>(<realm>)... ] 1 "scheme(realm)" 9-19 Basic(myProject) & IP(buildingOne) 2 "myproject" "buildingone" IP "or" 1 "myproject" IP "buildingone" Basic(myProject) IP(buildingOne) authenticationstring Oracle Application Server CORBA JWeb LiveHTML Oracle Application Server Oracle Application Server "noaccess" 9-32 Oracle Application Server

173 ECO/Java EJB CORBA CORBA 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. "+"

174 ECO/Java EJB Oracle Application Server

175 Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+"

176 9-6 ID owsapps/ owstat Web isp-pc ID 2342: ID 1 ID Oracle Application Server

177 Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+"

178 : PID wrks ID DDDD HH:MM:SS.SSSSSS : appname/cartname 9-38 Oracle Application Server

179 9-8 Windows NT.dll Solaris.so True Oracle Application Server Manager 1. Web WelcomeOracle Application Server Manager Welcome Oracle Application Server 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" Oracle Application Server 9-39

180 1. Web WelcomeOracle Application Server Manager Welcome Oracle Application Server 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. / Oracle Application Server ECO/Java 2 Oracle Application Server 1 Oracle Application Server Oracle Application Server Oracle Application Server Manager 1. Web WelcomeOracle Application Server Manager 9-40 Oracle Application Server

181 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. "+" CPU

182 : CWeb JServlet JWeb ECO/Java EJB Oracle Application Server True CWeb JWeb Oracle Application Server Oracle Application Server >1 / 1 >1 any >1 any any Oracle Application Server

183 Oracle Application Server OAS 1 OAS OAS OAS 9-43

184 9-44 Oracle Application Server

185 10 Oracle Application Server Web HTML Oracle Application Server Log Analyzer Log Analyzer Oracle Application Server Manager Log Analyzer Logger Log Analyzer Log Analyzer Logger URL Oracle Application Server 10-1

186 Log Analyzer Web Web 1. WelcomeOAS Manager 2. Oracle Application Server XLF 10-1 OAS Manager Oracle Application Server

187 Logger DAD DAD DAD 6 Database Access Descriptor (DAD) Logger : : : : : 0 1 :

188 Oracle Application Server 10-3 : : 10-4 Oracle Application Server

189 FS : DB : DAD 10-3 Logger DAD (DB) (FS) LOGSYSMSG : ORAWEB_ADMIN ORAWEB_HOME /private/oas/logs/ wrb.log ,000,000 10MB 10-5

190 UNIX : Logger Logger Windows : Logger Logger Logger Logger logfile_name.pid PID Logger ID logfile_name.n n wrb.log wrb.log.0 wrb.log.1...wrb.log wrb.log wrb.log Logger 0 : ORAWEB_ADMIN ORAWEB_HOME /private/oas/logs/ WRB 10-6 Oracle Application Server

191 10-1 / / ADP ( ) ADP_Spyglass ADP_Netscape ADP_IIS ADP_Netscape_Heartbeat ADP_Spyglass_Heartbeat Dispatcher_Gen Dispatcher_OSD Dispatcher_HB Logger BASIC DIGEST IP DOMAIN BO WRB WRB 0xFFFFFFFF 0x00001FFF 0x x x x x a 0x00002FFF 0x x x x00004FFF 0x00008FFF 0x00010FFF 0x00020FFF 0x00040FFF 0x00080FFF 0x x x x x x x00100FFF 0x00200FFF 0x00400FFF 0x00800FFF 10-7

192 / Inter-Cartridge Exchange Java NCX Java 0x x x x x x01000FFF 0x04000FFF (0x00004FFF) (0x00008FFF) 'OR' (0x0000CFFF) 7 Logger core init malloc Oracle Application Server

193 7-10 7: SSI WRB 8: request foo has been executed WRB 9: WRB 10: WRB foo= Oracle Application Server CPU 10-4 Logger queue_length=10 Logger 1. WelcomeOAS Manager

194 Oracle Application Server Oracle Application Server

195 10-3 logattrib entry_date date usec number wrb varchar2(100) WRB WRB WRB component varchar2(2000) (ADP) (VPM) RM id number ID lname varchar2(2000) lvalue varchar2(2000) 1. WelcomeOAS Manager Oracle Application Server

196 10-5 : : FS : DB : DAD 10-3 Logger DAD (DB) (FS) LOGSYSMSG Oracle Application Server

197 %ORAWEB_ADMIN%/website40/log /private/oas/logs/ attrib.log ,000,000 10MB UNIX : Logger Logger Windows : Logger Logger Logger Logger logfile_name.pid PID Logger ID logfile_name.n n attrib.log attrib.log.0 attrib.log.1...attrib.log attrib.log attrib.log Logger

198 XLF %ORAWEB_ADMIN%/website40/log /private/oas/logs/ XLF IP HTTP URL HTTP HTTP user agent accept CLF XLF CLF/XLF Logger XLF Oracle Log Analyzer XLF CLF/XLF Logxlf Logxlfheader Xlfseq 10-4 Logxlf entry_date date usec number wrb varchar2(100) Web Request Broker (WRB) WRB WRB component varchar2(2000) (ADP) (VPM) RM id number ID Oracle Application Server

199 xlfseq number logxlf logxlfheader time_taken number bytes number cached number c_ip varchar2(100) IP c_dns varchar2(100) DNS s_ip varchar2(100) IP s_dns varchar2(100) DNS sc_status number c_auth_id varchar2(100) sc_comment varchar2(100) cs_method varchar2(100) GET POST cs_uri_stem varchar2(2000) URI cs_uri_query varchar2(2000) URI 10-5 Logxlfheader xlfseq number logxlf logxlfheader prefix varchar2(2) "cs" "sc" hname varchar2(2000) HTTP hvalue varchar2(2000) HTTP 10-15

200 Xlfseq logxlf logxlfheader create sequence xlfseq start with 1000 nomaxvalue order; XLFXLF 10-6 XLF Web XLF Web : XLF : XLF XLF CLF XLF xlf.log Oracle Application Server

201 FS : DB : DAD 10-3 Logger DAD (DB) (FS) LOGSYSMSG %ORAWEB_ADMIN%/website40/log /private/oas/logs/ xlf.log ,000,000 10MB 10-17

202 UNIX : Logger Logger Windows : Logger 2 Logger Logger Logger logfile_name.pid PID Logger ID logfile_name.n n xlf.log.log xlf.log.0 xlf.log.1...xlf.log xlf.log xlf.log Logger 0 %ORAWEB_ADMIN%/website40/log /private/oas/logs/ XLF CLF XLF clf Oracle Application Server

203 10-6 clf cs (User-Agent) cs (Referer) clf-date c-auth-id bytes date time time-taken c-ip s-ip c-dns s-dns sc-status CLF c-dns cauth-id [clf-date] " " sc-status Request-URI URI CLF [dd/mm/yyyy: : : GMT_offset] : IP IP DNS DNS 2 5 1xx: : 2xx: : 3xx: : 4xx: : 5xx: : 10-19

204 sc-comment cs-method cs-protocol cs-uri cs-uri-stem cs-uri-query prefix (header) "101" "200"OK "300" "400" "500" GET POST HTTP URI URI URI Header HTTP prefix c: s: r: cs: sc: XLF XLF Oracle Application Server PL/SQL Toolkit Log Analyzer Oracle Application Server

205 HTML OAS Oracle Application Server 1. Welcome 1-5 Welcome 2. OAS OAS : Node Manager Administration Utility OAS 10-21

206 Database Access Descriptor(DAD) DAD DAD 6-2 DAD 1: Logger Logger Log Analyzer : Logger Log Analyzer 1. Logger Logger 10-8 Logger 2. DAD DAD DAD DBA 3. SYS Oracle Application Server

207 : Oracle8 catdbsyn.sql Oracle7 LOGGER 4. OK 2: PL/SQL Toolkit PL/SQL Toolkit PL/SQL Log Analyzer Oracle Application Server PL/SQL Toolkit 1. PL/SQL ToolkitPL/SQL Toolkit 10-9 PL/SQL Toolkit 2. ORACLE_SID 10-23

208 ORACLE_SID: Oracle Application Server ORACLE_HOME SID ORCL : Oracle Application Server ORACLE_HOME tnsnames.ora : OAS 6-2 DBA : sys : sys : PL/SQL Toolkit DAD PL/SQL oas_public PL/SQL 3. OK 3: Log Analyzer Log Analyzer Logger Log Analyzer URL : Log Analyzer PL/SQL Toolkit Logger Log Analyzer 3 Log Analyzer Oracle Application Server

209 1. Log Analyzer 2. DAD DBA 3. SYS Log Analyzer 4. OK Log Analyzer Log Analyzer 4: PL/SQL : PL/SQL Toolkit Logger DAD DBA 3. SYS 10-25

210 4. OK 5. OAS Manager DAD a. Go to OAS HomeWelcome b. WelcomeOAS Manager c. d. e. DB Utilities f. g. DB Browser h. PL/SQL PL/SQL Agent PL/SQL Agent Oracle Application Server

211 Log Analyzer i. DAD DAD : DB UtilitiesPL/SQL DAD : DAD DAD SYS SVRMGR> grant ows_standard_role to <user> SVRMGR> grant all on websys.owa_content to <user> Log Analyzer Oracle Application Server wrb.log xlf.log Log Analyzer Log Analyzer Log Analyzer Log Analyzer Web Web : WRB_LOGwriteAttribute() Log Analyzer Log Analyzer logreport 10-27

212 Log Analyzer 10-7 logreport rname varchar2(100) Analyzer rdescription varchar2(2000) Analyzer qdescr long Analyzer SQL rform varchar2(2000) Analyzer dimension number XLF (SYSMSG) (ATTRIB) 1 Oracle Application Server XLF SYSSMSG ATTRIB WelcomeOAS Log Analyzer Oracle Application Server

213 Log Analyzer DAD DAD DAD DAD (DBA) 10-3 Logger DAD XLF UNIX: /ows/admin/website40/log NT: D: ows admin website40 log XLF XLF xlf.log XLF : (XLF) 10-29

214 Log Analyzer SYSMSG : ATTRIB : XLF XLF 1. Log Analyzer XLF XLF Log Entries XLF 10 NULL '-' XLF Log Entries 10-8 XLF Oracle Application Server

215 Log Analyzer 10-8 XLF Log Entries date time bytes client-ip client-dns server-ip server-dns status yyyy-mm-dd : : IP DNS NULL '-' IP Web IP DNS 2 5 1xx: : 2xx: : method uri-stem uri-query auth-id 3xx: : 4xx: : 5xx: : GET POST URI URI Next

216 Log Analyzer 1. Log Analyzer Log Analyzer System Messages Log Entries 10 NULL '-' System Messages Log Entries System Messages Log Entries Oracle Application Server

217 Log Analyzer 10-9 date time wrb component id severity mask message yyyy-mm-dd : : Web Request Broker (WRB) WRB WRB PL/SQL ID WRB Next 10 Log Analyser 1. WelcomeOAS Log Analyzer 4. 4 XLF

218 Log Analyzer XLF XLF XLF XLF Log Report(s) TOTAL REQUESTS Oracle Application Server

219 Log Analyzer Total Requests Delete : 1. NewModify Add/Modify XLF Report 10-35

220 Log Analyzer Add/Modify XLF Log Report Add/Modify XLF Report Report Name: Report Description: Field Name: Client IP Addres Display: Yes No No DateURLYes Date URL 2 Operation: Oracle Application Server

221 Log Analyzer NULL Comparator: < > = '=' Comparison Value:.gov DomainComparison Value "gov" Comparator Value "*.com" ".com" "*" 0( ) time date byte domain country Add/Modify xlf Log report Client IP Address IP Null Total Average Client Host Url HTTP DNS uri_stem uri_query URL Null Total Average Null Total Average Bytes : Bytes = > < Display Yes No Null Total Average Minimum Maximum 10-37

222 Log Analyzer Status Method Domain Auth Id Server IP Address HTTP Status = > < 3 Display Yes No GET POST 3 "com" "edu" "mil" "gov" "net" "org" ID HTTP IP ' ' Null Total Average Null Total Average Null Total Average Null Total Average Null Total Average Server Host Null Total Average Date Time XLF DateFrom To URL 'yyyy-mm-dd' XLF TimeFrom To 2 ' : : ' 24 18:10:00 Null By Year By Month By Day Null By Hour: 0 23 By 10 minute Comparator Value "*.com" ".com" "*" 0( ) Oracle Application Server

223 Log Analyzer Time Date Bytes Domain CountryCompare Value Dimension: 15 Dimension 0 Sort By: = "yes" Display No Operation NULL Sort Order: Total Sort By Sort Order Distinct: Save Report: Save Report Reset Form: Reset Form Url Display = Yes Url Operation = Total Comparison Value 1 URL Operation = Average Date Operation = By Day URL Url Display = Yes Url Operation = Total Sort By = Url Sort Order = Descending Client Host Display = Yes Url Operation = Total Sort By = Url Sort Order = Descending 10-39

224 Log Analyzer Client Host Display = Yes Bytes Operation = Total Sort By = bytes Sort Order = Descending Date Display = Yes Date Comparator From = Date Comparator To = Bytes Operation = Total Dimension = "2" Sort By = bytes Sort Order = Descending System Message Report(s) System Message Report(s) Oracle Application Server

225 Log Analyzer Logger Submit Field Name: Comparator: < > = '=' Value: System Messages Report(s) / Date DateFrom To 'yyy-mm-dd' Time TimeFrom To 2 ' : : ' 24 Component Name Process Id Severity Level ID PL/SQL Process Id "=" Severity Level = > < 3 > Dimension: 15 Dimension

226 Log Analyzer Submit Report: Submit Report Reset Form System Messages Report Results System Messages Reports Results System Messages Reports Results Entry Date Entry Time Wrb Component ID Severity yyyy-mm-dd : : Web Request Broker (WRB) WRB WRB PL/SQL ID Oracle Application Server

227 Log Analyzer Mask Message WRB Web Web 10 XLF IP 2 1 Modify CONCURRENT USER Report Modify CONCURRENT USER Report Modify CONCURRENT USER report Period DateTime 10-43

228 Log Analyzer Date: DateFrom To "YYYY-MM-DD" Time: TimeFrom To 2 "HH:MM:SS" 24 08:00:00 23:59:59 Time Interval 10 By 10 Minute By Hour By Day By Month By Year Null Sort By Time Interval: Client IP Address: IP Other: Client Host URL : XLF Save Report Reset Form Oracle Application Server

229 Log Analyzer CONCURRENT USER Results Client IP Address IP Client Host HTTP DNS Url uri_stemuri_query URL Bytes : Status HTTP Method GET POST Domain 3 "com" "edu" "mil" "gov" "net" "org" ".uk" ".au" Auth Id ID Server IP Address HTTP IP " " 10-45

230 Server Host Entry Date XLF Entry Time XLF 1. WelcomeOAS Admin Utility Server Node Manager Admin Utility Server Welcome Oracle Application Server

231 10-22 Welcome PL/SQL : 10-47

232 : Web HTML Web No : HTML No Yes : HTML Yes Not Sure : HTML Not sure 1. Tables and Views Oracle Application Server

233 Scott BONUS 4. Execute Query PL/SQL 1. PL/SQL Stored PL/SQL 10-49

234 PL/SQL PL/SQL 3. PL/SQL Database Users Oracle Application Server

235 10-28 Database Sessions Rollback Segments

236 10-30 Database FilesREDO Oracle Application Server

237 1. Tablespace Space Usage Tablespace Free Space Summary

238 10-34 Oracle Application Server : Oracle Application Server : Logger : : : PL/SQL Log Analyzer : Oracle Application Server

239 : : OAS Admin Utility : Admin 10-55

240 10-56 Oracle Application Server

241 11 Oracle Application Server SQL : Oracle Application Server Enterprise Edition DTP TX CORBA (OTS/ JTS) OTS 11-1

242 1 1 Web : OAS Oracle Application Server

243 1 1 1 SQL API API URL 2 : Java Transaction Service (JTS) TX API JTS TX API : URL URL URL :

244 11-1 PL/SQL URL JWeb C LiveHTML JTS TX URI Oracle Application Server LiveHTML Perl JTS JDBC pl2java OCI WDBC ICX PL/SQL Perl JCORBA EJB JTS JDBC OAS OAS 1 Oracle Application Server Oracle Application Server

245 11-1 Transaction Transaction Cartridge Cartridge Distributed Transaction Coordinator (DTC) HO (RM) 11-6 RM 1 Distributed Transaction Coordinator (DTC) (RM) DTC DTC Oracle8 RM DTC Oracle8 11-5

246 RM RM RM Oracle7 Oracle8 1 RM DTC RM RM Oracle RM OTS HO HO Oracle8 Oracle7 RM Oracle7 HO Oracle8 DTC Oracle7 RM Transaction Transaction Cartridge Cartridge Distributed Transaction Coordinator (DTC) HO (RM) Oracle Application Server Manager RM: DAD DAD DAD 6 Database Access Descriptor (DAD) DAD Oracle Application Server

247 DTC: DAD DTC HO : DTC Oracle8 DAD 1 Oracle7 HO : Object Transaction Service Object Transaction Service(OTS) 1. Object Transaction ServiceOTS OTS 2. : Oracle Application Server DTC : RM DAD 3. OAS 11-7

248 DAD/ RM DAD RM 3 1. RM a. RM Oracle7 Oracle8 Oracle : Oracle Application Server DAD Oracle Application Server DAD db_name db_domain ORACLE_SID db_name db_domain INITxxx.ORA svrmgrl "select * from global_name" b. Oracle SQL*Net Net8 TNSNAMES.ORA Oracle Application Server RM TNSNAMES.ORA : DTC OAS Oracle Home RM DTC TNSNAMES.ORA DTC RM DTC TNSNAMES.ORA 2. Oracle Application Server Manager DAD DAD 11-8 Oracle Application Server

249 ORACLE_SID DAD 6 Database Access Descriptor (DAD) : RM Oracle Application Server Oracle OAS Manager RM 3. Oracle Application Server Manager DAD 11-4 Database Access Descriptor 1. DB Access Descriptor (DAD)Database Access Descriptor 11-4 DAD 2. DAD a. DAD DAD 11-9

250 b. DAD 6 Database Access Descriptor (DAD) DAD DAD RM DAD DAD : DAD: 3. DAD: / : DAD DAD : Oracle7 Oracle8 : Oracle7 OTS HO Oracle7 RM Oracle8 DTC HO : RM Oracle Application Server

251 2 : DTC : DTC RM DTC DTC RM 1 DTC RM (global_dbname_dtc_name) DTC 3. DTC init.ora "global_names=false" global_names true RM Oracle INITxxx.ORA INITxxx.ORA * : 8 * : us.oracle.com OTS : RM Oracle7 RM Oracle8 OTS HO Oracle8 DTC Oracle7 RM RM Oracle7 RM HO HO DTC Oracle8 LISTENER.ORA HO 11-1 ots_ho

252 4. RM DAD DAD RM 1 DTC : RM DTC RM OAS Manager Distributed Transaction Coordinator DTC 3 : DTC DAD DTC DAD DTC DTC DAD 1. DTC Oracle8 Oracle8 UNIX Windows NT DTC DTC Oracle Application Server DTC init<sid>.ora open_links Oracle Application Server DTC open_links open_links init<sid>.ora Oracle Application Server DTC open_links init<sid>.ora ots_<sid>.ora OWS-29046:"DTC initsid.ora " : open_links init<sid>.ora Oracle Application Server DTC Oracle Application Server DTC Oracle Oracle Application Server

253 2. SQL*NET V2 Oracle7 Net8 Oracle8 DTC RM RM Oracle Application Server TNSNAMES.ORA Oracle Application Server RM : TNSNAMES.ORA TNSNAMES.ORA TNSNAMES.ORA Oracle Application Server TNSNAMES.ORA Windows NT DTC Oracle Application Server Oracle DTC TNSNAMES.ORA DTC Oracle Application Server Oracle DTC Oracle Application Server TNSNAMES.ORA RM Oracle Application Server TNSNAMES.ORA DTC DTC Oracle Application Server Oracle RM DTC TNSNAMES.ORA 11-6 Oracle Home DTC OAS tnsnames.ora RM A DTC tnsnames.ora 11-13

254 DTC Net8 Net8 TNSNAMES.ORA LISTENER.ORANet8 3. Oracle Application Server Manager DTC : DTC DTC 1. Object Transaction Service 2. Object Transaction Service DTC Distributed Transaction Coordinator Distributed Transaction Coordinator 3. Distributed Transaction Coordinator DTC: Oracle Application Server

255 11-8 DTC: 4. DTC: DTC : DTC ORACLE_SID: DTC Oracle8 ORACLE_SID : DTC jxwang.us.oracle.com jxwang us.oracle.com jxwang : OAS DTC Web 11-15

256 ORACLE_HOME: DTC Oracle8 : DTC Oracle Application Server DTC OAS Net8 TNSNAMES.ORA $ORACLE_HOME/network/admin $TNS_ADMIN SQLNET.ORA OAS tnsnames.ora RM A DTC tnsnames.ora : TNSNAMES.ORA TNSNAMES.ORA TNSNAMES.ORA Oracle Application Server Windows NT Oracle Application Server TNSNAMES.ORA DBA : DTC Oracle8 DTC DBA DBA : DTC Oracle8 DTC DBA SYSOPER : "internal" "internal" Oracle Application Server

257 Windows NT UNIX DAD : RM DAD DAD RM DAD DAD DAD: DAD : DTC DAD DAD DTC : Oracle8 INITxxx.ORA DTC Oracle8 5. DTC RM DTC RM/ DAD Server Manager connect system/manager select * from all_db_links; : DTC RM DAD HO RM DAD Oracle7 Oracle8 DTC HO DTC RM HO DTC Oracle8 TNSNAMES.ORA LISTENER.ORA TNSNAMES.ORA RM 2 RM RM UNIX HO Oracle8 Windows NT HO Oracle Application Server HO hsots Windows NT hsots.exe $ORACLE_HOME/bin HO Oracle

258 Oracle8 TNSNAMES.ORA DTC Oracle8 RM RM Oracle7 DTC RM HO TNSNAMES.ORA HO HO TNSNAMES.ORA ho_agent_service_name = (DESCRIPTION= (ADDRESS = (PROTOCOL=TCP) (Host= Oracle8_hostname) (Port= Oracle8_portnumber) ) (CONNECT_DATA = (SID = HO_SID) ) (HS=) ) Oracle8_hostname: DTC Oracle8 Oracle8_portnumber: DTC Oracle8 HO_SID: LISTENER.ORA HO SID LISTENER.ORA HO SID "ho_agent" : HO DAD: OTS LISTENER.ORA Oracle8 LISTENER.ORA HO SID_LIST_listener = (SID_LIST= (SID_DESC=(SID_NAME=rdbms80)(ORACLE_HOME=/private/oracle)) (SID_DESC=(SID_NAME=rdbms70)(ORACLE_HOME=/private/ORA7)) (SID_DESC=(SID_NAME=ho_agent)(ORACLE_HOME=/private/oracle)(PROGRAM=hsots)) Oracle Application Server

259 HO Oracle8 $ORACLE_HOME HO SID_NAME TNSNAMES.ORA HO CONNECT DATA HO PROGRAM=hsots RM SID_NAME RM 11-1 HO HO TNSNAMES.ORA LISTENER.ORA /*TNSNAMES.ORA file configures an HO Agent called test_ho*/ ots_ho = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (Host = jxwang-sun.us.oracle.com) (Port = 1521) ) (CONNECT_DATA = (SID = test_ho) ) (HS=) ) /*LISTENER.ORA file defines listener for HO Agent called test_ho*/ SID_LIST_ots_listener = (SID_LIST= (SID_DESC=(SID_NAME=804)(ORACLE_HOME=/private/oracle/product/8.0.4)) (SID_DESC=(SID_NAME=test_ho)(ORACLE_HOME=/private/oracle/product/8.0.4) (PROGRAM=hsots)) )

260 11-2 PL/SQL JWeb C LiveHTML Perl JCORBA EJB URL JTS TX URI JTS DAD Oracle Application Server Oracle Application Server

261 Tx : DAD : RM 1 : DAD DAD 11-21

262 URI PL/SQL C 2 PL/SQL C Web EJB JCORBA Web Web URI URI URI : URI World Wide Web URL URI PL/SQL begin PL/SQL PL/ SQL /hr/emp/begin URI /hr/emp/begin PL/SQL begin begin (begin) (commit) (rollback) URI Oracle Application Server

263 PL/SQL : PL/SQL C PL/SQL : PL/SQL URI URI Web URI URI /hr/emp /hr/emp/begin

264 11-10 PL/SQL : Oracle Application Server Oracle Application Server PL/SQL C PL/SQL : Oracle Application Server PL/SQL OAS OAS C 7. URI URI URI : Web URI URI World Wide Web URL URI Oracle Application Server

265 PL/SQL : PL/SQL : PL/SQL PL/SQL PL/SQL C C URI URI Tx 11-9 : DAD : RM 1 5. Web Web Web

266 11-11 Web : 7. Web : txn_shop URI URI/plsql_dba/plsql/ txn_shop.enter_url plsql_dba txn_shop enter_url URI URI /plsql_dba/plsql/txn_shop.commit_url URI URI /plsql_dba/plsql/txn_shop.rollback_url URI URI /plsql_dba/plsql/txn_shop.* URL URL URL URL Oracle Application Server

267 URI URI Oracle Application Server URL Web URI URI URI URI 2 URI /hr/emp URI /hr/ emp/updateemp /hr/emp/removeemp /hr/emp/addemp URI '*' /hr/emp/emp.* OAS EJB JCORBA GUI (begin) Oracle Application Server EJB ECO/Java CORBA DAD DTC 11-27

268 OTS OTS OTS OTS OTS 1. RM RM Oracle Enterprise Manager svrmgrl 2. Oracle8 DTC DTC 3. Oracle Application Server 4.0 Oracle Application Server Manager Oracle Application Server Oracle Application Server Manager Oracle Application Server OTS OTS 1. Oracle Application Server Manager TXserver1 2. RM DTC RM DTC Oracle Enterprise Manager svrmgrl Oracle Application Server

269 OTS JCORBA 3. Oracle Application Server 4.0 Oracle Application Server Manager Oracle Application ServerOracle Application Server Oracle Application Server DTC DTC Tx 11-29

270 OTS DTC 1. Distributed Transaction Coordinator DTC DTC 2. DTC DTC DTC OK DTC DTC DTC DTC Oracle Application Server

271 OTS DTC 11-31