Contents

Title and Copyright Information

Preface

• Purpose
• Audience
• How This Guide Is Organized
• Documentation Accessibility
• New in 10g Release 1 (10.1)
• Conventions
• Related Publications
• Contacting Oracle

1 Warehouse Builder Installation Requirements

• Quick Steps for Installing Warehouse Builder
• Hardware Requirements
• Software Requirements
  • Operating System Information
    • Supported Operating System Platforms
    • UNIX Operating Systems
    • Microsoft Windows Operating Systems
  • Required Products
    • Oracle Database (Required)
    • Oracle Warehouse Builder 10g Release 1 (10.1) Software (Required)
    • Oracle Application Server (Optional)
    • Oracle Enterprise Manager and Oracle Workflow (Optional)
    • Name and Address Adapter and Data Libraries (Optional)
• Coexistence: ORACLE_HOME Considerations
• Pre-Installation Checklist
• About Oracle Universal Installer
  • Inventory Directory
  • Starting Oracle Universal Installer
    • For Windows Users
    • For UNIX Users
    • Running Oracle Universal Installer

2 Installing Warehouse Builder

• Overview of Warehouse Builder Architecture and Components
  • Warehouse Builder Product Architecture
  • Typical Installation Scenarios
    • Microsoft Windows Server and Optional Clients
    • Consultant Profile
    • UNIX Server and Microsoft Windows Clients
  • Components Installed by Oracle Universal Installer
  • Before You Begin, You Need Access to a SYSDBA User
• Install Warehouse Builder on the Target Schema Host
• Install the Design Repository Using the Repository Assistant
• Install Runtime Objects Using the Runtime Assistant
  • Installing a Runtime Repository and Runtime Access User
  • Installing a Warehouse Builder Target Schema
• Configure the Design and Runtime Audit Browser Environments
  • Enable the Client Version of the Design Browser
    • For Oracle9i Release 2 (9.2.x) or Oracle8i Release 3 (8.1.7.4.x)
    • For Oracle Database 10g Release 1 (10.1)
    • Before Starting the Client Version of the Design Browser
  • Configure Web Browser Settings on Each Computer that Will Run the Warehouse Builder Browsers
    • Add "LOCALHOST" to Your Web Browser Proxy Server Bypass List
    • Configure the Cache Management in Your Web Browser
    • Configure Warehouse Builder with a Net Service Name
    • Start the Client Versions of the Design and Runtime Audit Browsers
  • (Optional) Integrate with Oracle Application Server
    • Why Integrate Warehouse Builder Browsers with Application Server?
    • Install Browsers into Oracle Application Server with the Browser Assistant
    • Configure Warehouse Builder Design Browser
    • Configure the Warehouse Builder Runtime Audit Browser
    • Start Application Server Versions of Design and Runtime Audit Browsers
• (Optional) Install Third-Party Name and Address Data

3 Upgrading to 10g Release 1 (10.1) and Migrating Data

• Installing Warehouse Builder in a Separate ORACLE_HOME
• Upgrading or Migrating Your Oracle Database Environment
  • Full Database Export/Import if Moving to a New Database Instance
  • Database Migration Utility if Keeping the Same Database Instance
  • Partial Database Export/Import for a Selective Migration
    • Migrating Design Metadata with Partial Database Export
    • Migrating the Runtime Environment
• Upgrading Design Metadata
  • Upgrading Design Metadata from Warehouse Builder 9.0.3.x or Earlier
    • Exporting Design Metadata from a Prior Release of Warehouse Builder
    • Creating a New Warehouse Builder 10g Release 1 (10.1) Design Repository
    • Importing Design Metadata to Warehouse Builder 10g Release 1 (10.1)
  • Upgrading Design Metadata from Warehouse Builder 9.0.4.x or 9.2.x
    • Automatic Upgrade Script for Warehouse Builder Design Metadata
• Upgrading Runtime Data
  • Upgrading Runtime Data from Warehouse Builder 9.0.3.x or Earlier
    • Option 1. Regenerate Database Objects Using Warehouse Builder
    • Option 2. Export and Import Database Objects in the Oracle Database Server
    • Option 3. Create Synonyms for Original Objects in the New Target Schema
  • Upgrading Runtime Data from Warehouse Builder 9.0.4.x or 9.2.x
    • Upgrading Audit Data from Warehouse Builder 9.0.4.x or 9.2.x
    • Copying Flat Files and External Directories to Your New Database Instance
• Deploying Your Mappings to the New Target Schemas
• Updating Mapping Configuration to Benefit from New Features
• Optional: Deinstalling the Old Version of Warehouse Builder

4 Deinstalling Warehouse Builder Components

• Step 1. Deinstall Design and Runtime Audit Browsers from Oracle Application Server
• Step 2. Deinstall Warehouse Builder Target Schema Objects
• Step 3. Deinstall Warehouse Builder Runtime Repository Objects
• Step 4. Deinstall Warehouse Builder Design Repository Objects
• Step 5. Deinstall Oracle Warehouse Builder or Remaining Oracle Software

A Preparing an Oracle Database

• Parameters for the Design Repository Database Instance
• Parameters for the Runtime Repository Database Instance
  • Configuring the Target Data File Path for Flat File Targets
• Parameters for the Oracle Application Server Database (Optional)

B Mounting CD-ROMs

• Mounting CD-ROMs on AIX
• Mounting CD-ROMs on HP-UX
• Mounting CD-ROMs on Linux
• Mounting CD-ROMs on Solaris
• Mounting CD-ROMs on Tru64 UNIX

C Installing Oracle Enterprise Manager and Oracle Workflow

• Configuring Oracle Enterprise Manager
  • Creating the Enterprise Manager Repository
  • Creating a Windows User
  • Configuring Preferred Credentials
  • Configuring Enterprise Manager for the Oracle Developer Suite
• Installing Oracle Workflow
  • Installing the Oracle Workflow Server
  • Installing the Workflow Client (Optional)

D Upgrading Metadata with the MDL File Upgrade Utility

• About the MDL File Upgrade Utility
  • Using the MDL File Upgrade Utility
    • Upgrading Repository Objects from Previous Versions
    • Using the MDL File Upgrade Wizard
    • Checking for Warnings and Error Messages
  • Running the MDL File Upgrade Utility from the Command-Line

E Diagnostics and Debugging

• Debugging
  • Log File Locations
  • Oracle Warehouse Builder is Frozen, or Hanging
  • Additional Error Logging for Errors and Other Unexpected Behavior
  • Checking Java Virtual Machine (JVM)
  • Managing the Runtime Platform Service
  • Detecting Database Server Issues When Installing on HP-UX
• Diagnostics

F Warehouse Builder Supported Languages

Index