Skip Headers
Oracle® Warehouse Builder Installation and Administration Guide
11
g
Release 2 (11.2) for Windows and Linux
Part Number E17130-03
Home
Book List
Contents
Contact Us
Previous
View PDF
Index
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
R
S
T
U
V
W
A
access
multiple-user access, about,
13.5
read-only mode,
13.5.2
read/write mode,
13.5.1
accessing
Metadata Loader,
12.9.1
adding
workspace user,
3.3
,
4.3
adding role,
7.2.4
Administrator role,
13.6.2
application name,
7.2.7
architecture,
1.2
assigning
roles,
13.4.1
roles to users,
13.7.1
security roles,
13.6
system privileges,
13.4.3
audit connection pool,
7.2.9.1
audit data source
configuring,
7.2.3
audit table data source
configuring,
7.2.9.2
audit table logging,
7.2.9
C
cat_owb.sql,
3.2.1
,
4.2.1
changing
Control Center Agent settings with JRTAdministratorMBean,
7.2.11.5
metadata,
11.2
passwords,
13.10.2
session timeout,
7.1.1
Check for Updates Wizard,
1.3
clean_owbsys.sql,
3.2.1
,
4.2.1
,
5.5
cleaning repository
clean_owbsys.sql,
3.2.2
,
4.2.2
Linux,
4.2.2
Windows,
3.2.2
Cluster Topology,
7.2.4
Code Template,
7.2.1
code templates
installing,
7.2.12
components,
1.2
configuration architecture,
1
configuring
audit data source,
7.2.3
audit table data source,
7.2.9.2
Control Center Agent security roles,
7.2.4
Control Center Agent server-side logging,
7.2.2
Control Center Agent web service (jrt-web.war),
7.2.8
Control Center service
Linux,
4.2.4
reset_owbcc_home.sql,
3.2.4
,
4.2.4
Windows,
3.2.4
on Linux,
4
on Windows,
3
OWB installed as a standalone
Linux,
4.2
Windows,
3.2.1
OWB installed with Oracle Database 11g Release 2
Linux,
4.1
Windows,
3.1
owblient.bat file for memory,
A.3
OWBSYS audit connection pool,
7.2.9.1
repository browser environment,
7.1
connecting
database, errors connecting to,
A.3
Design Repository, error,
A.3
connection
testing,
7.2.9.1
connection pool type,
7.2.9.1
connection pools,
7.2.9.1
context root,
7.2.7
Control Center
enabled roles,
A.3
Control Center Agent,
1.2
configuring server-side logging,
7.2.2
deploying to OC4J,
7.2.7
Control Center Agent audit table logging
enabling,
7.2.9
Control Center Agent files,
7.2.11
Control Center Agent runtime log file,
7.2.11.2
Control Center Agent security roles,
7.2.4
configuring,
7.2.4
Control Center Agent settings,
7.2.11.4
Control Center Agent settings with JRTAdministratorMBean
changing,
7.2.11.5
Control Center Agent topology,
1.2.5
Control Center Agent web service
configuring,
7.2.8
Control Center Manager,
1.2
Control Center Service,
1.2
Control Center service
configuring
Linux,
4.2.4
Windows,
3.2.4
reset_owbcc_home.sql,
3.2.4
,
4.2.4
stopping
Linux,
4.2.2
Windows,
3.2.2
creating
database user,
3.3
,
4.3
database users,
13.3.2
JMS queue,
7.2.5
repository workspace
Linux,
3.3
Windows,
4.3
workspace,
3.3
,
4.3
creating OWBSYS schema
cat_owb.sql,
3.2.3
,
4.2.3
Linux,
4.2.3
Windows,
3.2.3
ct_permissions.properties,
7.2.1
D
data libraries
Name and Address,
A.3
data source type,
7.2.9.2
Data Sources,
7.2.9.2
database roles, changing,
13.3.3
database user
creating,
3.3
,
4.3
database users
creating in Warehouse Builder,
13.3.2
registering as Warehouse Builder users,
13.3
data-sources.xml,
7.2.3
default object privileges,
13.4.2
defining
security roles,
13.4.3
deleting
repository,
5.5
Repository users,
5.2
schema objects,
5.4
,
5.4
workspace,
5.3
workspace owner,
5.3
workspace user,
5.2
deploying
Control Center Agent to OC4J,
7.2.7
deployment errors,
A.2
deployment plan,
7.2.7
Design Center,
1.2
Design Control Center
enabled roles,
A.3
Design Repository
connecting error,
A.3
destination name,
7.2.5
,
7.2.5
destination type,
7.2.5
,
7.2.5
-Dlimit parameter
owbclient.bat file, memory threshold,
A.3
dropping
workspace,
5.3
E
E-Business Suite,
7.3
editing user profiles,
13.4
enabling
access to EBS,
7.3
access to metadata,
7.3
Control Center Agent audit table logging,
7.2.9
encrypting passwords,
13.10.3
enforcing security,
13.9
Enterprise Manager,
5.4
error logs
interpreting error logs,
A.2
ETL mappings,
1.2.5
execution
errors,
A.2
exporting
metadata, for user grants,
12.4.2.2
metadata, for user-defined definitions,
12.4.2.2
metadata, in additional languages,
12.4.2.1
metadata, results,
12.8
metadata, using the Design Center,
12.1
snapshots,
11.2.3.5
F
FND_APPLICATION table,
7.3
FND_APPLICATION_VL table,
7.3
FND_COLUMNS table,
7.3
FND_FOREIGN_KEY_COLUMNS table,
7.3
FND_FOREIGN_KEYS table,
7.3
FND_PRIMARY_KEY_COLUMNS table,
7.3
FND_PRIMARY_KEYS table,
7.3
FND_SEQUENCES table,
7.3
FND_TABLES table,
7.3
FND_VIEWS table,
7.3
G
generation
errors,
A.2
GLOBAL_DBNAME parameter
Net Service Name,
A.3
H
host name,
5.2
port number,
3.3
,
4.3
I
iIntegrating
E-Business Suite,
7.3
import language options,
12.2.3
importing
metadata, combining import modes and matching criteria,
12.2.2
metadata, for security grants,
12.4.4.2
metadata, for user-defined definitions,
12.4.4.2
metadata, in additional languages,
12.4.4.1
metadata, language options,
12.2.3
metadata, results,
12.8
metadata, using the Design Center,
12.2
metadata, validation rules,
12.2.4
snapshots,
11.2.3.5
init.ora file
MAX_ENABLED_ROLES parameter,
A.3
install option,
7.5
installating Warehouse Builder
on RAC environment,
2.4
installation
errors,
A.2
troubleshooting,
A.1
installation architecture,
1
installation configuration
choosing,
1.1
Control Center Agent topology,
1.2.5
multiple database topology,
1.2.3
separate client and database server topology,
1.2.2
separate Client, Control Center Service, and Database Server topology,
1.2.4
single computer topology,
1.2.1
installing
code templates,
7.2.12
earlier database releases,
2.2
JDBC drivers for OC4J,
7.2.10
JServer option, Oracle Database,
A.3
on Oracle Database 11g Release 2,
2.1
on server,
2
optional components,
7
Oracle Universal Installer,
2.3
Oracle Workflow,
7.5
Repository Browser,
7.1
standalone software,
2.2
third-party name and address data,
7.4
,
7.4
Warehouse Builder,
2.4.1
installing Warehouse Builder
on RAC environment,
2.4
Instance Level Security,
7.2.4
instance level security,
7.2.4
integrating
third-party name and address data libraries,
7.4
J
j2ee-logging.xml,
7.2.2
Java Virtual Machine (JVM)
verifying and reinstalling JVM,
A.5
jazn.com,
7.2.4
,
7.2.4
,
7.2.4
JDBC drivers for OC4J
installing,
7.2.10
JDBC Resources,
7.2.9.2
JDBC resources,
7.2.9.1
JDBC URL,
7.2.9.1
JMS destinations,
7.2.5
JMS queue
creating,
7.2.5
JNDI location,
7.2.5
,
7.2.5
,
7.2.9.2
JobID file,
7.2.11.3
JRT
owb_abortQueue,
7.2.5
owbQueue,
7.2.5
JRTAdministrator,
7.2.11.5
JRTAdministratorMBean,
7.2.11.5
jrt-internal-log-handler,
7.2.2
JRTWebService,
7.2.8
,
7.2.8
jrt-web.war,
7.2.8
jrtws.war,
7.2.8
JServer option
Repository Assistant, for the,
A.3
jython_lib.zip,
7.2.1
jython_owblib.jar,
7.2.1
K
km_security_needed,
7.2.1
L
language
select,
3.3
,
4.3
LD_LIBRARY_PATH,
7.5
LDAP parameters,
7.5
Level Security,
7.2.4
licence agreement,
2.2
listener.ora file
GLOBAL_DBNAME parameter,
A.3
LoadJava error
Repository Assistant,
A.3
log files
Metadata Loader logs,
12.7
logging
audit table,
7.2.9
logs
interpreting error logs,
A.2
M
mailer parameters,
7.5
managing
workspace,
3.3
,
4.3
workspace user,
5.2
materialized views, insufficient table space,
A.3
MAX_ENABLED_ROLES parameter,
A.3
MaxPermSize,
7.2.1
MDL
see
Metadata Loader
memory
errors during batch operation,
A.3
metadata,
7.1
changing,
11.2
full security strategy,
13.2.3
import and export errors,
A.2
minimal security strategy,
13.2.1
multiuser security strategy,
13.2.2
security,
13.1
upgrading,
12.3
Metadata Export Utility,
12.5.1
metadata import
required access privileges,
12.2
Metadata Import Utility,
12.5.2
Metadata Loader
about,
12.9
accessing,
12.9.1
log files,
12.7
multiple user access,
12.6
results,
12.8
utilities,
12.5
metadata objects
applying security properties,
13.8
metadata repository,
3.2.1
,
4.2.1
metadata snapshots,
11.2
modes
read-only mode,
13.5.2
read/write mode,
13.5.1
modifying
OC4J startup script,
7.2.1
multiple database topology,
1.2.3
multiple user access with MDL,
12.6
multiple user ecurity strategy,
13.2.2
multiple-user access
about,
13.5
read-only mode,
13.5.2
read/write mode,
13.5.1
-mx parameter
owbclient.bat file, virtual memory,
A.3
My Oracle Support,
2.3
N
Name and Address
regional libraries unavailable,
A.3
Name and Address server
errors,
A.2
names and addresses
installing third-party data,
7.4
Net Service Name
SERVICE_NAME parameter,
A.3
O
object privileges, default,
13.4.2
objects
restoring from snapshots,
11.2.3.4
OC4J startup script
modifying,
7.2.1
oc4j_app_administrators,
7.2.4
oc4jadmin,
7.2.4
oc4j-administrators,
7.2.4
ODL job log files,
7.2.11.1
opmn.xml,
7.2.1
optional components
installing,
7
Oracle Database
JServer option,
A.3
Oracle service name,
3.3
,
4.3
,
5.2
Oracle Workflow
installing,
7.5
ORACLE_HOME,
7.5
ORACLE_PORT,
7.5
ORACLE_SID,
7.5
OWB Browser,
1.2
OWB Client,
1.2
OWB software
uninstalling,
5.6
OWB_INTERNAL_USERS,
7.2.4
OWB_J2EE_ADMINISTRATOR,
7.2.4
,
7.2.4
OWB_J2EE_EXECUTOR,
7.2.4
,
7.2.4
OWB_J2EE_OPERATOR,
7.2.4
,
7.2.4
OWB_USER,
7.5
owbclient.bat file
-Dlimit memory threshold parameter,
A.3
-mx virtual memory parameter,
A.3
OWBSYS
creating,
3.2.3
definition,
2.1
unlocking, Linux,
4.1
unlocking, Windows,
3.1
OWBSYS account,
2.1
OWBSYS audit connection pool
enabling,
7.2.9.1
OWBSYS schema
creating
Linux,
4.2.3
Windows,
3.2.3
OWBSYS_AUDIT
definition,
2.1
unlocking, Linux,
4.1
unlocking, Windows,
3.1
owbsys_audit,
7.2.9.1
OWBSYS_AUDIT account,
2.1
P
passwords
changing,
13.10.2
encrypting,
13.10.3
in Warehouse Builder,
13.10
PATH environment variable,
7.2.6
performance
-Dlimit parameter,
A.3
performing a stack trace,
A.4
PermGen,
7.2.1
persistence,
7.2.5
,
7.2.5
port number,
5.2
pre-installation checklist,
2.4.1.1
privileges
default,
13.4.2
object,
13.4.2
SYS user, checking privileges,
A.3
system,
13.4.3
Process Flow Editor,
7.5
profiles, role,
13.7
properties
security,
13.8
Python.path,
7.2.1
R
RAC environments, installing Warehouse Builder on,
2.4
read-only mode,
13.5.2
read/write mode,
13.5.1
Realms,
7.2.4
,
7.2.4
remote installation
OWB home,
3.3
,
4.3
setting OWB home,
3.2.7
,
4.2.7
remote_owb_install.sql,
3.2.1
,
4.2.1
Repository,
1.2
repository
cleaning
Linux,
4.2.2
Windows,
3.2.2
deleting,
5.5
Repository Assistant,
3.2.3
,
3.3
,
4.2.3
,
4.3
LoadJava error,
A.3
Repository Assistant, Check for Updates Wizard in,
1.3
Repository Browser
installing,
7.1
repository browser environment
configuring,
7.1
repository objects,
3.2.3
,
4.2.3
Repository users, deleting,
5.2
required access privileges
metadata import,
12.2
requirements
JServer option, Oracle Database,
A.3
reset_owbcc_home.sql,
3.2.1
,
4.2.1
role
adding,
7.2.4
Roles,
7.2.4
roles
Administrator,
13.6.2
assigning,
13.4.1
assigning to users,
13.7.1
available,
7.2.4
changing default,
13.3.3
Everyone,
13.6.1
profiles,
13.7
security,
13.4.3
,
13.6
selected,
7.2.4
S
schema objects
deleting,
5.4
schema objects, deleting,
5.4
secure website,
7.2.8
secure-web-site.xml,
7.2.8
,
7.2.8
security
enforcement,
13.9
metadata,
13.1
multiple-user access,
13.5
read-only mode,
13.5.2
read/write mode,
13.5.1
roles,
13.4.3
security properties,
13.8
Security Providers,
7.2.4
security roles,
13.6
Control Center Agent,
7.2.4
security strategy
full,
13.2.3
minimal,
13.2.1
multiuser,
13.2.2
select
languages,
3.3
,
4.3
separate client and database server topology,
1.2.2
separate Client, Control Center Service, and Database Server topology,
1.2.4
service names
errors resolving service name,
A.3
session timeout
changing,
7.1.1
session-config,
7.1.1
setting
PATH environment variable,
7.2.6
setting OWB home
remote installation
Linux,
4.2.7
Windows,
3.2.7
remote_owb_install.sql,
3.2.7
,
4.2.7
silent install response values,
2.5
single computer topology,
1.2.1
snapshots
access privileges,
11.2.3.1
adding components,
11.2.2
comparing,
11.2.3.2
converting type,
11.2.3.3
deleting,
11.2.3.6
exporting, importing,
11.2.3.5
metadata,
11.2
restoring,
11.2.3.4
uses,
11.2
standalone software
download,
2.2
SYS password,
7.5
SYS user
verifying privileges,
A.3
SYSDBA privileges
checking for SYS user,
A.3
system privileges,
13.4.3
T
tablespace,
7.5
select,
3.3
,
4.3
tablespace, and materialized views,
A.3
tablespaces
materialized views, allocation for,
A.3
setting for Control Center,
A.3
Target Schema
enabled roles,
A.3
testing
connection,
7.2.9.1
web service,
7.2.8
third-party name and address data
installing,
7.4
third-party name and address data libraries
integrating with,
7.4
TNS connect descriptor,
7.5
tnsnames.ora file
SERVICE_NAME parameter,
A.3
troubleshooting
installations,
A.1
U
uninstalling
OWB software,
5.6
uninstalling OWB,
5
unlocking OWBSYS,
3.2.5
,
4.2.5
unlocking OWBSYS_AUDIT,
3.2.5
,
4.2.5
unregistering
workspace user,
5.2
user profiles, editing,
13.4
users
assigning roles to,
13.7.1
creating in Warehouse Builder,
13.3.2
registering as Warehouse Builder users,
13.3
,
13.3
USERS tablespace,
3.2.3
,
4.2.3
users, multiple
security strategy,
13.2.2
using
web service with a secure website,
7.2.8
utilities
Metadata Loader,
12.5
V
validation
errors,
A.2
validation rules for metadata import,
12.2.4
virtual memory
errors,
A.3
W
Warehouse Builder
frozen,
A.4
hanging,
A.4
installing,
2.4.1
passwords,
13.10
web service
testing,
7.2.8
web service with secure website,
7.2.8
web.xml,
7.1.1
wfinstall.bat,
7.5
wfinstall.csh,
7.5
wf.log,
7.5
workflow account,
7.5
Workflow Client,
7.5
Workflow Configuration Assistant,
7.5
workflow password,
7.5
Workflow Proxy User,
7.5
workspace,
3.2.1
,
4.2.1
creating,
3.3
,
4.3
Linux,
4.3
Windows,
3.3
deleting,
5.3
dropping,
5.3
managing,
3.3
,
4.3
workspace owner
deleting,
5.3
workspace user
adding,
3.3
,
4.3
deleting,
5.2
managing,
5.2
unregistering,
5.2
Scripting on this page enhances content navigation, but does not change the content in any way.