Skip Headers
Oracle® Warehouse Builder Installation and Configuration Guide
10
g
Release 1 (10.1)
Part Number B12150-02
Home
Book List
Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Purpose
Audience
How This Guide Is Organized
Documentation Accessibility
New in 10
g
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 10
g
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 Oracle9
i
Release 2 (9.2.x) or Oracle8
i
Release 3 (8.1.7.4.x)
For Oracle Database 10
g
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 10
g
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 10
g
Release 1 (10.1) Design Repository
Importing Design Metadata to Warehouse Builder 10
g
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