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

Planning Your Configuration

Hardware and Software Installation Requirements

Client Requirements

2 Installing Oracle9i Warehouse Builder Components

Install the Warehouse Builder Repository

Warehouse Builder Repository Installation Wizard (New Schema)

Install Warehouse Builder Runtime Libraries

Overview

Warehouse Builder Runtime Installation Wizard

Install the Warehouse Builder Browser

Warehouse Builder Browser Assistant

Configure Oracle Warehouse Builder

Configure Warehouse Builder Browser

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

Upgrading from a Previous Version of Warehouse Builder

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 Utility Using Command Line

Step 4. Import the metadata into the new Warehouse Builder Repository

Upgrading Mappings

Difference Between MDL File Upgrade and Warehouse Upgrade

4 Installing Oracle Enterprise Manager and Oracle Workflow

Configuring Oracle Enterprise Manager

Step 1: Create the Enterprise Manager Repository

Step 2: Create 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 Repository Objects

Deinstall Warehouse Builder Client

A Preparing an 8.1.7 or 9i Database

For the Repository Database Instance

For the Runtime Repository (Warehouse) Database Instance

Index