Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Installing and Configuring Oracle Warehouse Builder

1 Overview of Installation and Configuration Architecture

• Choosing an Appropriate Installation Configuration
• Architecture and Components of Oracle Warehouse Builder
  • Single Computer Topology
  • Separate Client and Database Server Topology
  • Multiple Database Topology
  • Separate Client, Control Center Service, and Database Server Topology
  • Control Center Agent Topology
• About the Check for Updates Wizard for Oracle Warehouse Builder

2 Installing Oracle Warehouse Builder on the Server

• Installing Oracle Warehouse Builder on Oracle Database 11g Release 2
• Working with Oracle Warehouse Builder Standalone Install Package
• Installing Oracle Warehouse Builder Through Oracle Universal Installer
• Installing Oracle Warehouse Builder in Oracle RAC Environments
  • Installing Oracle Warehouse Builder on Each Node of a Cluster
    • Checklist: Before Using the Universal Installer in an Oracle RAC Environment
    • For Windows Users Installing in an Oracle RAC Environment
    • For UNIX Users Installing in an Oracle RAC Environment
  • Ensuring the Availability of Service Names for Oracle RAC Nodes
• Performing a Silent Install and Using Response Values
• After the Installation is Complete

3 Configuring Oracle Warehouse Builder for Windows

• Configuring Oracle Warehouse Builder on Windows Installed as Part of Oracle Database 11g Release 2
• Configuring Oracle Warehouse Builder on Windows Installed as a Standalone Instance
  • About Configuring Oracle Warehouse Builder Installed as a Standalone Instance
  • Cleaning an Oracle Warehouse Builder Repository
  • Creating an OWBSYS Schema with Repository Objects
  • Configuring the Control Center Service
  • Unlocking the OWBSYS and OWBSYS_AUDIT Accounts
  • Configuring Oracle Workflow to Support Oracle Warehouse Builder Process Flows
  • Setting Oracle Warehouse Builder Home for Remote Installations
• Creating the First Workspace in the Repository on Windows

4 Configuring Oracle Warehouse Builder for Linux

• Configuring Oracle Warehouse Builder on Linux Installed as Part of Oracle Database 11g Release 2
• Configuring Oracle Warehouse Builder on Linux Installed as a Standalone Instance
  • About Configuring Oracle Warehouse Builder Installed as a Standalone Instance
  • Cleaning an Oracle Warehouse Builder Repository
  • Creating an OWBSYS Schema with Repository Objects
  • Configuring the Control Center Service
  • Unlocking the OWBSYS and OWBSYS_AUDIT Accounts
  • Configuring Oracle Workflow to Support Oracle Warehouse Builder Process Flows
  • Setting the Oracle Warehouse Builder Home for Remote Installations
• Creating the First Workspace in the Repository on Linux

5 Uninstalling Oracle Warehouse Builder

• About Uninstalling Oracle Warehouse Builder
• Deleting the Workspace Users
• Deleting the Workspace
• Deleting the Schema Objects
• Deleting a Repository from an Oracle Database
• Uninstalling the Oracle Warehouse Builder Software

6 Moving to Oracle Warehouse Builder 11.2 from Earlier Releases

• Understanding MDL Migration and Repository Upgrades
  • Choosing Between MDL Migration and Repository Upgrade
  • MDL Migration Paths
  • Repository Upgrade Paths from Oracle Warehouse Builder 10.1 or 9.n to Release 11.2
• Choosing a Repository Upgrade Scenario
• In-Place Upgrade of Oracle Warehouse Builder 10g Release 2 or 11g Release 1 Repository to Oracle Warehouse Builder 11g Release 2
  • Preparing for In-Place Repository Upgrade
  • Performing the In-Place Repository Upgrade
  • Upgrading a Repository to Release 11.2 through MDL Files
    • Exporting an Oracle Warehouse Builder Repository to a File
    • Importing a Repository Export MDL File to Oracle Warehouse Builder Release 11.2
  • Deploying Any Process Flow Package With Repository Upgrade to Release 11.2
• Migrating the Repository to a Different Oracle Database Instance
• Upgrading Locations to Oracle Warehouse Builder Release 11.2
  • Upgrading Locations to Oracle Warehouse Builder Release 11.2 Using the Repository Browser
• Changes to Repository Objects When Moving to Oracle Warehouse Builder 11g Release 2

7 Configuring Repository Browser, Control Center Agent, and Other Components

• Configuring the Repository Browser Environment
  • Changing the Session Timeout
• Configuring Control Center Agent for Oracle Application Server
  • Modifying the OC4J Startup Script
  • Configuring Control Center Agent Server-side Logging
  • Configuring the Audit Data Source
  • Setting Control Center Agent Security Roles
  • Creating JMS Queues
  • Setting the PATH Environment Variable
  • Deploying the Control Center Agent to OC4J
  • Configuring the Control Center Agent Web Service (jrt-web.war)
  • Enabling Control Center Agent Audit Table Logging
    • Configuring OWBSYS Audit Connection Pool
    • Configuring an Audit Table Data Source
  • Installing JDBC Drivers for OC4J
  • Overview of Control Center Agent Files
    • ODL Job Log Files
    • Control Center Agent Run-Time Log File
    • JobID File
    • Control Center Agent Settings
    • JRTAdministratorMBean
  • Installing Code Templates for Use from Control Center Agent
• Integrating with E-Business Suite
• Installing Third-Party Name and Address Data
• Integrating with Oracle Workflow

Part II Administering Oracle Warehouse Builder

8 Managing Configurations

• About Configuration Management
• Creating Configurations Templates
• Editing Configuration Templates
• Activating Configurations
• Configuring Objects

9 Managing the Control Center and Repository

• Overview of Oracle Warehouse Builder Control Center and Repository Management
  • Starting and Stopping the Control Center Service
  • Displaying and Managing Control Center Configuration
  • Managing Control Center Deployment and Execution Jobs
  • Oracle Warehouse Builder Repository and Location Administration Utilities
• Oracle Warehouse Builder Administrative Utilities
  • abort_exec_request
  • abort_unit_request
  • deactivate_all
  • deactivate_deployment
  • deactivate_execution
  • delete_warehouse_object
  • display_platform_property
  • expedite_exec_request
  • grant_error_table_privileges
  • grant_upgrade_privileges
  • list_requests
  • print_exec_details
  • print_running_exec_details
  • purge_audit_template
  • reset_repository
  • rtrepos_report
  • service_doctor
  • set_ccs_home
  • set_platform_property
  • set_platform_property_from_file
  • set_repository_password
  • show_service
  • sqlplus_exec_background_template
  • sqlplus_exec_template
  • start_service
  • stop_service
  • UpdateControlCenter
  • UpdateLocation
• Overview of Oracle Warehouse Builder Repository Browser
  • Starting the Repository Browser
  • How to Start the Repository Browser Listener
  • How to Stop the Repository Browser Listener

10 Managing the Control Center Agent

• Starting and Stopping the Control Center Agent
• About the cca_admin Utility
• Starting the cca_admin Utility
• cca_admin Commands
  • cleanUpJobLogFilesForGivenTimeInterval
  • cleanUpNLeastRecentJobLogFiles
  • connect
  • disconnect
  • exit
  • getCacheJobStatusSize
  • getCacheLogNo
  • getKmPermissionsFile
  • getLogRoot
  • getMaxAbortTimeout
  • getMaxRuntimeFileSizeMB
  • getMaxRuntimeLogSizeMB
  • getRuntimeLogEncoding
  • getRuntimeLogFileLocation
  • getRuntimeLogLevel
  • help
  • isKmSecurityNeeded
  • isLogToAuditTable
  • isLogToOdl
  • isShowRuntimeLoggerLogHostAddr
  • isShowRuntimeLoggerLogHostId
  • isShowRuntimeLoggerLogMsgClassPath
  • isShowRuntimeLoggerLogMsgLogLevel
  • isShowRuntimeLoggerLogUserId
  • readSettings
  • reset
  • setCacheJobStatusSize
  • setCacheLogNo
  • setKmPermissionsFile
  • setKmSecurityNeeded
  • setLogRoot
  • setLogToAuditTable
  • setLogToOdl
  • setMaxAbortTimeout
  • setMaxRuntimeFileSizeMB
  • setMaxRuntimeLogSizeMB
  • setRuntimeLogEncoding
  • setRuntimeLogLevel
  • setShowRuntimeLoggerLogHostAddr
  • setShowRuntimeLoggerLogHostId
  • setShowRuntimeLoggerLogMsgClassPath
  • setShowRuntimeLoggerLogMsgLogLevel
  • setShowRuntimeLoggerLogUserId
  • settingsToString
  • showAllJobLogFiles

11 Using Snapshots to Manage Metadata

• About Snapshots and Metadata Loader
• Using Snapshots
  • Creating Snapshots
  • Adding Components to a Snapshot
  • Managing Snapshots
    • Managing Snapshot Access Privileges
    • Comparing Snapshots
    • Converting a Full Snapshot to a Signature Snapshot
    • Restoring Workspace Objects From Snapshots
    • Exporting and Importing Snapshots
    • Deleting Snapshots
  • Snapshot Performance

12 Importing, Exporting, and Upgrading Metadata

• Exporting Metadata from the Design Center
• Importing Metadata Using the Design Center
  • Importing Objects
  • Combining Import Modes and Matching Criteria
  • Import Different Base Languages
    • Different Base Languages in the Import File and Target Repository
    • Importing Supported Languages
  • Import Validation Rules
• Upgrading Metadata from Earlier Releases
  • Changes to Workspace Objects When Upgrading from Oracle Warehouse Builder 9.2
  • Changes to Workspace Objects When Upgrading from Oracle Warehouse Builder 10.1, 10.2 or 11.1
  • Checking for Warnings and Error Messages
• Design Center Metadata Management Dialog Boxes
  • Metadata Export Dialog Box
  • Export Advanced Options Dialog Box
    • Languages
    • Administration
  • Metadata Import Dialog Box
  • Import Advanced Options Dialog Box
    • Languages
    • Administration
    • Name Conflicts
  • File Summary Dialog Box
  • Metadata Upgrade Dialog Box
  • Metadata Progress Dialog Box
• Metadata Loader Utilities
  • Metadata Export Utility
  • Metadata Import Utility
• Multiple Session Concurrency and MDL
• Metadata Loader Log File
• About Metadata Loader Results
• Managing Versions and History with the Metadata Loader
  • Accessing the Metadata Loader
    • About Metadata Loader Control Files

13 Managing Security

• About Metadata Security
  • About the Security Service
• Evaluating Metadata Security Strategies
  • Minimal Metadata Security Strategy (Default)
  • Multiuser Security Strategy
  • Full Metadata Security Strategy
• Registering Database Users
  • Registering Existing Database Users
  • Creating New Oracle Database Users
  • Changing Database Default Roles
• Editing User Profiles
  • Roles
  • Default Object Privilege
    • Object Privileges
  • System Privileges
• Support for a Multiple-user Environment
  • Read/Write Mode
  • Read-Only Mode
• Defining Security Roles
  • Everyone Role
  • Administrator Role
• Editing Role Profiles
  • Users
• Applying Security Properties on Specific Metadata Objects
  • Security Tab
    • Example: Using Security Properties to Freeze a Project Design
• Security Enforcement
• Managing Passwords in Oracle Warehouse Builder
  • Credential Memory on Logon Panel
  • Changing Passwords that Access Oracle Warehouse Builder
  • Encrypting Passwords to Oracle Warehouse Builder Locations

A Troubleshooting the Installation and Setup

• General Steps for Troubleshooting Oracle Warehouse Builder
• Inspecting Log Files in Oracle Warehouse Builder
• Error Messages Related to Installation
• Troubleshooting Other Installation Problems
• Checking the Java Virtual Machine (JVM)
• Using Oracle Warehouse Builder Client Logging to Control Logging and Trace Problems
• Checking the System Path of Oracle Warehouse Builder
• Configuring Oracle Warehouse Builder for Oracle RAC

Index