Oracle OLAP Server R6.3 for Windows NT Oracle OLAP Server R6.3 for Sun SPARC Solaris 1
1. 4 1.1....4 1.2....4 2. Windows NT 5 2.1....5 2.1.1. ID... 5 2.1.2. (Windows NT )... 9 2.2....10 2.2.1. Oracle OLAP Server R6.3 for Windows NT... 10 2.2.2. (Windows NT)... 20 3. Sun SPARC Solaris 23 3.1....23 3.1.1.... 23 3.1.2. Oracle... 23 3.1.3.... 24 3.1.4. (Solaris)... 25 3.2....26 3.2.1. Oracle OLAP Server R6.3 for Sun SPARC Solaris 26 3.2.2.... 37 3.3. Solaris...38 3.3.1. Instance Manager... 38 4. Web 41 4.1. Internet Information Server 4.0 (IIS4.0)...41 4.1.1. Instance Manager... 41 4.1.2. Microsoft... 41 4.2. Oracle Application Server 4.x...49 2
4.2.1. Instance Manager... 49 4.2.2. Oracle Application Server... 49 4.2.3. MIME... 56 4.2.4. wrcfreg... 57 3
1. 1.1. Oracle Express Web Agent Web Oracle OLAP Server for Windows NT 6.3 Oracle OLAP Server for Sun SPARC Solaris 6.3 Web Oracle Express Web 6.3 1.2. [Windows NT ] Windows NT Workstation (with SP5) 4.00.1381 Oracle OLAP Server R6.3 for Windows NT 6.3.0.1.0 Oracle Application Server R4.0.8.1 for Windows NT 4.0.8.1.0 Microsoft Internet Information Server 4.0 [Sun SPARC Solaris ] Sun SPARC Solaris 2.7 Oracle OLAP Server R6.3 for Sun SPARC Solaris 6.3.0.1.0 4
2. Windows NT Oracle OLAP Server R6.3 OLAP Server Oracle Universal Installer Oracle Universal Installer Oracle OLAP Server / 2.1. Oracle Universal Installer 2.1.1. ID Oracle OLAP Server ID Administrator << >> 5
[ ] 1 Windows NT Workstation 2 6
[ ] [ ] 3 [ ] [ ] OK 4 7
[ ] ( ) 5 [ ] ( ) 6 [ ] 8
2.1.2. (Windows NT ) CLASSPATH Oracle OLAP Server NT Server CLASSPATH Windows NT Server 256 CLATHPASS CLASSPATH NT NT 9
2.2. Oracle OLAP Server R6.3 OLAP Server Oracle Universal Installer Oracle Universal Installer Oracle OLAP Server / 2.2.1. Oracle OLAP Server R6.3 for Windows NT Oracle OLAP Server R6.3 for Windows NT CD-ROM CD-ROM ( F ) F: setup.exe 7 Oracle Universal Installer 10
Oracle (C ) OUIHome C: OraHome1 Oracle OUIHome815 D: OraHome815 8 Oracle 11
Oracle OLAP Server 6.3.0.1 Oracle OLAP Server Oracle Express Web Agent Oracle Express Instance Manager Oracle OLAP Server Express Instance Manager 6.3.0.1 Express Instance Manager Express Instance Manager Oracle Enterprise Manager Express Instance Manager Oracle Enterprise Manager Oracle ( OEMHome) Oracle Express Web Listener Components 6.3.0.1 Oracle OLAP Server Express Web Agent Server Web Express Web Listener Components Web Oracle SNAPI Client 6.3.0.1 Oracle Express Oracle OLAP Server Oracle OLAP Server SNAPI 12
9 Oracle OLAP Server 6.3.0.1 Oracle OLAP Server R6.3 13
Oracle OLAP Server 6.3.0.1 ( ) Oracle OLAP Server Express Shell Command Express Initial Session Express SQL OCI Express External Call Express Communication Architecture XCA Oracle Express Instance Manager Oracle Express Web Agent Oracle Express Relational Access Manager Oracle SNAPI Server Oracle Express Web Agent Oracle Express Relational Access Manager Express Express Test 14
10 15
11 1 12 2 16
13 3 14 4 17
[ ] 15 15 18
16 19
2.2.2. (Windows NT) Oracle OLAP Server Oracle OLAP Server R6.3 Oracle8i Oracle Oracle OLAP Server 6.3.0.1 Oracle OLAP Server6.3.0.1 17 Oracle 20
R6.2 6.2.0.1 Oracle OLAP Server R6.3 for Windows NT 6.3.0.1 R6.2 6.2.0.1 R6.3 i. R6.2 ii. R6.2 Oracle DEFAULT_HOME iii. R6.3 Oracle ( OraHome815) iv. ServerObjectID(UUID) XCAPortNumber (R6.2 R6.3 ) v. Oracle R6.3 Oracle R6.2(6.2.0.1) Oracle R6.2 Oracle R6.3 OCI.DLL 18 R6.3 R6.2(6.2.0.1) %R6.2 Oracle % bin oci.dll 8.0.4.3.4 Oracle OLAP Server6.2.0.1 Net8 8.0.4 OCI.DLL R6.3(6.3.0.1) %R6.3 Oracle % bin oci.dll 8.1.4.0.0 Oracle OLAP Server6.3.0.1 Net8 8.1.5 21
( 40 ) Windows NT DBA ( ) DBA / R6.3 DBA / 3 / / DBA OESDBA/OESDBA OESinit/OESinit OESguest/OESguest < > / < > Express Instance Manager DBA NT 19 22
3. Sun SPARC Solaris Solaris Oracle OLAP Server R6.3 for Sun SPARC Solaris OLAP Server Oracle Universal Installer Oracle Universal Installer Oracle Oracle OLAP Server / OS 3.1. Oracle Universal Installer 3.1.1. oracle xsagent DBA oesdba Express oesinit oesguest 1 Oracle OLAP Server for Sun SPARC Solaris 6.3 3.1.2. Oracle Oracle Oracle Oracle Oracle OLAP Server R6.3 Oracle /u01/app/olap/products/oes6301 Oracle OLAP Server R6.3 Oracle 23
3.1.3. ORACLE_HOME OLAP_HOME LD_LIBRARY_PATH Oracle (3.1.2 ) /u01/app/olap/products/oes6301 $ORACLE_HOME/olap $ORACLE_HOME/lib $OLAP_HOME/lib ($ORACLE_HOME/olap/lib) 2 Oracle OLAP Server C.cshrc # @(#)cshrc 1.11 89/11/29 SMI umask 022 setenv ORACLE_HOME /u01/app/olap/products/oes6301 setenv OLAP_HOME $ORACLE_HOME/olap setenv LD_LIBRARY_PATH $ORACLE_HOME/lib: $OLAP_HOME/lib setenv LANG ja setenv LINES 24 set path=(/bin /usr/bin /usr/ccs/bin /usr/ucb /etc /usr/local/bin /opt/acrobat4/bin.) 20.cshrc 24
3.1.4. (Solaris) 1 1 UNIX Oracle OLAP Server (Express ) 1 6.3 Express R6.3(6.3.0.1) Express (6.2.0.1) (OLAP Server ) 6.3 OLAP Server 6.3 OLAP Server 1 1 ( ) Express UNIX Windows NT UNIX Oracle OLAP Server OLAP Server (OLAP Server ) Express xsdaemon xsagent xsauthn xsauthz 25
3.2. Oracle OLAP Server R6.3 for Sun SPARC Solaris OLAP Server Oracle Universal Installer Oracle Universal Installer Oracle Oracle OLAP Server / 3.2.1. Oracle OLAP Server R6.3 for Sun SPARC Solaris Oracle OLAP Server R6.3 for Sun SPARC Solaris CD-ROM CD-ROM /runinstaller 21 Oracle Universal Installer 26
Oracle 3.1.2 Oracle /u01/app/olap/products/oes6301 22 Oracle 27
Oracle OLAP Server 6.3.0.1 Oracle OLAP Server Oracle Express Web Agent Oracle Express Instance Manager Oracle OLAP Server Express Instance Manager 6.3.0.1 Express Instance Manager Express Instance Manager Oracle Enterprise Manager Express Instance Manager Oracle Enterprise Manager Oracle ( OEMHome) Oracle Express Web Listener Components 6.3.0.1 Oracle OLAP Server Express Web Agent Server Web Express Web Listener Components Web Oracle SNAPI Client 6.3.0.1 UNIX ( ) Oracle OLAP Server SNAPI 28
23 24 Oracle OLAP Server 6.3.0.1 Oracle OLAP Server R6.3 29
Oracle OLAP Server 6.3.0.1 ( ) Oracle OLAP Server Express Shell Command Express Initial Session Express SQL OCI Express External Call Express Communication Architecture XCA Oracle Express Instance Manager Oracle Express Web Agent Oracle Express Relational Access Manager Oracle SNAPI Server Oracle Express Web Agent Oracle Express Relational Access Manager Express Express Test 30
25 31
UNIX Oracle OLAP Server (Express ) 1 6.3 Express xsdaemon xsagent xsauthn xsauthz R6.3(6.3.0.1) Express (6.2.0.1) Oracle OLAP Server 6.3 OLAP Server 6.3 OLAP Server 6.3 1 1 OLAP Server No 26 Yes oes.key $OLAP_HOME oes.key ( ) R6.2(6.2.0.1) Oracle $ORACLE_HOME=/u01/app/products/oes6201/ $OLAP_HOME=/u01/app/products/oes6201//olap oes.key 32
27 1 28 2 33
29 3 30 4 34
[ ] 31 31 35
100% 32 root $ORACLE_HOME/oes6301/root.sh 32 root.sh $ORACLE_HOME/oes6301/root.sh OK 33 36
3.2.2. Oracle Type Translator relink LD_LIBRARY_PATH Oracle Type Translator OTT relink 34 relink Installer Oracle OLAP Server Oracle Type Translator Oracle C Oracle C C++ 34 relink R6.2 6.2.0.1 Express 1 1 Oracle OLAP Server R6.3 6.3 OLAP Server R6.2 6.2.0.1 R6.2 R6.3 R6.3 R6.2 R6.3 i. ServerObjectID(UUID) ii. XCAPortNumber iii. RoListenPortNumber(EndPoint) 37
3.3. Solaris Web OS Instance Manager UNIX Web Oracle Express Web 6.3 OS Oracle OLAP Server for Sun SPARC Solaris 6.3 OS 3.3.1. Instance Manager Instance Manager UNIX Security AcceptACLs DefaultMode FileOwner Oracle OLAP Server for Windows NT Security Oracle OLAP Server for Sun SPARC Solaris Security 35 Instance Manger 38
3.3.1.1. FileOwner DBA CLIENT DBA 3 FileOwner DBA 3.3.1.2. AcceptACLs AcceptACLs ACL OLAP Server OS ACL AcceptACLs YES OLAP Server ACL OS ACL AcceptACLs NO OLAP Server ACL YES OLAP Server ACL NO OLAP Server ACL 4 AcceptACLs 39
3.3.1.3. DefaultMode DefaultMode ( ) DefaultMode ( ) 000 40
4. Web Oracle Express Web Agent OLAP Server Web IIS4.0 OAS4.x Web Web Oracle Express Web, 6.3 4.1. Internet Information Server 4.0 (IIS4.0) 4.1.1. Instance Manager Internt Information Server Web Oracle OLAP Server Instance Manager I/O Management ServerDBPath Web Agent 4.1.2. Microsoft 4.1.2.1. Express Web Agent Web 5 /oew-install/ /ows-bin/ 5 %ORACLE_HOME% olap oes630 owa630 D: OraHome815 olap oes630 owa630 %ORACLE_HOME% olap oes630 tools D: OraHome815 olap oes630 tools Web CGI Express Web Publisher Express Web Publisher /owp/ D: OraHome815 olap oes630 owp630 41
oew-install IIS4.0 [ ] Microsoft Internet Information Server IIS Web 36 Microsoft 42
Web - 37 43
( ) oew-install 1. 38 2. 3 39 44
3. (R) (S) CGI ( (E) oew-install (R) (S) ows-bin (R) (S) ( (E) 40 45
4.1.2.2. MIME Web (CSV ) Netscape Communicator SmartUpdate MIME 4 MIME application/csv MIME application/java-archive csv jar JAR 6 MIME IIS4.0 MIME [ ] Microsoft Web 41 (MIME ) 46
Web MIME HTTP 42 Web (HTTP ) 47
43 4 MIME ( 44 45) 43 MIME 43 MIME 44 MIME 45 Netscape Communicator SmartUpdate MIME 48
4.2. Oracle Application Server 4.x OAS Oracle Application Server(OAS) Oracle Application Server(OAS) CGI CGI Web 4.2.1. Instance Manager Oracle Application Server Web Oracle OLAP Server Instance Manager I/O Management ServerDBPath Web Agent 4.2.2. Oracle Application Server /oew-install/ /owp/ Windows NT %ORACLE_HOME% olap oes630 owa630 Solaris %ORACLE_HOME%/olap/oes630/owa630/ Windows NT %ORACLE_HOME% olap oes630 owp630 Solaris %ORACLE_HOME%/olap/oes630/owp630/ 7 OAS 49
4.2.2.1. Windows NT Solaris 46 Oracle Application Server 50
47 51
48 7 OAS oew-install owp 48 (HTTP www) 52
49 Express Web Agent "Express RPC Web Agent" "Express RPC Web Agent Cartridge" 53
50 1( ) 51 2(CWeb ) 54
52 3( ) 55
4.2.3. MIME Oracle Application Server MIME Web (CSV ) Netscape Communicator SmartUpdate MIME 6 MIME MIME application/csv application/java-archive 8 MIME csv jar JAR Oracle Application Server application/java-archive jar 49 HTTP ( www ) MIME 8 MIME [ ] 53 MIME 56
4.2.4. wrcfreg 4.2.2.2 wrcfreg UNIX 1. Oracle Application Server 2. UNIX wrcfreg 3. wrcfreg -s [listener] %ORACLE_HOME/olap/oes630/owa630/oowa4xro.app wrcfreg -s www /home/oracle/olap/oes630/owa630/oowa4xro.app 4. OWS-09100: 5. Express Web Publisher 6. wrcfreg -s [listener] %ORACLE_HOME/olap/oes630/owp630/owp4x.app wrcfreg -s www /home/oracle/olap/oes630/owp630/owp4x.app OWS-09100: Windows NT 1. Oracle Application Server 2. Windows NT MS-DOS wrcfreg 3. wrcfreg -s [listener] %ORACLE_HOME olap oes630 owa630 oowa4x.app wrcfreg -s www %ORACLE_HOME olap oes630 owa630 oowa4x.app 4. OWS-09100: 5. Express Web Publisher 6. wrcfreg -s [listener] %ORACLE_HOME olap oes630 owp630 owpa4x.app wrcfreg -s www c: orant olap oes630 owp630 owp4x.app 7. OWS-09100: 57