Skip Headers

Oracle9i Warehouse Builder Installation and Configuration Guide
Release 9.2.0.3

Part Number B11000-02
Go To Table Of Contents
Contents

Go to previous page

Index

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


A

accounts
creating UNIX accounts and groups, 1-17
AIX
software requirements for, 1-8
architecture
overview of Warehouse Builder, 2-2
Warehouse Builder components, 1-4

B

base directory
Design Time install, 2-9
Browser Assistant
integrating Design and Runtime Audit Browsers with Oracle9iAS, 2-32
business areas
upgrading to collections, C-2

C

CD-ROMs
mounting Oracle Universal Installer (OUI) CD-ROM, 1-19
certified software
Oracle Metalink, 1-13
CLASSPATH environment variable
character length, 1-14
collections
upgrading from business areas, C-2
command line utilities
upgrading metadata, C-5
components
about Warehouse Builder, 1-4
overview of Warehouse Builder installation, 2-2
recommendations about environment, 1-5
required and optional components for Warehouse Builder environment, 1-4
software requirements for Warehouse Builder components, 1-12
Warehouse Builder components installed by Oracle Universal Installer (OUI), 2-4
configuring
Design Browser with Oracle9iAS, 2-35
mappings, upgrading, 3-10
Net Service Name, 2-42
Oracle Enterprise Manager (OEM), B-1
Runtime Audit Browser with Oracle9iAS, 2-37
connectors
privileges automatically created for, 2-27
Create Any Directory privilege, 2-27
Create Public Database Link privilege, 2-11
creating
connectors, privileges for, 2-27
data source, 2-39
Design Repository when upgrading, 3-3
OC4J instance, 2-38
Runtime Access User when upgrading, 3-3
Runtime Repository when upgrading, 3-3
Target Schemas when upgrading, 3-3
Custom install
about, 2-8

D

data
audit data, migrating, 3-5
migrating audit and target data for upgrade, 3-1
target data, migrating, 3-6
data source
creating, 2-39
Data Source Class
defining, 2-40
database configuration warning
Repository Assistant, 2-13
Runtime Assistant, 2-25, 2-29
Target Schema, 2-29
database links
privileges created for, 2-11
debugging, D-1
defining
data source, 2-39
Data Source Class, 2-40
deinstalling
Design Browser from Oracle9iAS, 4-1
Design Repository with Repository Assistant, 4-3
old version of Warehouse Builder, 3-12
other Oracle software with Oracle Universal Installer (OUI), 4-4
overview, 4-1
Runtime Audit Browser from Oracle9iAS, 4-1
Runtime Repository with Runtime Assistant, 4-3
Target Schema with Runtime Assistant, 4-2
upgrading, 3-12
Warehouse Builder software, 4-1
Warehouse Builder with Oracle Universal Installer (OUI), 4-4
Warehouse Builder, ORACLE_HOME directory, 1-13
deleting
directory when deinstalling Warehouse Builder, 1-13
See also deinstalling
deploying
mappings, upgraded, 3-10
Design Browser
client, about, 1-7
client, enabling, 2-17
client, installation requirements, 1-12
deinstalling from Oracle9iAS, 4-1
integrating with Oracle9iAS, 2-35
integrating with Oracle9iAS, install instance, 1-6
integrating with Oracle9iAS, requirements, 1-13
Design Browser client
about, 1-7
installation requirements, 1-12
Design Repository
deinstalling, 4-3
languages, 2-14
registering a default in Oracle9iAS, 1-5
Repository Assistant, 2-11
SYSDBA, 2-12
tablespaces, 2-13
upgrading Warehouse Builder, 3-3
Design Time
installation requirements, 1-12
Design Time install
about, 2-5
instructions, 2-9
diagnostics, D-1
directory
removing when deinstalling Warehouse Builder, 1-13
disk space
hardware requirements, 1-7
DISPLAY environment variable
requirements for UNIX, 1-15
Drop Any Directory privilege, 2-27
dropping
connectors, privileges for, 2-27

E

environment
recommendations about environment components, 1-5
required and optional components, 1-4
environment variables
character length, 1-14
Windows environment variables, 1-14
exporting
metadata in preparation for upgrade, 3-4
upgrading files exported in Oracle Database, 3-4
external processes
upgrading to user defined processes, C-2

F

file locations
Oracle Universal Installer (OUI), file locations, 2-10

G

group name
Design Time install, 2-9
groups
creating UNIX accounts and groups, 1-17

H

hardware requirements, 1-7
disk space, 1-7
page file size, 1-7
RAM, 1-7
HP-UX
software requirements for, 1-8

I

importing
upgrading files imported in Oracle Database, 3-4
upgrading metadata, 3-4
installation
pre-installation tasks, 1-13
installation requirements
Design Browser client, 1-12
Design Time, 1-12
disk space, 1-7
hardware requirements, 1-7
operating systems, 1-8
page file size, 1-7
RAM, 1-7
Runtime Audit Browser client, 1-12
Server Side, 1-12
installing
diagnostics and debugging, D-1
Name and Address, 2-44
Oracle Enterprise Manager (OEM), B-1
Oracle Workflow (OWF), B-1
quick steps, 1-1
requirements, 1-1
upgrading Warehouse Builder, 3-2, 3-3
Warehouse Builder, detailed instructions, 2-1
inventory directory
about Oracle Universal Installer (OUI), 1-18

J

JDBC
EJB location, 2-40
JDBC driver, 2-40
JDBC URL, 2-40
location, 2-40
transactional (XA) location, 2-40
Jserver, 2-22
java_pool_size, 2-22

L

languages
Design Repository, 2-14
Repository Assistant, 2-14
launching
Oracle Universal Installer (OUI), 1-19
Warehouse Builder components, 2-5
LD_LIBRARY_PATH environment variable
character length, 1-14
Linux
requirements for, 1-8
locale
NLS_LANG, 1-15
setting the locale, 1-14
localhost
adding "localhost" to your web browser proxy server bypass list, 2-30

M

mappings
deploying upgraded mappings, 3-10
updating configuration, 3-10
upgrading, C-3
MDL
exporting metadata to upgrade, 3-4
importing metadata to upgrade, 3-4
MDL File Upgrade Utility
about, C-1
memory
hardware requirements, 1-7
metadata
deinstalling, 4-3
exporting for upgrade, 3-4
upgrading, 3-1
upgrading, importing, 3-4
Metadata Loader (MDL)
exporting metadata to upgrade, 3-4
File Upgrade Wizard, C-4
importing metadata to upgrade, 3-4
migrating
audit and target data, 3-1
audit data, 3-5
target data, 3-6
mounting CD-ROMs, 1-19

N

Name and Address
data libraries, 2-44
installing, 2-44
operator, about, 2-44
vendors, 2-44
Name and Address Server
installation instructions, 2-21
Runtime Assistant, 2-26
Net Service Name
configuring, 2-42
NLS_LANG
setting the locale, 1-15

O

OC4J
creating OC4J instance, 2-38
operating systems
required software, 1-8
Warehouse Builder certification, 1-8
Oracle 8.1.7/9i Database
Warehouse Builder Design Repository, 1-5
Warehouse Builder Runtime repository, 1-5
Oracle Database
Design Browser client, 1-5
Design Repository, 1-5
OEM repository, 1-5
Oracle HTTP Server, 1-5
OWF tables, 1-5
Runtime Audit Browser client, 1-5
Oracle Enterprise Manager (OEM)
about, 1-7
configuring, B-1
installing, B-1
Oracle HTTP Server
Oracle Database, 1-5
Oracle Metalink
certified software, 1-13
Oracle Universal Installer (OUI)
about OUI, 1-18
base directory, 2-9
components installed by OUI, 2-4
Custom install, 2-8
deinstalling other Oracle software, 4-4
deinstalling Warehouse Builder, 4-4
Design Time install, 2-5, 2-9
Design Time, installation requirements, 1-12
inventory directory, 1-18
orainstRoot.sh, 2-9
root.sh, 2-11
Server Side install, 2-8, 2-18
Server Side, installation requirements, 1-12
starting OUI, 1-19
Oracle Warehouse Builder
diagnostics and debugging, D-1
Oracle Workflow (OWF)
about, 1-7
installing, B-1
ORACLE_HOME
deinstalling Warehouse Builder, 1-13
upgrading, 3-2, 3-3
ORACLE_HOME environment variable
coexistence considerations, 1-13
requirements for UNIX, 1-15
Oracle9i Application Server (Oracle9iAS)
components to install with, 1-6
Oracle9iAS
Data Source Class, defining, 2-40
integrating the Design and Runtime Audit Browsers, 2-32
registering a default repository, 1-5
Oracle9iAS
deinstalling Design Browser, 4-1
deinstalling Runtime Audit Browser, 4-1
Design Browser, requirements, 1-13
Runtime Audit Browser, requirements, 1-13
orainstRoot.sh
Design Time install, 2-9
overview
deinstalling Warehouse Builder, 4-1
installation components, 2-2
installing Warehouse Builder, 1-1
upgrading Warehouse Builder, 3-2
owbrt_sys
Runtime Assistant, 2-22

P

page file size
hardware requirements, 1-7
PATH environment variable
character length, 1-14
portlet provider
provider URL, 2-41
registering, 2-41
pre-installation
installation requirements, 1-1
pre-installation tasks, 1-13
privileges
Create Any Directory, 2-27
Create Public Database Link, 2-11
Drop Any Directory, 2-27
SYSDBA, 2-8
public database links
privileges created for, 2-11

Q

quick steps
installing, 1-1

R

RAM
hardware requirements, 1-7
registering
default repository in Oracle9iAS, 1-5
portlet provider, 2-41
removingSee deinstalling
Repository Assistant
database configuration warning, 2-13
deinstalling Design Repository, 4-3
installation instructions, 2-11
languages, 2-14
SYSDBA, 2-12
tablespaces, 2-13
requirements
hardware requirements, 1-7
installation requirements, 1-1
operating environments, 1-8
software requirements for Warehouse Builder components, 1-12
root.sh
Design Time install, 2-11
runtime
audit data, migrating, 3-5
Runtime Access Schema
installation instructions, 2-21
Runtime Assistant, 2-26
Runtime Access User
upgrading Warehouse Builder, 3-3
Runtime Assistant
database configuration warning, 2-25, 2-29
deinstalling Runtime Repository, 4-3
deinstalling Target Schema, 4-2
installation instructions, 2-21
Runtime Access Schema, 2-26
tablespaces, Runtime Repository, 2-25
tablespaces, Target Schema, 2-29
Target Schema, 2-26
Runtime Audit Browser
client, about, 1-7
client, installation requirements, 1-12
Create Database Link, Net Service Name, 2-42
deinstalling from Oracle9iAS, 4-1
integrating with Oracle9iAS, 2-37
integrating with Oracle9iAS, install instance, 1-6
integrating with Oracle9iAS, requirements, 1-13
Runtime Audit Browser client
about, 1-7
installation requirements, 1-12
Runtime Repository
database configuration warning, 2-25
deinstalling, 4-3
installation instructions, 2-21
registering a default in Oracle9iAS, 1-5
SYSDBA, 2-23, 2-27
tablespaces, 2-25
upgrading Warehouse Builder, 3-3

S

Server Side
installation requirements, 1-12
Server Side install
about, 2-8
Oracle Universal Installer (OUI), 2-18
software
certified software, 1-13
components of Warehouse Builder, 1-4
requirements for Warehouse Builder components, 1-12
Solaris
software requirements for, 1-8
SYS account, 2-12, 2-24, 2-27
SYSDBA
before you begin, 2-8
Repository Assistant, 2-12
Runtime Assistant, 2-23, 2-27
Runtime Repository, 2-23, 2-27

T

tablespaces, 2-13, 2-25, 2-29
Design Repository, 2-13
Repository Assistant, 2-13
Runtime Assistant, Runtime Repository, 2-25
Runtime Assistant, Target Schema, 2-29
Runtime Repository, 2-25
Target Schema, 2-29
Target Schema
database configuration warning, 2-29
deinstalling, 4-2
deploying upgraded mappings, 3-10
installation instructions, 2-21
migrating data to, 3-6
Runtime Assistant, 2-26
tablespaces, 2-29
upgrading Warehouse Builder, 3-3
TMP environment variable
requirements for UNIX, 1-16
troubleshooting
diagnostics and debugging, D-1

U

UNIX
creating UNIX accounts and groups, 1-17
DISPLAY environment variable, 1-15
environment variables, 1-15
Group Name screen, Design Time install, 2-9
launching Warehouse Builder components, 2-5
ORACLE_HOME coexistence considerations, 1-13
ORACLE_HOME environment variable, 1-15
orainstRoot.sh, 2-9
requirements for, 1-8
root.sh, 2-11
TMP environment variable, 1-16
upgrading
audit data, migrating, 3-5
business areas, C-2
deinstalling, 3-12
deploying upgraded mappings, 3-10
external processes, C-2
files imported or exported in Oracle Database, 3-4
installing new version of Oracle Warehouse Builder, 3-3
local variables, C-3
mapping configuration, 3-10
mappings, C-3
metadata, 3-1
Metadata Loader (MDL) File Upgrade Wizard, C-4
metadata, exporting, 3-4
metadata, importing, 3-4
migrating target data, 3-6
overview, 3-2
user defined processes
upgrading from external processes, C-2

V

variables
upgrading, C-3
versions
migrating, 3-1

W

warehouse
deinstalling Target Schema, 4-2
migrating target data, 3-6
Warehouse Builder
about, 1-4
about Warehouse Builder, 1-4
Client, about, 1-6
components, 1-4
deinstalling, 4-1, 4-4
installation overview, 2-2
installing overview, 1-1
upgrading, 3-1
Windows
environment variables, 1-14
launching Warehouse Builder components, 2-5
NT User Manager, Oracle Enterprise Manager (OEM), B-3
software requirements for, 1-8
wizards
Metadata Loader File Upgrade Wizard, C-4

Go to previous page
Oracle
Copyright © 1996, 2003 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents