Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose

Audience

How This Manual Is Organized

Related Publications

Contacting Oracle

1 Warehouse Builder Installation Requirements

Warehouse Builder Overview

Warehouse Builder Installation Components

Installation Requirements

2 Configuring Oracle9i Warehouse Builder

Install the Warehouse Builder Repository

Warehouse Builder Repository Installation Wizard

Install Warehouse Builder Runtime Objects

Overview

Warehouse Builder Runtime Installation Wizard

Install the Warehouse Builder Browser

Warehouse Builder Browser Assistant

Configure Warehouse Builder Browser

3 Upgrading Metadata from Warehouse Builder 2.x to Oracle9i Warehouse Builder

Overview

Step 1. Preparation: Export Metadata from Your Existing Warehouse Builder Repository

Step 2. Install Warehouse Builder in a Separate Directory

Step 3. Run the MDL File Upgrade Utility

Run the MDL File Upgrade Wizard

Warnings and Error Messages

Run the MDL File Upgrade Utility Using Command Line

Step 4. Import Metadata into the New Warehouse Builder Repository

Upgrading Mappings

4 Installing Oracle Enterprise Manager and Oracle Workflow

Configuring Oracle Enterprise Manager

Step 1: Create the Enterprise Manager Repository

Step 2: Create a Windows NT User

Step 3: Configure Preferred Credentials

Step 4: Configure Enterprise Manager Preferences within Warehouse Builder

Enterprise Manager Intelligent Agent Database Compatibility Matrix

Installing Oracle Workflow

Install the Oracle Workflow Server

Step 1: Edit the database init.ora parameter file

Step 2: Create a Database Access Descriptor (DAD) for the Oracle Workflow Schema

Step 3: Install Workflow Server

Step 4: Verify Your Base URL

Step 5: Set Up the Workflow Monitor

Step 6: Set Up HTML Help

Install the Workflow Client

Apply a Patch to Enterprise Manager 2.2

Apply a Patch to Oracle Workflow

Installing Warehouse Builder Workflow Queue Listener

On Windows NT

On UNIX

5 Deinstalling Warehouse Builder Components

Overview

Deinstall Warehouse Builder Browser Objects

Deinstall Warehouse Builder Repository Objects

Deinstall Warehouse Builder Runtime Objects

A Preparing an 8.1.7 or 9i Database

Parameters for the Repository Database Instance

Parameters for the Runtime Database Instance

Index