1
Warehouse Builder Installation Requirements

Warehouse Builder Overview

Oracle9i Warehouse Builder is an integrated system for the design, implementation, and management of an enterprise-wide data warehouse or data mart. Warehouse Builder provides the framework to create your data warehouse and populate it from your existing Oracle products as well as other non-Oracle data sources. You can use Warehouse Builder to create a logical model of your data warehouse and generate code to extract, transform, and load the data into your data warehouse.

Warehouse Builder Installation Components

A complete, working Oracle9i Warehouse Builder environment includes:

Table 1-1

Software	Components
Oracle 8.1.7/ 9i (Required)	Oracle Agent TNS Listener
Oracle9i Application Server (Optional)	Portal HTTP Server XML Developer Kit
Warehouse Builder (Required)	Warehouse Builder Client Repository Assistant Runtime Assistant Browser Assistant
Oracle Enterprise Manager (OEM) 2.2 (Optional)	Oracle Management Server (OMS) Client Console WEB Console (optional)
Oracle Workflow (OWF) 2.6 (Optional)	Workflow Client (Designer) WEB Monitor Workflow Server Queue Listener

Warehouse Builder Environment

You can install these components in any order, using the Oracle Universal Installer (OUI). Here are a few recommendations:

• Install all products using the instructions in the respective product installation guides. This installation guide provides general guidelines only for installing software other than Warehouse Builder.

• All references to a system, port, Oracle_Home, and SID must be tailored to your installation requirements.

Install the Oracle 8.1.7/ 9i Database

You need the Oracle 8.1.7/9i database to install the Warehouse Builder Repository, the Warehouse Builder Runtime Repository, and optionally, the Warehouse Builder Browser, the OEM Repository, and OWF tables.

Install Oracle9i Application Server (Oracle9iAS)

When you install Oracle9iAS, you can also install Oracle Portal, the XML Developer Kit, and an HTTP server. These components are required to run the Warehouse Builder Browser that can be used to view your metadata and run metadata web reports.

Install the Warehouse Builder Client

The Warehouse Builder client software includes the client side repositories and a web reporting tool. During the install, you can create the Warehouse Builder Repository, the Warehouse Builder Runtime Repository, and Warehouse Builder Browser tables in your database.

Install Oracle Enterprise Manager and Oracle Workflow

You can use Oracle Enterprise Manager (OEM) to schedule jobs and Oracle Workflow (OWF) to manage job dependencies. The OEM Change Management Pack is also used for life cycle management of a data warehouse.

Installation Requirements

You must observe the following requirements to install the Warehouse Builder Repository and the Warehouse Builder Runtime Objects.

Table 1-2 Warehouse Builder Installation Requirements

Installation Type	Hard Disk (MB)	RAM (MB)
Typical Repository Server	100	256Foot 1

1 Actual memory requirements may be higher for production systems, depending on the size of the repository and the number of users.

Memory requirements increase depending on the functions being performed and the number of users connected. You must also make sure you have ample swap space.