Index

A B C D E F G H I J L M N O P Q R S T U V W

Numerics

07_DICTIONARY_ACCESSIBILITY parameter

Design Repository, A.1

A

accessibility in Oracle documentation, Preface

accounts

SYS, for Runtime Repository, 2.4.1

SYS, for Target Schema, 2.4.2

SYS, for the Design Repository, 2.3

SYS, REMOTE_LOGIN_PASSWORDFILE parameter, A.1, A.1, A.2

adding

"localhost" to your Web browser proxy server bypass list, 2.5.2.1

database access descriptors (DAD), 2.5.1, 2.5.1.1

administration

resource plans for runtime usage, A.2

advanced queues

UTL_FILE_DIR parameter, A.2

advanced Warehouse Builder users

installation steps for, 1.1

aggregating

PGA_AGGREGATE_TARGET parameter, A.2

Americans with Disabilities Act (ADA) compliance, Preface

AQ_TM_PROCESSES parameter

Runtime Repository, A.2

architecture

overview of Warehouse Builder, 2.1

assistants

Browser Assistant, running, 2.5.3.2

Browser Assistant, starting, 2.1.3

log file locations, E.1.1

Repository Assistant, running, 2.3

Repository Assistant, starting, 2.1.3

Runtime Assistant, running, 2.4

Runtime Assistant, starting, 2.1.3

audit data

migrating runtime environment using Partial Database Export/Import, 3.2.3.2

B

boldface text in this manual, Preface

books

accessibility, Preface

for Warehouse Builder, Preface

brackets in this manual, Preface

Browser Assistant

installation instructions, 2.5.3.2

integrating Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3

log file location, E.1.1

starting Browser Assistant, 2.1.3

browsers

adding "localhost" to your Web browser proxy server bypass list, 2.5.2.1

configuring cache management, 2.5.2.2

Design Browser, about, 1.3.2.2

integrating Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3

integrating with Oracle Application Server, Oracle Database parameters for, A.3

Net Service Name, configuring, 2.5.2.3

OC4J instance, starting, 2.1.3

OC4J instance, stopping, 2.1.3

Runtime Audit Browser, about, 1.3.2.2

starting Design Browser, 2.1.3

starting Runtime Audit Browser, 2.1.3

business areas

upgrading to collections, D.1.1.1

C

CD-ROMs

mounting on HP-UX, B.2

mounting on Linux, B.3

mounting on Solaris, B.4

mounting on Tru64 UNIX, B.5

checklist

pre-installation checklist, Warehouse Builder, 1.5

CLASSPATH environment variable

character length, 1.5

client install

instructions, 2.2

clients

starting Warehouse Builder Client, 2.1.3

collections

upgrading from business areas, D.1.1.1

command-line utilities

upgrading metadata, D.1.2

COMPATIBLE parameter

Design Repository, A.1

Runtime Repository, A.2

components

overview of the Warehouse Builder installation, 2.1

required and optional components for Warehouse Builder environment, 1.3.2

configuring

adding "localhost" to your Web browser proxy server bypass list, 2.5.2.1

cache management in your Web browser, 2.5.2.2

database configuration warning in the Repository Assistant, 2.3

database configuration warning in the Runtime Assistant, 2.4.1

Design Browser client, enabling, 2.5

Design Browser with Oracle Application Server, 2.5.3.3

Net Service Name for Runtime Audit Browser, 2.5.2.3, 2.5.3.4.5

Oracle Database for installation, A

Oracle Enterprise Manager, C.1

owblient.bat file for memory, E.2

Repository Assistant, running, 2.3

Runtime Audit Browser with Oracle Application Server, 2.5.3.4

updating mapping configuration for new features, 3.6

connecting

database, errors connecting to, E.2

Design Repository, error, E.2

REMOTE_LOGIN_PASSWORDFILE parameter, A.1

connectors

privileges for, 2.4.2

contacting Oracle, Preface

conventions used in this manual, Preface

Create Any Directory privilege, 2.4.2

Create Public Database Link privilege, 2.3

creating

connectors, privileges for, 2.4.2

data sources, 2.5.3.4.3

data sources, Create Data Source page, 2.5.3.4.3

data sources, EJB location, 2.5.3.4.3

data sources, JDBC driver, 2.5.3.4.3

data sources, JDBC URL, 2.5.3.4.3

data sources, location, 2.5.3.4.3

data sources, transactional (XA) location, 2.5.3.4.3

OC4J instance, 2.5.3.4.1

reports in Oracle Portal on Warehouse Builder metadata, 2.5.3.1

D

DAD See Database Access Descriptors (DAD)

data

migrating, 3

migrating data to the new runtime environment, 3.4.1

data libraries

Name and Address, unavailable for, E.2

data quality

installing Name and Address, 2.6

Data Source Class

defining, 2.5.3.4.3

data sources

Create Data Source page, 2.5.3.4.3

creating, 2.5.3.4.3

Data Source Class, 2.5.3.4.3

EJB location, 2.5.3.4.3

JDBC driver, 2.5.3.4.3

JDBC URL, 2.5.3.4.3

location, 2.5.3.4.3

transactional (XA) location, 2.5.3.4.3

database access descriptors (DAD)

adding, to enable Design Browser client, 2.5.1, 2.5.1.1

database configuration warning

Repository Assistant, in the, 2.3

Runtime Assistant, in the, 2.4.1, 2.4.2

Target Schema, 2.4.2

database links

privileges created for, 2.3

Database Migration Utility

upgrading Oracle Database, 3.2.2

DB_BLOCK_SIZE parameter

Design Repository, A.1

Runtime Repository, A.2

DB_CACHE_SIZE parameter

Design Repository, A.1

Runtime Repository, A.2

DB_FILE_MULTIPLE_BLOCK_READ_COUNT parameter

Runtime Repository, A.2

DB_WRITER_PROCESSES parameter

Runtime Repository, A.2

DBWR_IO_SLAVES parameter

Runtime Repository, A.2

debugging, E

defining

Data Source Class, 2.5.3.4.3

data sources, Create Data Source page, 2.5.3.4.3

data sources, EJB location, 2.5.3.4.3

data sources, JDBC driver, 2.5.3.4.3

data sources, JDBC URL, 2.5.3.4.3

data sources, location, 2.5.3.4.3

data sources, transactional (XA) location, 2.5.3.4.3

deinstalling

Design Browser from Oracle Application Server, 4.1

Design Repository, 4.4

Oracle software, 4.5

Runtime Audit Browser from Oracle Application Server, 4.1

Runtime Repository, 4.3

Target Schema, 4.2

Warehouse Builder, 4, 4.5

deleting See deinstalling

Design Browser

about, 1.3.2.2

client, enabling, 2.5

deinstalling from Oracle Application Server, 4.1

integrating with Oracle Application Server, 2.5.3.3

integrating with Oracle Application Server, install instance, 1.3.2.3

starting Design Browser, 2.1.3

design clients

typical Warehouse Builder installation scenarios, 2.1.2

design metadata

migrating, using Partial Database Export/Import, 3.2.3.1

upgrade log file, 3.3.2.1

Design Repository

connecting error, E.2

deinstalling, 4.4

enabled roles, E.2

languages, 2.3

Oracle Database parameters for, A.1

Repository Assistant, 2.3

SYSDBA privileges, 2.3

tablespaces, 2.3

diagnostics, E

disabilities, documentation accessibility, Preface

disk space

hardware requirements for Warehouse Builder, 1.2

DISK_ASYNCH_IO parameter

Runtime Repository, A.2

-Dlimit parameter

owbclient.bat file, memory threshold, E.2

Drop Any Directory privilege, 2.4.2

dropping

connectors, privileges for, 2.4.2

DTupg904to10g

design metadata upgrade script, 3.3.2.1

DTupg92to10g

design metadata upgrade script, 3.3.2.1

E

ellipses in this manual, Preface

ENQUEUE_RESOURCES parameter

Runtime Repository, A.2

environment variables

character length for Warehouse Builder, 1.5

errors

database configuration warning in the Repository Assistant, 2.3

exporting

design metadata with Warehouse Builder Metadata Export, 3.3.1.1

external directories

copying to your new database instance, 3.2.3.2.2

external processes

upgrading to user defined processes, D.1.1.1

external tables

what to do when migrating, 3.2.3.2.2

F

files

log file locations, E.1.1

flat files

as targets, UTL_FILE_DIR parameter, A.2, A.2.1

copying to your new database instance, 3.4.2.2

Full Database Export/Import

upgrading Oracle Database, 3.2.1

G

gen_ext_dirs.sql script, 3.2.3.2.2

GLOBAL_DBNAME parameter

Net Service Name, E.2

GLOBAL_NAMES parameter

Oracle Application Server, A.3

guides

accessibility, Preface

for Warehouse Builder, Preface

H

hardware requirements for Warehouse Builder, 1.2

HTTP Server

and Oracle Database, 1.3.2.1

installing, 1.3.2.1

HTTP servers

starting, 2.5.1.1

I

impact analysis reports

materialized views, errors for, E.2

importing

design metadata with Warehouse Builder Metadata Import, 3.3.1.3

ENQUEUE_RESOURCES parameter for large MDL imports, A.2

log file, Target Schema, 3.2.3.2.3

Target Schema when migrating, 3.2.3.2.3

init.ora file

JAVA_POOL_SIZE parameter, 2.4

MAX_ENABLED_ROLES parameter, E.2

UTL_FILE_DIR parameter, A.2.1

installing

before you begin, SYSDBA privileges, 2.1.4

client install, 2.2

Design and Runtime Audit Browsers into Oracle Application Server, 2.5.3

detailed instructions for installing Warehouse Builder, 2

diagnostics and debugging, E

JServer option, Oracle Database, E.2

Name and Address, 2.6

Oracle Enterprise Manager, C

Oracle Workflow, C

Runtime Access User, 2.4.1

Runtime Assistant, 2.4

Runtime Repository, 2.4.1

server install, 2.2

Warehouse Builder Browser with Browser Assistant, 2.5.3.2

Warehouse Builder into a Real Application Cluster (RAC) environment, 2.4.1

Warehouse Builder when upgrading, 3.1

Warehouse Builder, detailed instructions, 2

installing Warehouse Builder

advanced users, steps for, 1.1

hardware requirements, 1.2

pre-installation tasks, 1.5

quick steps for, 1.1

requirements for, 1

software requirements, 1.3

typical installation scenarios, 2.1.2

integrating

Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3

Design Browser with Oracle Application Server, 2.5.3.3

Oracle Database parameters for integrating the Design and Runtime Audit Browsers with Oracle Application Server, A.3

Runtime Audit Browser with Oracle Application Server, 2.5.3.4

Internet Explorer

adding "localhost" to your IE proxy server bypass list, 2.5.2.1

cache management, configuring, 2.5.2.2

inventory directory

about Oracle Universal Installer (OUI), 1.6.1

invoking See starting

I/O

DB_WRITER_PROCESSES parameter, A.2

DBWR_IO_SLAVES parameter, A.2

DISK_ASYNCH_IO parameter, A.2

ISO IDs

for supported languages, F

italicized text in this manual, Preface

italicized unicode text in this manual, Preface

J

Java Virtual Machine (JVM)

verifying and reinstalling JVM, E.1.4

JAVA_POOL_SIZE parameter, 2.4

Runtime Repository, A.2

JDBC

EJB location, 2.5.3.4.3, 2.5.3.4.3

JDBC driver, 2.5.3.4.3, 2.5.3.4.3

JDBC URL, 2.5.3.4.3, 2.5.3.4.3

location, 2.5.3.4.3, 2.5.3.4.3

transactional (XA) location, 2.5.3.4.3, 2.5.3.4.3

JOB_QUEUE_PROCESSES parameter

Runtime Repository, A.2

Jserver, 2.4

JAVA_POOL_SIZE parameter, 2.4

JServer option

Runtime Assistant, for the, E.2

L

languages

Design Repository, 2.3

international standard IDs, F

Repository Assistant, 2.3

LARGE_POOL_SIZE parameter

Runtime Repository, A.2

launching See starting

LD_LIBRARY_PATH environment variable

character length, 1.5

lineage reports

materialized views, errors for, E.2

listener.ora file

GLOBAL_DBNAME parameter, E.2

LoadJava error

Runtime Assistant, E.2

local RTP service

starting local RTP service, 2.1.3

stopping local RTP service, 2.1.3

localhost

adding "localhost" to your Web browser proxy server bypass list, 2.5.2.1

LOCK_SGA parameter

Design Repository, A.1

log files

locations of log files, E.1.1

log.txt design metadata upgrade log, 3.3.2.1

Target Schema import log, 3.2.3.2.3

Warehouse Builder Metadata Import log file, 3.3.1.3

LOG_BUFFER parameter

Runtime Repository, A.2

LOG_CHECKPOINT_TIMEOUT parameter

Runtime Repository, A.2

log.txt design metadata upgrade log, 3.3.2.1

M

manuals

accessibility, Preface

for Warehouse Builder, Preface

mappings

deploying mappings to the upgraded Target Schema, 3.5

updating configuration for new features, 3.6

upgrading, D.1.1.1

materialized views

lineage and impact analysis reports, errors, E.2

QUERY_REWRITE_ENABLED parameter, A.2

MAX_ENABLED_ROLES parameter, E.2

MDL

exporting design metadata, 3.3.1.1

importing design metadata, 3.3.1.3

starting MDL File Upgrade Utility, 2.1.3

MDL File Upgrade Utility

about, D.1

memory

errors during batch operation, E.2

hardware requirements for Warehouse Builder, 1.2

metadata

creating reports in Oracle Portal on Warehouse Builder metadata, 2.5.3.1

ENQUEUE_RESOURCES parameter for large MDL imports, A.2

migrating design metadata using Partial Database Export/Import, 3.2.3.1

starting MDL File Upgrade Utility, 2.1.3

upgrading metadata, 3

upgrading with command-line utilities, D.1.2

Metadata Export

design metadata, 3.3.1.1

Metadata Import

design metadata, 3.3.1.3

log file, 3.3.1.3

Metadata Loader

starting MDL File Upgrade Utility, 2.1.3

Metadata Loader (MDL)

ENQUEUE_RESOURCES parameter, A.2

File Upgrade Utility, about, D.1

File Upgrade Wizard, D.1.1.2

MetaLink, Preface

migrating

data and metadata, 3

data by creating synonyms for original objects in the new Target Schema, 3.4.1.3

data by exporting and importing database objects in Oracle Database server, 3.4.1.2

data by regenerating database objects in the Warehouse Builder user interface, 3.4.1.1

data to the new runtime environment, 3.4.1

Database Migration Utility, 3.2.2

deploying mappings to the upgraded Target Schema, 3.5

external directories, 3.2.3.2.2

flat files, copying to your new database instance, 3.4.2.2

Partial Database Export/Import, 3.2.3

Partial Database Export/Import, design metadata, 3.2.3.1

Partial Database Export/Import, runtime environment, 3.2.3.2

Target Schema, importing, 3.2.3.2.3

MLS

defining languages in the Repository Assistant, 2.3

ISO IDs for supported languages, F

-mx parameter

owbclient.bat file, virtual memory, E.2

N

Name and Address

data libraries, 2.6

installing, 2.6

operator, about, 2.6

regional libraries unavailable, E.2

vendors, 2.6

Name and Address cleansing

Warehouse Builder requirements, 1.3.2.5

Name and Address Server

installation instructions, 2.4

Runtime Assistant, 2.4.1

Net Manager

Net Service Name, configuring, 2.5.2.3

Net Service Name

configuring, 2.5.2.3

configuring for Runtime Audit Browser, 2.5.3.4.5

SERVICE_NAME parameter, E.2

Netscape

adding "localhost" to your Netscape proxy server bypass list, 2.5.2.1

cache management, configuring, 2.5.2.2

O

OC4J

creating the OC4J instance, 2.5.3.4.1

starting the OC4J instance, 2.1.3

stopping the OC4J instance, 2.1.3

OMB Plus

starting OMB Plus, 2.1.3

OPEN_CURSORS parameter, A.2

Design Repository, A.1

Oracle Application Server, A.3

OPEN_LINK parameter

Oracle Application Server, A.3

operating systems

UNIX, Warehouse Builder requirements for, 1.3.1.2

Warehouse Builder compatible with, 1.3.1.1

Windows, Warehouse Builder requirements for, 1.3.1.3

OPTIMIZER_MODE parameter

Runtime Repository, A.2

Oracle

accessibility, Preface

contacting, Preface

Oracle Application Server

Data Source Class, defining, 2.5.3.4.3

deinstalling Design Browser, 4.1

deinstalling Runtime Audit Browser, 4.1

integrating Design Browser with, 2.5.3.3

integrating Runtime Audit Browser with, 2.5.3.4

integrating the Design and Runtime Audit Browsers with, 2.5.3

Oracle Application Server 10g Release 1 (9.0.4), binding the Runtime Audit Browser application to the schema, 2.5.3.4.3

Oracle Database parameters for, A.3

Oracle9iApplication Server Release 2 (9.0.2), binding the Runtime Audit Browser to the schema, 2.5.3.4.3

Warehouse Builder requirements, 1.3.2.3

Oracle Containers for Java

See OC4J

Oracle Database

Database Migration Utility, 3.2.2

Design Repository, parameters for, A.1

Full Database Export/Import, 3.2.1

HTTP Server, 1.3.2.1

installation requirements, A

JServer option, E.2

keeping the same database instance, 3.2.2

migrating, 3.2

moving to a new database instance, 3.2.1

Oracle Application Server, parameters for, A.3

Oracle Home directory, multiple product coexistence, 1.4

Partial Database Export/Import, 3.2.3

Runtime Repository, parameters for, A.2

selective migration, 3.2.3

server issues on HP-UX, E.1.6

upgrading, 3.2

user, and Warehouse Builder user, 2.2

versions compatible with Warehouse Builder, 3.2

Warehouse Builder requirements, 1.3.2.1

Oracle Enterprise Manager

configuring, C.1

installing, C

tablespace setting for Runtime Repository, E.2

Warehouse Builder requirements, 1.3.2.4

Oracle Export

audit data, migrating, 3.2.3.2

design metadata, migrating, 3.2.3.1

Oracle Home directory

multiple product coexistence, 1.4

Oracle HTTP servers

starting, 2.5.1.1

Oracle Import

audit data, migrating, 3.2.3.2

design metadata, migrating, 3.2.3.1

Target Schema, migrating, 3.2.3.2.3

Oracle Metabase

starting OMB Plus, 2.1.3

Oracle Portal

creating reports on Warehouse Builder metadata, 2.5.3.1

integrating the Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3.1

Oracle Universal Installer (OUI)

about OUI, 1.6

client install, 2.2

deinstalling other Oracle software, 4.5

deinstalling Warehouse Builder, 4.5

inventory directory, 1.6.1

server install, 2.2

starting OUI, 1.6.2

Oracle Workflow

installing, C

UTL_FILE_DIR parameter, Advanced Queueing system, A.2

Warehouse Builder requirements, 1.3.2.4

ORACLE_HOME

considerations for upgrading Warehouse Builder, 3.1

multiple product coexistence, 1.4

Oracle9i Application Server

See Oracle Application Server

Oracle9i Application Server Release 2 (9.0.2)

binding the Runtime Audit Browser application to the schema, 2.5.3.4.3

P

page file size

hardware requirements for Warehouse Builder, 1.2

PARALLEL_ADAPTIVE_MULTI_USER parameter

Runtime Repository, A.2

parameters

JAVA_POOL_SIZE, 2.4

Oracle Database parameters for Oracle Application Server, A.3

Oracle Database parameters for the Design Repository, A.1

Oracle Database parameters for the Runtime Repository, A.2

Oracle Database, preparing, A

Partial Database Export/Import

upgrading Oracle Database, 3.2.3

PATH environment variable

character length, 1.5

performance

-Dlimit parameter, E.2

PGA_AGGREGATE_TARGET parameter

Runtime Repository, A.2

platforms

operating systems supported by Warehouse Builder, 1.3.1.1

typical Warehouse Builder installation scenarios, 2.1.2

Warehouse Builder requirements for UNIX, 1.3.1.2

Warehouse Builder requirements for Windows, 1.3.1.3

PL/SQL

optimization, PLSQL_OPTIMIZER_LEVEL parameter, A.2

UTL_FILE_DIR parameter for file input and output, A.2

PLSQL_OPTIMIZER_LEVEL parameter

Runtime Repository, A.2

portlet provider

provider URL, 2.5.3.4.4

portlets

integrating the Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3.1

portlet provider, registering, 2.5.3.4.4

pre-installation

pre-installation tasks for Warehouse Builder, 1.5

requirements for Warehouse Builder, 1

privileges

Create Any Directory, Drop Any Directory, 2.4.2

Create Public Database Link, 2.3

REMOTE_LOGIN_PASSWORDFILE parameter, A.1

roles created for the Runtime Repository, 2.4.1

SYS user, checking privileges, E.2

SYSDBA, before you begin, 2.1.4

SYSDBA, Design Repository, 2.3

SYSDBA, Runtime Repository, 2.4.1

SYSDBA, Target Schema, 2.4.2

WB_RT_MAPAUDIT, 3.2.3.2.1

proxy servers

adding "localhost" to your Web browser proxy server bypass list, 2.5.2.1

public database links

privileges created for, 2.3

Q

QUERY_REWRITE_ENABLED parameter

Runtime Repository, for generating materialized views, A.2

quick steps

for installing Warehouse Builder, 1.1

R

RAC See Real Application Clusters (RAC)

RAM

hardware requirements for Warehouse Builder, 1.2

Real Application Clusters (RAC)

installing Warehouse Builder into a RAC environment, 2.4.1

registering

portlet provider, 2.5.3.4.4

remote execution

Runtime Assistant, 2.4

REMOTE_LOGIN_PASSWORDFILE parameter

Design Repository, A.1, A.1

Runtime Repository, A.2

removing

See deinstalling

reporting

Oracle Portal reports on Warehouse Builder metadata, 2.5.3.1

Repository Assistant

database configuration warning, 2.3

deinstalling Design Repository, 4.4

installation instructions, 2.3

languages, 2.3

log file location, E.1.1

starting Repository Assistant, 2.1.3

SYSDBA privileges, 2.3

tablespaces, 2.3

requirements

JServer option, Oracle Database, E.2

Oracle Database parameters, A

SYSDBA privileges, 2.1.4

requirements for Warehouse Builder

hardware requirements, 1.2

installing Warehouse Builder, 1

operating systems, 1.3.1.1

pre-installation tasks, 1.5

software products, 1.3.2

software requirements, 1.3

UNIX, 1.3.1.2

Windows, 1.3.1.3

RESOURCE_MANAGER_PLAN parameter

Runtime Repository, A.2

roles

created for the Runtime Repository, 2.4.1

RTP See Runtime Platform Service

runtime

JOB_QUEUE_PROCESSES parameter, A.2

resource usages, PLSQL_OPTIMIZER_LEVEL parameter, A.2

Runtime Assistant, installing runtime objects with, 2.4

starting local RTP service, 2.1.3

stopping local RTP service, 2.1.3

upgrading runtime data, 3.4

Runtime Access Schema

installation instructions, 2.4

Runtime Assistant, 2.4.1

Runtime Access User

installing, 2.4.1

Runtime Assistant

database configuration warning, 2.4.1, 2.4.2

deinstalling Runtime Repository, 4.3

deinstalling Target Schema, 4.2

installation instructions, 2.4

LoadJava error, E.2

local database server, E.2

log file location, E.1.1

remote execution, 2.4

roles created by, 2.4.1

Runtime Access Schema, 2.4.1

starting Runtime Assistant, 2.1.3

tablespaces, Runtime Repository, 2.4.1

tablespaces, Target Schema, 2.4.2

Target Schema, 2.4.1

users installed, owbrt_sys, 2.4

Runtime Audit Browser

about, 1.3.2.2

Create Database Link, Net Service Name, 2.5.3.4.5

creating the OC4J instance, 2.5.3.4.1

deinstalling from Oracle Application Server, 4.1

integrating with Oracle Application Server, 2.5.3.4

integrating with Oracle Application Server 10g Release 1 (9.0.4), 2.5.3.4.3

integrating with Oracle Application Server, install instance, 1.3.2.3

integrating with Oracle9i Application Server Release 2 (9.0.2), 2.5.3.4.3

starting Runtime Audit Browser, 2.1.3

runtime data

upgrading runtime data, 3.4

runtime environment

migrating, using Partial Database Export/Import, 3.2.3.2

runtime platform

starting local RTP service, 2.1.3

stopping local RTP service, 2.1.3

Runtime Platform Service

log file location, E.1.1

managing and checking status, E.1.5

starting local RTP service, 2.1.3

stopping local RTP service, 2.1.3

Runtime Repository

database configuration warning, 2.4.1

deinstalling, 4.3

enabled roles, E.2

installation instructions, 2.4

installing, 2.4.1

local database server, E.2

materialized views, insufficient space, E.2

Oracle Database parameters for, A.2

SYSDBA privileges, 2.4.1, 2.4.2

tablespaces, 2.4.1

S

schemas

Runtime Assistant, created by, 2.4.1

Target Schema, about, 2.4.2

scripting

starting OMB Plus, 2.1.3

scripts

DTupg904to10g, 3.3.2.1

DTupg92to10g, 3.3.2.1

gen_ext_dirs.sql, 3.2.3.2.2

Section 508 compliance, Preface

server install

instructions, 2.2

service names

errors resolving service name, E.2

services

starting local RTP service, 2.1.3

stopping local RTP service, 2.1.3

sessions

OPEN_CURSORS parameter for multiple sessions, A.2

SGA_TARGET parameter

Runtime Repository, A.2

SHARED_POOL_SIZE parameter

Runtime Repository, A.2

Single Sign-On (SSO)

integrating Design and Runtime Audit Browsers with Oracle Application Server, 2.5.3.1

software products

Warehouse Builder, required for, 1.3.2

software requirements for Warehouse Builder, 1.3

Name and Address cleansing products, 1.3.2.5

Oracle Application Server, 1.3.2.3

Oracle Database, 1.3.2.1

Oracle Enterprise Manager, 1.3.2.4

Oracle Workflow, 1.3.2.4

products required, 1.3.2

required Warehouse Builder components, 1.3.2.2

sorting

PGA_AGGREGATE_TARGET parameter, A.2

SSO See Single Sign-On (SSO)

starting

Browser Assistant, 2.1.3

Design Browser, 2.1.3

HTTP server, 2.5.1.1

local RTP service, 2.1.3

MDL File Upgrade Utility, 2.1.3

OC4J instance, 2.1.3

OMB Plus, 2.1.3

Oracle Universal Installer (OUI), 1.6.2

Repository Assistant, 2.1.3

Runtime Assistant, 2.1.3

Runtime Audit Browser, 2.1.3

Warehouse Builder Client, 2.1.3

Warehouse Builder components, 2.1.3

STATISTICS_LEVEL parameter

Runtime Repository, A.2

stopping

local RTP service, 2.1.3

OC4J instance, 2.1.3

summary

quick steps for installing Warehouse Builder, 1.1

synonyms

migrating data by creating synonyms for original objects in the new Target Schema, 3.4.1.3

SYS account

REMOTE_LOGIN_PASSWORDFILE parameter, A.1

SYS user

Design Repository, 2.3

REMOTE_LOGIN_PASSWORDFILE parameter, A.1, A.2

Runtime Repository, 2.4.1

Target Schema, 2.4.2

verifying privileges, E.2

SYSDBA privileges

before you begin, 2.1.4

checking for SYS user, E.2

Design Repository, 2.3

REMOTE_LOGIN_PASSWORDFILE parameter, A.1, A.2

Repository Assistant, 2.3

Runtime Assistant, 2.4.1, 2.4.2

Runtime Repository, 2.4.1, 2.4.1, 2.4.2

Target Schema, 2.4.2

T

tablespaces

Design Repository, 2.3

materialized views, allocation for, E.2

Repository Assistant, 2.3

Runtime Assistant, Runtime Repository, 2.4.1

Runtime Assistant, Target Schema, 2.4.2

Runtime Repository, 2.4.1

Target Schema, 2.4.2

Target Schema

about, 2.4.2

database configuration warning, 2.4.2

deinstalling, 4.2

deploying mappings to an upgraded Target Schema, 3.5

enabled roles, E.2

importing when migrating, 3.2.3.2.3

installation instructions, 2.4

migrating data by creating synonyms for original objects in the new Target Schema, 3.4.1.3

migrating data to the new runtime environment, 3.4.1

privileges for, 2.4.2

Runtime Assistant, 2.4.1

tablespaces, 2.4.2

targets

flat files, UTL_FILE_DIR parameter, A.2, A.2.1

tnsnames.ora file

SERVICE_NAME parameter, E.2

topology

typical Warehouse Builder installation scenarios, 2.1.2

troubleshooting

diagnostics and debugging, E

U

UNDO_MANAGEMENT parameter

Runtime Repository, A.2

unicode text in this manual, Preface

uninstalling

See deinstalling

UNIX

HP-UX, database server issues, E.1.6

starting Warehouse Builder components, 2.1.3

updating

V

variables

upgrading, D.1.1.1

versions

upgrading versions of Warehouse Builder, 3

virtual memory

errors, E.2

W

Warehouse Builder

client, log file location, E.1.1

client, starting, 2.1.3

deinstalling, 4, 4.5

detailed instructions for installing, 2

diagnostics and debugging, E

environment, required and optional components, 1.3.2

installation overview, 2.1

installation requirements, 1

Oracle Home directory, multiple product coexistence, 1.4

Oracle Portal reports on Warehouse Builder metadata, 2.5.3.1

required components, 1.3.2.2

upgrading to the latest release, 3

WB_RT_MAPAUDIT privilege, 3.2.3.2.1

Windows

starting Warehouse Builder components, 2.1.3

wizards

Metadata Loader File Upgrade Wizard, D.1.1.2