Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Structure

Conventions

Related Publications

1 Overview

1.1 System Requirements

1.2 Overview of WebDB Architecture

1.2.1 WebDB Listener

1.2.2 Using Other Web Servers

2 Installing WebDB 2.2 on Windows NT

2.1 Prerequisites

2.2 WebDB on Windows NT Install

2.2.1 Preliminary Steps

2.2.2 WebDB on Windows NT Typical Install

2.2.3 WebDB on Windows NT Custom Install

2.2.3.1 Oracle WebDB Custom Install on Windows NT

2.2.3.2 WebDB Listener Custom Install on Windows NT

2.3 Deinstalling WebDB on Windows NT

3 Installing WebDB 2.2 on Solaris

3.1 Prerequisites

3.2 WebDB on Solaris Install

3.3 Installing WebDB Packages on Solaris

3.4 Installing WebDB Listener on Solaris

3.4.1 Running the WebDB Listener as setuid root

3.5 Deinstalling WebDB on Solaris

4 Oracle WebDB Migration

4.1 Migrating from Oracle WebDB 2.1 to 2.2

4.1.1 Upgrading Oracle Web Application (OWA) from Version 4.0.7 to 4.0.8

4.1.2 Running the WebDB Upgrade Script from Windows NT or Solaris

4.2 Migrating WebDB 2.1 Sites to Version 2.2

4.2.1 Running the Site Migration Script from SQL*Plus

4.3 Dropping a WebDB Site

4.4 Dropping Users Who Create Sites

5 Configuring the WebDB Listener and PL/SQL Gateway

5.1 Access From Within WebDB

5.2 Access from Outside WebDB

5.3 Starting and Stopping the WebDB Listener

5.3.1 Windows NT

5.3.2 Solaris

5.4 Configuring Oracle WebDB Listener

5.5 Configuring Oracle WebDB PL/SQL Gateway

5.6 Using the WebDB Listener to Run Multiple Virtual Hosts

5.7 Accessing Static Files with the WebDB Listener

5.8 Running PL/SQL Applications Using the WebDB Listener

5.9 Manually Editing the Listener and Gateway Configuration Settings

5.9.1 Editing WebDB Gateway Settings (wdbsvr.app)

5.9.2 Editing WebDB Listener Settings (wdbsvr.cfg)

6 Configuring Variables and General Configuration

6.1 Environment Variable Check List

6.2 Creating a TNS Names Alias

6.3 Changing the Language for a WebDB Site

6.4 Date and Time Configuration

6.5 Viewing Arabic Characters

7 Integrating interMedia Text in WebDB Site Builder

7.1 Prerequisites

7.2 Setting Up Your Environment for interMedia Text

7.2.0.1 LISTENER.ORA

7.2.0.2 TNSNAMES.ORA

7.2.0.3 SQLNET.ORA

7.3 Defining DEFAULT_LEXER Values

7.4 Creating interMedia Text Indexes

7.5 Updating interMedia Text Indexes

7.6 Dropping interMedia Text Indexes

8 Setting Up the WebDB CGI Executable and WebDB Cartridge to OAS

8.1 Setting up the WebDB CGI Executable

8.1.1 Manually Installing and Configuring the WebDB CGI

8.2 Configuring the WebDB Cartridge with OAS

8.2.1 Prerequisites

8.2.2 Manually Installing the WebDB Cartridge

8.2.3 Adding the WebDB Cartridge to OAS

9 Troubleshooting

9.1 Troubleshooting List

9.1.1 Browser fails to retrieve information

9.1.2 WebDB Listener doesn't start with new hostname

9.1.3 Error log

9.1.4 Uploading documents to a Web site

9.1.5 Setting the MAX_ENABLED_ROLES parameter

9.1.6 Setting the MAX_OPEN_CURSORS parameter

9.1.7 Tablespace sizes

9.1.8 Shared pool size

9.1.9 Creating interMedia Text Indexes

Index