Oracle Application Server管理者ガイド , リリース

Transcription

1 Oracle Application Server : J

2 Oracle Application Server, : J Oracle Application Server Release Administration Guide A Sheryl Maring Tom Van Raalte, Dave Stahler, Sanjay Singh, Janice Nygard, Pooja Sharma, Betsy Mooney, Julia Pond, Charlie Shapiro, Jun Wang, Seshu Adunuthula, Eric Deslauriers, Scott Christley, Ramani Jagadeba, Loc Nhan, Sajjad Rahman Copyright 1996, 2000 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 Servers NT Microsoft Internet Information Server Apache UNIX Apache Apache OAS Apache Apache Apache EJB Object Request Broker Object Request Broker ORB ORB Database Access Descriptor DAD DAD DAD DAD DAD IIOP HTTP CORBA/IIOP v

6 ECO/Java EJB Web Java Perl CORBA C eb C++ CORBA vi

7 JServlet JSP JWeb LiveHTML Perl PL/SQL CORBA C JWeb LiveHTML Perl PL/SQL ECO/Java EJB CORBA / vii

8 XLF : Logger : PL/SQL Toolkit : Log Analyzer : : DAD Log Analyzer Oracle Transaction Service DAD/ Distributed Transaction Coordinator DTC HO OTS OTS OTS viii

9 12 Oracle Application Server A owsctl... A-2... A-2 version... A-3 start... A-3 stop... A-5 status... A-6 reload... A-8 WRB ORB... A A-11 owsstat... A A A A A A-14 oasnetconf... A A A-16 oaspasswd... A A A-18 oaspasswd... A A-19 oasmcastcfg... A A A A-20 ix

10 B Windows NT... B-1 UNIX... B-3 x

11 Oracle Application Server 4.0 HTTP Oracle Application Server Oracle Application Server Oracle Application Server J Oracle Application Server J Oracle Application Server J Oracle Application Server J Oracle Application Server PL/SQL J Oracle Application Server JServlet JSP J Oracle Application Server LiveHTML Perl J Oracle Application Server EJB ECO/Java CORBA J 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 xi

12 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 1-3

16 Oracle Application Server Welcome 3. Object Request Broker 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 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 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 Oracle Application Server Oracle Application Server 1-7

20 Oracle Application Server OAS 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 Log Analyzer Oracle Application Server WRB Oracle Application Server Oracle Application Server 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 1. Oracle Application Server Manager Web

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

31 Oracle Application Server HTTP WRB WRB Log Analyzer RM 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-8 Oracle Application Server 2-11

34 Oracle Application Server SID CPU ID ID : 1/100 : KB : wrbmon Oracle Application Server Manager oassrv Oracle Application Server 2-7 oassrv :[[ ] : : ] Oracle Application Server Oracle Application Server Manager 1. Oracle Application Server Web Oracle Application Server 2-12 Oracle Application Server

35 3 HTTP HTTP HTTP HTTP HTTP HTTP 1 HTTP HTTP 1 IP / / 1 / HTTP 3-1

36 Oracle Application Server 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

37 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

38 HTTP ID ID 2342: ID 1 ID HTTP HTTP HTTP : Oracle Application Server 3-2 HTTP SID CPU ID ID : 1/ Oracle Application Server

39 : KB :[[ ] : : ] HTTP Oracle Application Server Manager 1. HTTP Web HTTP Web HTTP 3-1 HTTP 3-3 HTTP 3-5

40 3-3 HTTP HTTP 6 HTTP TCP/IP : UNIX Oracle Application Server

41 HTTP HTTP Oracle Application Server 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

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

43 HTTP 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 URL Oracle Application Server HTTP 3-9

44 : 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

45 SSL_V3 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

46 REQ SSL CA SSL 3.0 Oracle Application Server SSL NORM 3-6 HTTP Oracle Application Server

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

48 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

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

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

51 3-8 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 HTTP 3-17

52 N "/" /oas/oas-bin/ Windows NT Windows NT HTTP 3. OK OK 3-18 Oracle Application Server

53 image.en.jpg image.uc.jpg RFC 1766 en ID RFC 1521 iso eng HTTP 3-19

54 MIME MIME 3-10 HTTP Multipurpose Internet Mail Extension MIME 3-10 MIME MIME RFC text/html MIME htm html MIME MIME 8 UNIX Windows NT 3-20 Oracle Application Server

55 compress gzip Z gz HTTP 3-21

56 SSL CA CA Web Oracle Application Server SSL CA 3-12 CA SSL : Trusted Trusted Untrusted Untrusted Trusted CA CA Untrusted CA CA Update TrustUntrust Oracle Application Server

57 1. Add CA : Base64 Delete Oracle Application Server HTTP HTTP /support/news 1 HTTP 3-23

58 /support/partners/ /support/crypt* /support/ crypt Windows NT : / R W D GET HEAD POST PUT DELETE / /Crypt Crypto SSl 1 &/ '&' HTTP ' ' 2 Domain IP IP Oracle Application Server

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

60 3-26 Oracle Application Server

61 4 HTTP Netscape Server Microsoft Internet Information Servers NT Apache UNIX Oracle Application Server HTTP Oracle Application Server Netscape Enterprise Server Apache Microsoft Internet Information Server IIS Oracle Application Server HTTP 4-1

62 Netscape Server Netscape Server Oracle Installer Netscape Enterprise HTTP Server 1 Netscape Server obj.conf.sav Netscape Enterprise HTTP Server obj.conf : Oracle Application Server OAS Netscape Server : Netscape magnus.conf Netscape Netscape magnus.conf 1. Oracle Application Server Welcome port OAS 3. Netscape Netscape 4-2 Oracle Application Server

63 Netscape Server 4-1 Netscape 4. Netscape 5. Netscape Netscape Server Admin Netscape Server Netscape Server 1. OAS Manager 2. Web HTTP Netscape Netscape HTTP 4-3

64 Netscape Server %NS_HOME% https-server config Netscape Server obj.conf Oracle Web Request Broker filename.sav init Netscape Server WRB obj.conf <NS_HOME> <ORAWEB_HOME> Netscape Server Oracle Application Server Init fn=load-modules shlib=<oraweb_home>/lib/ndwfns362.so 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 adaptor="<oraweb_home>/lib/ndwfn362.so" serverconf="<ns_home>/https-server/config/obj.conf" servererrfile="<ns_home>/https-server/logs/errors" mimetypesfile="<ns_home>/https-server/config/mime.types" listenername="mynode" ORAWEB_SITE="website40" : ndwfm362.so Windows NT dwfn36240.dll Oracle Application Server 4.0 Enterprise Server 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>/admin/img" NameTrans fn=pfx2dir from=/ows-aimg dir="<oraweb_home>/admin/img" NameTrans fn=pfx2dir from=/ows-adoc dir="<oraweb_home>/admin/doc" obj.conf AuthTrans fn="oracle-adp-auth-trans" NameTrans fn="oracle-adp-name-trans" PathCheck fn="oracle-adp-path-check" ObjectType fn="oracle-adp-object-type" Service fn="oracle-adp-service" AddLog fn="oracle-adp-addlog" 4-4 Oracle Application Server

65 Microsoft Internet Information Servers NT Microsoft Internet Information Servers NT Oracle Application Server Microsoft Internet Information Server IIS IIS Oracle Application Server Oracle Application Server OAS Manager IIS Microsoft Management Console Microsoft Internet Information Server Microsoft IIS ISAPI 2 In-Process Out-of-Process Oracle Application Server In-Process In-Process.dll IIS IIS Oracle Application Server Microsoft Management Console ISAPI 1. Microsoft Management Console IIS Properties 4-2 IIS Management Console HTTP 4-5

66 Microsoft Internet Information Servers NT 2. ISAPI FiltersAdd 4-3 ISAPI Oracle Application Server ISAPI.dll Filter Name : Executable : %ORAWEB_HOME% bin libndwfis40.dll %ORAWEB_HOME% Oracle Application Server 4.0 c: orant ows OK Apply 4. ISAPI 5. Microsoft Management Console Oracle Application Server Web "Default Web Site" New Virtual Directory 4-6 Oracle Application Server

67 Microsoft Internet Information Servers NT 4-4 New Virtual Directory Wizard 6. "ows" HTTP 4-7

68 Microsoft Internet Information Servers NT %ORAWEB_HOME% bin c: orant ows 4.0 bin Allow Execute Access Finish 4-8 Oracle Application Server

69 Microsoft Internet Information Servers NT Run in separate memory space : IIS lazy Oracle Application Server IIS Oracle Application Server IIS IIS Oracle Application Server Node Manager Oracle Application Server Microsoft Management Console IIS Oracle Application Server / DAD Node Manager Oracle Application Server IIS HTTP 4-9

70 Microsoft Internet Information Servers NT : WRB Microsoft Management Console IIS WRB Microsoft Management Console IIS IIS WRB IIS 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 OAS_IIS_AUTH_ENABLED TRUE Oracle Application Server

71 Apache UNIX System Environment HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE> OAS40 Oracle Application Server IIS OAS_IIS_AUTH_ENABLED FALSE Oracle Application Server Oracle Application Server IIS 1. Windows NT 4.0 Option Pack Microsoft Internet Information Server Internet Service Manager 2. Web Directory Security 5. Anonymous Access and Authentication Control 6. Windows NT Challenge/Response 7. Basic Authentication (Password is sent in Clear Text) 8. Oracle Application Server IIS Apache UNIX Apache Oracle Application Server Apache HTTP Apache HTTP 4-11

72 Apache UNIX 4-8 Apache Apache L1 L2 L3 L4 CORBA D1 D2 Apache Apache HTTP L1, L2,... Apache libapadp.so - ndwfapd.so - ows_module Oracle Application Server Apache Apache C mod_so Apache 4 mod_so Oracle Application Server Apache Apache SSL : Oracle Application Server ID 1. Apache Oracle Application Server

73 Apache UNIX./configure --prefix=<apache_home> --enable-module=so <apache_home> Apache 3. make make install 4. <apache_home>/conf/httpd.conf ows_module a. LoadModule ows_module <ORACLE_HOME>/ows/4.0/lib/ndwfapd.so <ORACLE_HOME> OAS ORACLE_HOME b c. ClearModuleList AddModule Oracle Application Server 5. httpd.conf Oracle Application Server Apache OAS Apache 1. Oracle Application Server Welcome 1-5 Welcome 2. OAS Apache HTTP 4-13

74 Apache UNIX 4-9 Apache Apache Apache - bin httpd /private/home/apache/bin/httpd - conf httpd.conf /private/home/apache/conf/httpd.conf 7. Oracle Application Server 4-14 Oracle Application Server

75 Apache UNIX Apache : Apache 60 APACHE_MASTER_DISP_TIMEOUT Apache 1. OAS Manager : Apache Oracle Application Server 1-7 Oracle Application Server 2. Web HTTP Apache Apache Apache EJB Apache EJB Apache ScriptAlias $ORAWEB_HOME/bin /ows-bin/ HTTP 4-15

76 Apache UNIX 4-16 Oracle Application Server

77 5 Object Request Broker Object Request Broker ORBOracle Application Server Manager ORB Object Request Broker ORB ORB Object Request Broker ORB ORB Oracle ORB Object Request Broker ORB ORB Object Request Broker 5-1

78 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

79 ORB 5-2 ORB 2. ORB ORB ORB TCP ORB 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 ORB Oracle Application Server ORB Object Request Broker 5-3

80 ORB Oracle Application Server 3. ORB 5-4 Oracle Application Server

81 6 Database Access Descriptor DAD Database Access Descriptor DAD DAD DAD DAD DAD Database Access Descriptor DADOracle Application Server Oracle DAD DAD DAD SQL*Net V2 TNS Net8 DAD DAD DAD DAD Database Access Descriptor DAD 6-1

82 DAD : PL/SQL DAD Oracle Application Server PL/SQL 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)) ) 6-2 Oracle Application Server

83 DAD demo 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

84 DAD 6-1 Database Access Descriptor DAD : DAD DAD DAD: DAD DAD DAD / "_" 6-4 Oracle Application Server

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

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

87 DAD 6-3! 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

88 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

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

90 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

91 DAD 6-5 DAD 2. DAD: Database Access Descriptor DAD 6-11

92 DAD 6-6 DAD: NLS NLS SYSTEM Oracle SYSTEM / DAD AMERICAN_AMERICA.US7ASCII TO_CHAR TO_DATE "MM/DD/YYYY" 6-12 Oracle Application Server

93 DAD NLS NLS NLS NLS NLS ISO NLS AM PM AD BC BINARY BINARY ORDER BY L 'L099' L FRANCE C 'C099' C FRANCE NLS_CALENDAR Japanese ImperialYY-MM- DD Database Access Descriptor DAD 6-13

94 DAD 6-14 Oracle Application Server

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

96 Oracle Application Server 1 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 UNIX DLL NT Java 7-2 Oracle Application Server

97 7-1 JSP JSP LiveHTML Perl PL/SQL HTTML Perl SQL A IIOP Oracle Application Server IIOP CORBA Oracle Application Server ECO/Java 7-3

98 Enterprise JavaBeans EJB C++ CORBA ECO/Java EJB Java Java CORBA CORBA ECO/Java EJB Oracle Application Server EJB ECO/Java CORBA 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 7-4 Oracle Application Server

99 Oracle Application Server ECO/Java ECO/Java 1 ECO/Java ECO/Java JServlet Java Java JSP Web CORBA CORBA CORBA Java Java ORB ECO/Java ECO/Java Web Web ORB IIOP Oracle Application Server 7-3 Enterprise JavaBeans EJB 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++ 7-5

100 C++ 1 C++ C++ C++ Oracle Application Server 3 ECO/Java/EJB HTTP HTML Oracle Application Server 7-6 Oracle Application Server

101 1 : HTTP API Oracle Application Server Enterprise Edition API 11 : 7-7

102 HTTP Oracle Application Server Web HTTP CORBA CORBA/IIOP ORB 7-2 Web HTTP HTTP HTTP Oracle Application Server 7-8 Oracle Application Server

103 CORBA/IIOP 7-3 Java ECO/Java CORBA/IIOP RM CORBA EJB ECO/Java RM EJB EJB CORBA/IIOP Oracle Application Server EJB ECO/Java CORBA 7-3 CORBA/IIOP Java IIOP IIOP ECO/EJB 4. RM 7-9

104 7-10 Oracle Application Server

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

106 Oracle Application Server Manager PL/SQL PL/SQL 8-1 PL/SQL Oracle Application Server Manager 8-1 Web Oracle Application Server Oracle Application Server 8-2 Oracle Application Server

107 8-1 DB Browser Log Analyzer 2 DB Utilities Oracle Application Server 1 PL/SQL Perl 9 ECO/Java EJB Oracle Application Server Manager ECO/Java EJB ECO/Java 8-3

108 8-2 ECO/Java 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 8-4 Oracle Application Server

109 ECO/ Java EJB MIME MIME Web Web Web Web jpeg gif Web Web Web Web JServlet JSP Web Web Tx 11 Database Access Descriptor DAD Tx 6 Database Access Descriptor DAD DAD : ECO/Java EJB 9 8-5

110 : Web HTTP Oracle Application Server Database Access Descriptor Database Access Descriptor DAD 6 Database Access Descriptor DAD C++ CORBA PL/SQL JServlet JWeb JSP LiveHTML Perl CWeb DAD LiveHTML CWeb 8-6 Oracle Application Server

111 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

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

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

114 3 Oracle Application Server Manager OK 2 OK 9 60 UNIX /Windows NT Oracle Application Server Manager 1.0 EJB ECO/Java 8-5 EJB ECO/Java JAR 3 Oracle Application Server Manager 8-10 Oracle Application Server

115 8-5 EJB JAR ECO/Java EJB JAR JAR JAR : JAR 60 UNIX /Windows NT ECO/Java EJB 3 JAR JAR 8-11

116 JAR JAR JAR C++ CORBA C++ CORBA C++ CORBA C++ CORBA C++ CORBA.so UNIX.dll NT JAR 8-7.app <application>.app Oracle Application Server 8-12 Oracle Application Server

117 8-7 <application>.app $ORACLE_HOME/ows/cartx/ plsql/install/myapplication.app <application>.app Oracle Application Server Oracle Application Server $ORACLE_HOME/../cartx/livehtml/samples $ORACLE_HOME/../cartx/livehtml/samples 8-13

118 : ECO/Java EJB C++ CORBA ECO/Java EJB 2 PL/SQL Java ECO/Java / Oracle Application Server wrb.app Oracle Application Server

119 8-3 C.so.dll ECO/Java EJB JServlet JWeb JSP LiveHTML LiveHTML Perl ECO/Java EJB Java Java JSP Java LiveHTML LiveHTML Perl Perl Perl ECO/Java EJB PL/SQL : Oracle Application Server Manager Oracle Application Server 8-4 Oracle Application Server Manager Oracle Application Server Manager

120 Oracle Application Server Oracle Application Server 8-34 : Oracle Application Server 8-4 RM RM RM RM RM RM RM RM RM 8-16 Oracle Application Server

121 Oracle Application Server Manager Oracle Application Server Manager Web Java Perl : / 8-17

122 Oracle Application Server ECO/Java EJB 8-10 ECO/Java EJB Oracle Application Server

123 Oracle Application Server / is-system31 Oracle Application Server / / Oracle Application Server 8-19

124 1 9 Oracle Application Server Oracle Application Server Oracle Application Server 5 Oracle Application Server 8-11 Logger Logger Oracle Application Server

125 %ORAWEB_ADMIN%/website40/log /private/oas/logs/ wrb.log %ORAWEB_ADMIN%/website40/log Web Logger 3 Logger Web Web HTTP ECO/Java EJB HTTP

126 8-12 Web MIME + + html, txt - -jpeg, gif URL SSL SSL SSL Oracle Application Server True 8-22 Oracle Application Server

127 Oracle Application Server JServlet Oracle Application Server JServlet JSP 4 JServlet JServlet JSP 15 JServlet JSP 600 setmaxinactiveinterval Oracle Application Server Oracle Application Server JServlet JSP $ORAWEB_HOME/ admin/doc/wrberr.html 8-23

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

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

130 8-6 Java JAVA_HOME THREADS_FLAG Java %ORAWEB_HOME%/jdk UNIX Java "native" Java 8-14 Java Java Java Java 8-14 Java Java Oracle Application Server

131 8-7 Java Java Java -verbose VERBOSE true false -noasyncgc NOASYNCGC true false -verbosegc VERBOSEGC true false -checksource CHECKSOURCE true false -ss C_STACK M m K k M m K k -oss JAVA_STACK M m K k M m K k -ms INITIAL_HEAP M m K k M m K k -mx MAX_HEAP M m K k M m K k -verify VERIFY true false -verifyremote VERIFYREMOTE true false -noverify NOVERIFY true false JAVA_COMPILER -D SYSTEM_PROPERTY prop=value symcjit Windows NT sunwjit Solaris "-debug" "SYSTEM_PROPERTY" "true/false" 32 user.default password.default Java 8-27

132 8-15 Java Perl Perl Perl Perl 8-28 Oracle Application Server

133 8-8 Perl PERLLIB Perl Perl Perl %ORAWEB_HOME%/.../cartx/perl/lib Perl %ORAWEB_HOME%/.../cartx/perl/lib/perlinit.pl Perl Perl Perl Perl Perl Perl Perl Perl Oracle Application Server Manager 8-29

134 "+" JAR EJB 8-9 Web CORBA 8-30 Oracle Application Server

135 8-9 wrks -s JAR JAR JAR JAR.app MyApplication/MyCartridge

136 : SID ID ID CPU : 1/100 : KB 8-11 :[[ ] : : ] 8-32 Oracle Application Server

137 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

138 Oracle Application Server Manager Oracle Application Server Manager Oracle Application Server Oracle Application Server 8-34 Oracle Application Server

139 1. website Oracle Application Server Oracle Application Server : Oracle Application Server HTTP Oracle Application Server Oracle Application Server Manager Application Server Manager

140 HTTP 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 JSP LiveHTML Perl PL/SQL UNIX DLL NT CORBA Enterprise JavaBeans CORBA Java Java JSP HTTML Perl PL/SQL Oracle PL/SQL Oracle Perl Perl Perl CORBA 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 Application Server Database Access Descriptor Database Access Descriptor DAD 6 Database Access Descriptor DAD CORBA a. PL/SQL JServlet JWeb JSP LiveHTML Perl CWeb PL/SQL JServlet JWeb JSP LiveHTML Perl CWeb DAD LiveHTML CWeb b. ECO/Java EJB 9-3

144 EJB ECO/Java 9-27 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 : 9-4 Oracle Application Server

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

146 .app <cartridge>.app Oracle Application Server CWeb C eb C++ CORBA Enterprise JavaBeans ECO/Java JServlet JWeb JSP LiveHTML Perl PL/SQL C++ CORBA EJB ECO/ Java EJB ECO/ Java JServlet JSP JWeb JServlet JSP 9-6 Oracle Application Server

147 C eb CWeb CWeb CWeb myccartridge UNIX /Windows NT.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 JSP JServlet JSP JServlet JSP myjservletcartridge UNIX /Windows NT 9-8 Oracle Application Server

149 URL /myapp/jservlettest Java CLASSPATH CLASSPATH JWeb JWeb JWeb myjwebcartridge UNIX /Windows NT 9-9

150 Java CLASSPATH CLASSPATH URL /myapp/jwebtest LiveHTML LiveHTML LiveHTML mylivehtmlcartridge UNIX /Windows NT 9-10 Oracle Application Server

151 URL LiveHTML LiveHTML LiveHTML : ".." ".." "routines/../lib/" Perl Perl Perl 9-11

152 myperlcartridge UNIX /Windows NT URL Perl Perl Perl : ".." ".." "routines/../lib/" PL/SQL PL/SQL Oracle Application Server

153 9-7 PL/SQL PL/SQL UNIX / Windows NT URL PL/SQL /<appname>/<cartname> PL/SQL PL/SQL ".sql" PL/SQL PL/SQL Oracle Application Server PL/SQL SQL DAD PL/SQL Database Access Descriptor DAD DAD DAD 9-13

154 CORBA 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 CORBA CORBA ECO/Java EJB CORBA ECO/Java EJB ECO/Java 9-14 Oracle Application Server

155 PL/ SQL Perl 2 C JWeb LiveHTML Perl PL/SQL 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. "+" 7. "+" 9-15

156 Oracle Application Server Oracle Application Server / Oracle Application Server

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

158 Oracle Application Server Oracle Application Server

159 URL /myapp/test %ORAWEB_HOME%/test 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/ 9-19

160 Basic_ Oracle Crypt Basic_Oracle &/ 1 '&' ' ' 2 1 IP/ IP IP C C CWeb Oracle Application Server Oracle Application Server

161 CWeb CWeb CWeb 9-3 CWeb CWeb 9-3 CWeb DLL DLL C CWeb 9-21

162 C 9-13 JWeb JWeb Oracle Application Server 9-18 LiveHTML LiveHTML LiveHTML Parameters 2 Oracle Application Server 9-22 Oracle Application Server

163 9-18 LiveHTML Parameters LiveHTML Parameters LiveHTML LiveHTML Parameters LiveHTML 9-14 LiveHTML 9-23

164 . 9-4 LiveHTML LiveHTML LiveHTML SSI Web Application Object LiveHTML LiveHTML LiveHTML 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 hsp hsa asp asa 9-24 Oracle Application Server

165 9-4 LiveHTML Perl Oracle Application Server LiveHTML Perl LiveHTML HTML Perl Perl Perl Perl 1 Perl Perl Perl Perl "/" Perl Perl 2 Oracle Application Server

166 PL/SQL PL/SQL PL/SQL Oracle Application Server 9-18 PL/SQL PL/SQL PL/SQL PL/SQL 9-26 Oracle Application Server

167 ECO/Java EJB 9-5 PL/SQL DAD PL/SQL DAD N/A HTML PL/SQL HTML : PL/SQL Web URI Web URI ECO/Java EJB ECO/Java EJB CORBA 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 9-27

168 ECO/Java EJB 3. "+" 4. "+" 5. "+" 6. CORBA 9-16 / Oracle Application Server Oracle Application Server

169 ECO/Java EJB Oracle Application Server CGI HTML Oracle Application Server Oracle Application Server <scheme>(<realm>) [ {" " "&"} & <scheme>(<realm>)... ] 1 "scheme(realm)" 9-18 Basic(myProject) & IP(buildingOne) 9-29

170 ECO/Java EJB 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" CORBA CORBA 1. Web WelcomeOracle Application Server Manager 9-30 Oracle Application Server

171 ECO/Java EJB 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 3. "+" 4. "+" 5. "+" 6. "+"

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

173 owsapps/ owstat ID Web isp-pc ID 2342: ID 1 ID 9-33

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

175 : wrks PID ID DDDD HH:MM:SS.SSSSSS : appname/cartname Windows NT.dll Solaris.so 9-35

176 9-8 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 1. Web WelcomeOracle Application Server Manager Welcome Oracle Application Server Oracle Application Server

177 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 9-38 Oracle Application Server Manager 1. Web WelcomeOracle Application Server Manager 2. "+" website40oracle Application Server Manager Oracle Application Server HTTP 9-37

178 3. "+" 4. "+" 5. "+" 6. "+" CPU Oracle Application Server

179 : 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

180 Oracle Application Server OAS 1 OAS OAS OAS 9-40 Oracle Application Server

181 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

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

183 Logger DAD DAD DAD 6 Database Access Descriptor DAD Logger : : : : : 0 1 :

184 Oracle Application Server 10-3 : : FS : 10-4 Oracle Application Server

185 DB : DAD 10-3 Logger DAD DB FS LOGSYSMSG : ORAWEB_ADMIN ORAWEB_HOME /private/oas/logs/ wrb.log ,000,000 10MB UNIX : Logger Logger

186 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-1 / / ADP ADP_Spyglass 0xFFFFFFFF 0x00001FFF 0x Oracle Application Server

187 10-1 / / ADP_Netscape ADP_IIS ADP_Netscape_Heartbeat ADP_Spyglass_Heartbeat Dispatcher_Gen Dispatcher_OSD Dispatcher_HB Logger BASIC DIGEST IP DOMAIN BO WRB WRB Inter-Cartridge Exchange 0x x x x a 0x00002FFF 0x x x x00004FFF 0x00008FFF 0x00010FFF 0x00020FFF 0x00040FFF 0x00080FFF 0x x x x x x x00100FFF 0x00200FFF 0x00400FFF 0x00800FFF 0x x x

188 10-1 / / Java NCX Java 0x x x01000FFF 0x04000FFF 0x00004FFF 0x00008FFF 'OR' 0x0000CFFF 7 Logger core init malloc Oracle Application Server

189 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

190 Oracle Application Server logattrib entry_date date usec number Oracle Application Server

191 10-3 logattrib 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

192 : : FS : DB : DAD 10-3 Logger DAD DB FS LOGATTRIB %ORAWEB_ADMIN%/website40/log /private/oas/logs/ attrib.log ,000,000 10MB Oracle Application Server

193 UNIX : Logger Logger Windows : Logger Logger Logger Logger logfile_name.pid PID Logger ID XLF logfile_name.n n attrib.log attrib.log.0 attrib.log.1...attrib.log attrib.log attrib.log Logger 0 %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 10-13

194 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 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 Oracle Application Server

195 10-4 Logxlf 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 Xlfseq logxlf logxlfheader create sequence xlfseq start with 1000 nomaxvalue order; XLFXLF 10-15

196 10-6 XLF Web XLF Web : XLF : XLF XLF CLF XLF xlf.log FS : DB : DAD 10-3 Logger DAD DB FS Oracle Application Server

197 LOGXLF LOGXLFHEADER %ORAWEB_ADMIN%/website40/log /private/oas/logs/ xlf.log ,000,000 10MB 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

198 %ORAWEB_ADMIN%/website40/log /private/oas/logs/ XLF CLF XLF clf clf CLF c-dns cauth-id [clf-date] " " sc-status cs (User-Agent) cs (Referer) clf-date Request-URI URI CLF [dd/mm/yyyy: : : GMT_offset] c-auth-id bytes date time time-taken c-ip s-ip c-dns s-dns : IP IP DNS DNS Oracle Application Server

199 10-6 sc-status sc-comment cs-method cs-protocol cs-uri cs-uri-stem 2 5 1xx: : 2xx: : 3xx: : 4xx: : 5xx: : "101" "200" OK "300" "400" "500" GET POST HTTP URI URI 10-19

200 10-6 cs-uri-query prefix (header) URI Header HTTP prefix c: s: r: cs: sc: XLF XLF Oracle Application Server PL/SQL Toolkit Log Analyzer HTML OAS Oracle Application Server 1. Welcome 1-5 Welcome 2. OAS OAS Oracle Application Server

201 : Node Manager Administration Utility OAS Database Access Descriptor DAD DAD DAD 6-2 DAD 10-21

202 1: Logger Logger Log Analyzer : Logger Log Analyzer 1. Logger Logger 10-8 Logger 2. DAD DAD DAD DBA 3. SYS : Oracle8 catdbsyn.sql Oracle7 LOGGER 4. OK Oracle Application Server

203 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 ORACLE_SID: Oracle Application Server ORACLE_HOME SID ORCL : Oracle Application Server ORACLE_HOME tnsnames.ora 10-23

204 : 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 1. Log Analyzer 2. DAD DBA 3. SYS Log Analyzer 4. OK Oracle Application Server

205 Log Analyzer Log Analyzer 4: PL/SQL : PL/SQL Toolkit Logger DAD DBA 3. SYS 4. OK 5. OAS Manager DAD a. Go to OAS HomeWelcome b. WelcomeOAS Manager c. d

206 e. DB Utilities f. g. DB Browser h. PL/SQL PL/SQL Agent PL/SQL Agent i. DAD DAD : DB UtilitiesPL/SQL DAD : DAD DAD SYS Oracle Application Server

207 Log Analyzer 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-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 10-27

208 Log Analyzer XLF SYSSMSG ATTRIB WelcomeOAS Log Analyzer DAD DAD DAD DAD DBA10-3 Logger DAD Oracle Application Server

209 Log Analyzer XLF UNIX: /ows/admin/website40/log NT: D: ows admin website40 log XLF XLF xlf.log XLF XLF SYSMSG ATTRIB XLF XLF 1. Log Analyzer XLF XLF Log Entries XLF 10 NULL '-' 10-29

210 Log Analyzer XLF Log Entries 10-8 XLF 10-8 XLF Log Entries date time bytes client-ip client-dns server-ip server-dns yyyy-mm-dd : : IP DNS NULL '-' IP Web IP DNS Oracle Application Server

211 Log Analyzer 10-8 XLF Log Entries status 2 5 1xx: : 2xx: : 3xx: : 4xx: : 5xx: : method uri-stem uri-query auth-id GET POST URI URI Next Log Analyzer Log Analyzer System Messages Log Entries 10 NULL '-' 10-31

212 Log Analyzer System Messages Log Entries System Messages Log Entries 10-9 date time wrb component id severity yyyy-mm-dd : : Web Request Broker WRB WRB WRB PL/SQL ID Oracle Application Server

213 Log Analyzer 10-9 mask message WRB Next 10 Log Analyser 1. WelcomeOAS Log Analyzer 4. 4 XLF 1 XLF XLF XLF 10-33

214 Log Analyzer XLF Log Report(s) TOTAL REQUESTS Total Requests Oracle Application Server

215 Log Analyzer Delete : 1. NewModify Add/Modify XLF Report Add/Modify XLF Log Report Add/Modify XLF Report Report Name: 10-35

216 Log Analyzer Report Description: Field Name: Client IP Addres Display: Yes No No DateURLYes Date URL 2 Operation: 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 HTTP DNS Null Total Average Oracle Application Server

217 Log Analyzer Add/Modify Xlf Log Report Url uri_stem uri_query URL Null Total Average Bytes : Bytes = > < Display Yes No Null Total Average Minimum Maximum 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 10-37

218 Log Analyzer Add/Modify Xlf Log Report 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 By 10 minute Comparator Value "*.com" ".com" "*" 0 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 Oracle Application Server

219 Log Analyzer 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 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 10-39

220 Log Analyzer System Message Report(s) System Message Report(s) Logger Submit Field Name: Comparator: < > = '=' Value: Oracle Application Server

221 Log Analyzer 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 0 Submit Report: Submit Report Reset Form System Messages Report Results 10-41

222 Log Analyzer System Messages Reports Results System Messages Reports Results Entry Date Entry Time Wrb Component ID Severity Mask Message yyyy-mm-dd : : Web Request Broker WRB WRB WRB PL/SQL ID WRB Oracle Application Server

223 Log Analyzer Web Web 10 XLF IP 2 1 Modify CONCURRENT USER Report Modify CONCURRENT USER Report Modify CONCURRENT USER report Period DateTime Date: DateFrom To "YYYY-MM-DD" Time: TimeFrom To 2 "HH:MM:SS" 24 08:00:00 23:59:

224 Log Analyzer 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

225 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 10-45

226 Server IP Address HTTP IP " " Server Host Entry Date XLF Entry Time XLF 1. WelcomeOAS Admin Utility Server Node Manager Admin Utility Server Welcome Oracle Application Server

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

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

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

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

231 10-28 Database Sessions Rollback Segments

232 10-30 Database FilesREDO Oracle Application Server

233 1. Tablespace Space Usage

234 Tablespace Free Space Summary Oracle Application Server

235 Oracle Application Server : Oracle Application Server : Logger : : : PL/SQL Log Analyzer : : : OAS Admin Utility : Admin 10-55

236 10-56 Oracle Application Server

237 11 Oracle Application Server SQL : Oracle Application Server Enterprise Edition DTP CORBA OTS/JTS OTS 11-1

238 1 1 Web : Oracle Application Server 11-2 Oracle Application Server

239 : Oracle Application Server CREATE ALTER DDL SQL DDL SQL API API URL 2 Java Transaction Service JTS JTS URL URL URL :

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

241 OTS OTS EJB ECO/Java EJB ECO/Java OTS RM OTS 2 OAS OAS 1 Oracle Application Server

242 11-1 Transaction Transaction Cartridge Cartridge Distributed Transaction Coordinator (DTC) HO (RM) 11-7 RM 1 Distributed Transaction Coordinator DTC DTC RM DTC DTC Oracle8i RM DTC Oracle8i DTC Oracle Application Server

243 RM RM RM RM Oracle7 Oracle8 1 RM DTC RM Oracle OTS HO HO Oracle8 Oracle7 RM Oracle7 HO Oracle8i DTC Oracle7 RM : HO 2 Oracle7 Windows NT Transaction Transaction Cartridge Cartridge Distributed Transaction Coordinator (DTC) HO (RM) 11-7

244 Oracle Application Server Manager RM: DAD DAD DAD 6 Database Access Descriptor DAD DAD 11-9 DAD/ DTC: DAD DTC Distributed Transaction Coordinator HO : DTC Oracle8i DAD 1 Oracle7 HO HO : Oracle Transaction Service Oracle Transaction Service OTS 1. Oracle Transaction ServiceOTS OTS 2. : Oracle Application Server DTC 11-8 Oracle Application Server

245 : RM DAD 3. Oracle Application Server DAD/ RM DAD RM 3 1. RM a. RM Oracle7 Oracle8 Oracle8i Oracle : Oracle Application Server DAD Oracle Application Server DAD db_name db_domain ORACLE_SID db_name db_domain INITxxx.ORA SQLPLUS "select * from global_name" b. Oracle SQL*Net Net8 tnsnames.ora Oracle Application Server RM tnsnames.ora : DTC Oracle Application Server Oracle Home RM DTC tnsnames.ora DTC RM DTC tnsnames.ora 11-9

246 2. Oracle Application Server Manager DAD DAD 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 Oracle Application Server

247 b. DAD 6 Database Access Descriptor DAD DAD DAD RM DAD DAD: DAD: 3. DAD: / : DAD DAD : Oracle7 Oracle8 : Oracle7 OTS HO Oracle7 RM Oracle8i DTC HO HO : RM

248 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 Oracle8i listener.ora HO 11-1 ots_ho HO Oracle Application Server

249 4. RM DAD DAD RM 1 DTC : RM DTC RM OAS Manager Distributed Transaction Coordinator DTC Oracle8i Oracle Application Server DTC 3 : DTC DAD DTC DAD DTC DTC DAD I: 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 Oracle8i 11-13

250 II: 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 Oracle Application Server

251 DTC Net8 Net8 tnsnames.ora listener.oranet8 III: DTC Oracle Application Server Manager DTC 1. Object Transaction Service 2. Object Transaction Service DTC Distributed Transaction Coordinator Distributed Transaction Coordinator 3. Distributed Transaction Coordinator DTC:

252 11-8 DTC: 4. DTC: DTC : DTC ORACLE_SID : DTC Oracle8i ORACLE_SID : DTC myhost.us.oracle.com myhost us.oracle.com myhost : Oracle Application Server DTC Web ORACLE_HOME : DTC Oracle8i : DTC Oracle Application Server DTC Oracle Application Server Net8 TNSNAMES.ORA $ORACLE_HOME/network/ admin $TNS_ADMIN SQLNET.ORA Oracle Application Server

253 11-9 DTC 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 Oracle8i DTC DBA DBA : DTC Oracle8i DTC DBA SYSOPER: "internal" "internal" Windows NT UNIX DAD : RM DAD DAD RM DAD 11-17

254 DAD DAD: DAD : DTC DAD DAD DTC : Oracle8i INITxxx.ORA DTC Oracle8i 5. DTC RM DTC RM/ DAD Server Manager connect system/manager select * from all_db_links : DTC RM DAD DTC DTC Oracle Web Listener Web Request Broker Oracle8i DTC Oracle Application Server ORACLE_HOME 1. Oracle Application Server Oracle Web Listener Web Request Broker Oracle Web Listener WRB 4. Oracle Application Server Oracle Application Server

255 5. Oracle Application Server tnsnames.ora tnsnames.ora : Oracle8i tnsnames.ora Oracle Application Server 8. Oracle Application Server Manager Oracle Application Server 9. Oracle Application Server DAD 10. DTC HO RM DAD Oracle7 Oracle8 DTC HO DTC RM HO DTC Oracle8i 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 Oracle8 Oracle8 tnsnames.ora DTC Oracle8i RM RM Oracle7 DTC RM 11-19

256 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 Oracle8i Oracle8_portnumber: DTC Oracle8i 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)) HO Oracle8 $ORACLE_HOME HO SID_NAME tnsnames.ora HO CONNECT DATA Oracle Application Server

257 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 = myhost-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.1.6)) (SID_DESC=(SID_NAME=test_ho)(ORACLE_HOME=/private/oracle/product/8.1.6r) (PROGRAM=hsots)) )

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

259 Tx : DAD : RM 1 : DAD DAD 11-23

260 URI PL/SQL C 2 PL/SQL C Web EJB JCORBA Web Web URI URI URI : URI World Wide Web URL URI PL/SQL start PL/SQL PL/SQL /hr/emp/start URI /hr/emp/start PL/SQL start start Oracle Application Server

261 startcommit rollback URI PL/SQL PL/SQL C PL/SQL PL/ SQL URI URI Web URI URI /hr/emp /hr/emp/start

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

263 PL/SQL PL/SQL PL/SQL PL/SQL PL/SQL C C URI URI Tx : DAD : RM 1 5. Web Web Web

264 11-12 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 URI URI Oracle Application Server URL Oracle Application Server

265 OTS OTS OTS Web URI URI URI URI 2 URI /hr/emp URI /hr/emp/updateemp /hr/emp/removeemp /hr/emp/addemp URI '*' /hr/emp/emp.* : Oracle Application Server EJB JCORBA GUI (begin) Oracle Application Server EJB ECO/Java CORBA DAD DTC OTS OTS 1. RM RM Oracle Enterprise Manager SQLPLUS 11-29

266 OTS OTS 2. Oracle8i DTC DTC 3. Oracle Application Server 4.0 Oracle Application Server Manager Oracle Application Server Oracle Application Server Manager Oracle Application Server OTS 1. Oracle Application Server Manager TXserver1 2. RM DTC RM DTC Oracle Enterprise Manager SQLPLUS JCORBA Oracle Application Server

267 OTS 3. Oracle Application Server 4.0 Oracle Application Server Manager Oracle Application ServerOracle Application Server Oracle Application Server DTC DTC Tx DTC 1. Distributed Transaction Coordinator DTC

268 OTS DTC 2. DTC DTC DTC OK DTC DTC DTC DTC Oracle Application Server

269 OTS DTC 11-33