Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle Discoverer 3i Viewer Edition

1.1 Introduction

1.2 Oracle Discoverer 3i Viewer Edition in context

1.3 The n- tiered architecture of Oracle Discoverer 3i Viewer Edition

1.3.1 First tier - the Client

1.3.2 Second tier - the HTTP Server

1.3.2.1 What is a Servlet?

1.3.2.2 What is a Servlet Engine?

1.3.2.3 HTTP Server Components

1.3.3 Third tier - the Discoverer Application Server

1.3.3.1 Discoverer Application Server Components

1.3.4 Fourth tier - the database

1.3.5 Discoverer 3i Viewer Components and Hardware

1.3.5.1 The HTTP Server

1.3.5.2 The Discoverer Application Server(s)

1.3.5.3 The Master Discoverer Application Server

1.4 How Oracle Discoverer 3i Viewer Edition Works

1.4.1 The Oracle Discoverer 3i Viewer Edition process

1.4.2 Oracle Discoverer 3i Viewer Edition Architecture

1.4.3 Invoking Oracle Discoverer 3i Viewer Edition

1.4.4 Processing the http request

1.4.4.1 Application and Presentation Logic

1.4.5 Scalability and load balancing

2 Installing Oracle Discoverer 3i Viewer Edition

2.1 Hardware and Software Requirements

2.1.1 Client hardware requirements

2.1.2 Server hardware requirements

2.1.2.1 Server memory requirements

2.1.3 Software requirements

2.1.3.1 Client Web Browsers

2.1.3.2 HTTP Servers supported by Oracle Discoverer 3i Viewer Edition

2.1.3.3 Additional environment information required

2.2 Planning the Discoverer Server Configuration

2.3 Installing Discoverer 3i Server

2.3.1 Installing Discoverer 3i Server and Servlet Software

2.3.1.1 Web Server and Servlet Prerequisites

2.3.1.2 Suggested Installation path

2.3.1.3 Installing Discoverer 3i Server Distributed on Multiple Machines

2.3.1.4 Installing Oracle Discoverer 3i Viewer Edition Component and Master Server on a Single Machine

2.3.1.5 Custom Installation

2.3.2 The Installed Directories

2.3.2.1 The Executables

2.3.3 Removing Discoverer Server Components

2.3.4 Additional Discoverer Server configuration tasks

2.3.4.1 Editing the Discoverer Server Preferences

2.3.4.2 Editing the tnsnames.ora Files

2.3.4.3 Registering Server Components

2.3.4.4 Oracle Discoverer 3i Viewer Edition .XML File Configuration

2.3.5 Common Configuration

2.3.5.1 Naming preferences

2.3.5.2 Common configuration for web servers

2.3.5.3 Common configuration for servlet engines

2.3.5.4 Information required by the Java Virtual Machine(JVM)

2.3.6 Configuring Apache Web Server and Servlet Engine

2.3.6.1 Defining a directory alias for an Apache web server

2.3.6.2 Editing zone.properties file of Apache JServe

2.3.6.3 Editing jserv.properties file of JServe

2.3.6.4 Running JServe

2.3.7 Configuring Netscape Enterprise Server 4.0 and Servlet Engine

2.3.7.1 Defining a directory alias

2.3.7.2 Checking the directory alias

2.3.7.3 Configure NES servlet engine

2.3.7.4 Editing the servlets.properties configuration file

2.3.7.5 Editing the rules.properties configuration file

2.3.7.6 Edit the jvm12.conf configuration file

2.3.7.7 Edit the start-jre configuration file

2.3.7.8 Running the NES 4.0 servlet

2.3.8 Configuring JRun Servlet Engine

2.3.8.1 Web servers supported by JRun

2.3.8.2 Defining a directory alias under Apache 1.3.9

2.3.8.3 Defining a directory alias under Netscape Enterprise Server 4.0

2.3.8.4 Defining a directory alias under IIS 4.0

2.3.8.5 Checking the directory alias under IIS

2.3.8.6 Defining a directory alias under PWS 4.0

2.3.8.7 Checking the Directory Alias for PWS 4.0 Web Server

2.3.8.8 Editing the Java Service Manager configuration file for JRun Servlet

2.3.8.9 Editing the servlets.properties configuration file for the JRun Servlet

2.3.8.10 Running the JRun Servlet

2.3.9 Configuring ServletExec 2.2c Servlet

2.3.9.1 Editing the servlets.properties configuration file

2.3.9.2 Editing the rules.properties configuration file

2.3.9.3 Editing the Classpath.pref file

2.3.9.4 Running the Servlet

2.3.10 Configuring Oracle Application Server

2.3.10.1 Unpacking disco3iv.jar

2.3.10.2 Setting the Listener Properties

2.3.10.3 Defining a Directory Alias

2.3.10.4 Creating an Application

2.3.10.5 Configuring the Application

2.3.10.6 Configure the Cartridge

2.3.10.7 Configuring the Application Environment

2.3.10.8 Configuring the Java Environment

2.3.10.9 Starting the Servlet

2.3.11 Setting up a secure link using HTTPS

2.3.12 Upgrading from Discoverer Viewer Version 3.1

3 Maintaining and Supporting Discoverer 3i Application Server

3.1 Using Discoverer's NT Service

3.1.1 Seeing Service Errors

3.2 Seeing Registered Discoverer Server Components

3.3 Editing the End User Preferences

3.4 Registering and Unregistering components

3.4.1 Registering and Unregistering from the Windows Program Groups

3.4.2 Registering and Unregistering from the Command Line

3.4.2.1 To Register the Preferences and Session with the OAD

3.4.2.2 To Unregister components from the OAD

3.5 Shutting Down

3.5.1 Shutting Down Individual Servers

3.5.1.1 Shutting Down Individual Servers Gradually

3.5.1.2 Shutting Down Individual Servers Immediately

3.5.2 Shutting Down the Entire Discoverer 3i System

3.5.2.1 Shutting Down the Discoverer 3i System Gradually

3.5.2.2 Shutting Down the Discoverer 3i System Immediately

3.6 Adding and Removing Servers

3.6.1 Adding a Server

3.6.2 To Permanently Remove a Server

3.7 How to Run the Locator on Another Machine

3.8 Frequently Asked Questions

4 Accessing Oracle Discoverer 3i Viewer Edition From Other Web Applications

4.1 Using Parameters in URLs

4.1.1 Specifying username, database

4.1.2 Specifying display of the Applications User Checkbox in Connect Dialog

4.1.3 Specifying a workbook in a URL:

4.1.4 Specifying a worksheet

4.1.5 Specifying worksheet parameters

4.1.6 Specifying a page number

5 Customizing Oracle Discoverer 3i Viewer Edition

5.1 Using Oracle Discoverer 3i Viewer Edition for customized web applications

5.1.1 Steps to Generate the html needed to build a specific Discoverer Application

5.1.1.1 Step 1 Browser sends URL

5.1.1.2 Step 2 XML generation

5.1.1.3 Step 3 Apply XSL

5.1.1.4 Step 4 Generate HTML

5.2 Customization Examples

5.2.1 Files needed for customization

5.2.2 Quick Customization

5.2.2.1 Quick customization attributes

5.2.2.2 Quick customization steps

5.2.2.3 Example of editing the style.xls file

5.2.3 Full Customization

5.2.3.1 Background

5.2.3.2 Prerequisites

5.2.3.3 File Structure

5.2.3.4 Servlet Programming Interface

5.2.3.5 Customizing Look and Feel - XML/XSL Example

5.2.4 Video Stores Demo - an example of an alternative user interface

5.2.4.1 What is installed

5.2.4.2 Set up steps

5.2.4.3 Set up Web Server

5.2.4.4 Run the Video Stores demo

5.2.4.5 Modify the video.xsl file

5.2.5 Customization Summary

A Appendix

A.1 NT Registry Settings for Oracle Applications Users