Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose

Audience

How This Guide Is Organized

New in Release 9.2.0.3

Added in Release 9.0.4

Conventions

Related Publications

Documentation Accessibility

Contacting Oracle

1 Warehouse Builder Installation Requirements

1.1 Quick Steps for Installing Oracle9i Warehouse Builder

1.2 Overview of Warehouse Builder Installation Components

1.2.1 About Oracle9i Warehouse Builder

1.2.2 Warehouse Builder Installation Components

1.3 Hardware Requirements

1.4 Operating Environment Software Requirements

1.5 Software Requirements for Warehouse Builder Components

1.6 Certified Software

1.7 Coexistence: ORACLE_HOME Considerations

1.8 Pre-Installation Tasks

1.8.1 General Checklist

1.8.2 Setting the Locale

1.8.3 Setting Environment Variables (UNIX Only)

1.8.4 Creating UNIX Accounts and Groups (UNIX Only)

1.8.5 Information Needed During Installation

1.9 About Oracle Universal Installer

1.9.1 Inventory Directory

1.9.2 Starting Oracle Universal Installer

2 Installing Oracle9i Warehouse Builder Components

2.1 Overview of Warehouse Builder Components and Installation

2.1.1 Warehouse Builder Architectural Components

2.1.2 Components Installed by the Oracle Universal Installer

2.1.3 Before You Begin, You Need Access to a SYSDBA User

2.2 Step 1. Perform the OWB Design Time Install using Oracle Universal Installer

2.2.1 For UNIX Only, Run the root.sh Script

2.3 Step 2. Install the Design Repository using the Repository Assistant

2.4 Step 3. Enable Warehouse Builder Design Browser Client

2.5 Step 4. Perform the OWB Server Side Install using Oracle Universal Installer

2.5.1 For UNIX Only, Run the root.sh Script

2.6 Step 5. Install Runtime Objects Using the Runtime Assistant

2.6.1 Installing a Runtime Repository and Runtime Access User

2.6.2 Installing a Warehouse Builder Target Schema

2.7 Step 6. Configure the Web Browser for Design and Runtime Audit Browsers

2.7.1 Add "LOCALHOST" to Your Web Browser Proxy Server Bypass List

2.7.2 Configure the Cache Management in Your Web Browser

2.7.3 Configure Warehouse Builder with a Net Service Name

2.7.4 For Netscape on UNIX: Set the Permission for displayURL.sh

2.8 Step 7. (Optional) Integrate the Warehouse Builder Browsers into Oracle9iAS

2.8.1 Why Integrate the Design and Runtime Audit Browsers with Oracle9iAS?

2.8.2 Install the Warehouse Builder Browser with the Browser Assistant

2.8.3 Configure Warehouse Builder Design Browser

2.8.4 Configure the Warehouse Builder Runtime Audit Browser

2.9 Step 8. (Optional) Install Third-Party Name and Address Data

3 Upgrading to Release 9.2.0.3 and Migrating Data

3.1 Overview

3.2 Installing Warehouse Builder in a Separate ORACLE_HOME

3.3 Exporting Metadata from Your Existing Warehouse Builder Repository

3.4 Importing Design Metadata

3.5 Upgrading Target Schema and Audit Data from Release 9.0.4

3.6 Migrating Data to Your New Target Schemas

3.6.1 Option 1. Regenerate Database Objects Using the Warehouse Builder Interface

3.6.2 Option 2. Export and Import Database Objects in the Oracle Database Server

3.6.3 Option 3. Create Synonyms for Original Objects in the New Target Schema

3.7 Deploying Your Mappings to the New Target Schemas

3.8 Updating Mapping Configuration to Benefit from New Features

3.9 Optional: Deinstalling the Old Version of Warehouse Builder

4 Deinstalling Warehouse Builder Components

4.1 Step 1. Deinstall Design and Runtime Audit Browsers from Oracle9iAS

4.2 Step 2. Deinstall Warehouse Builder Target Schema Objects

4.3 Step 3. Deinstall Warehouse Builder Runtime Repository Objects

4.4 Step 4. Deinstall Warehouse Builder Design Repository Objects

4.5 Step 5. Deinstall Warehouse Builder or Remaining Oracle Software

A Preparing an Oracle 8.1.7 or 9i Database

A.1 Parameters for the Design Repository Database Instance

A.2 Parameters for the Runtime Repository Database Instance

A.3 Parameters for the Oracle9iAS Database (Optional)

B Installing Oracle Enterprise Manager and Oracle Workflow

B.1 Configuring Oracle Enterprise Manager

B.1.1 Step 1: Create the Enterprise Manager Repository

B.1.2 Step 2: Create a Windows User

B.1.3 Step 3: Configure Preferred Credentials

B.1.4 Enterprise Manager Intelligent Agent Database Compatibility Matrix

B.1.5 Configuring OEM for Oracle9i Internet Developer Suite Release 1

B.2 Installing Oracle Workflow

B.2.1 Install the Oracle Workflow Server

B.2.2 Install the Workflow Client (Optional)

C Upgrading Metadata with the MDL File Upgrade Utility

C.0.1 About the MDL File Upgrade Utility

C.0.2 Using the MDL File Upgrade Utility

C.0.3 Running the MDL File Upgrade Utility from the Command Line

D Diagnostics and Debugging

D.1 Debugging

D.1.1 Log File Locations

D.1.2 Oracle9i Warehouse Builder is Frozen, or Hanging

D.1.3 Additional Error Logging for Errors and Other Unexpected Behavior

D.1.4 Checking Java Virtual Machine (JVM)

D.1.5 Managing the Runtime Platform Service

D.1.6 Detecting Database Server Issues When Installing on HP-UX

D.2 Diagnostics

Index