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

2 Installing Oracle Warehouse Builder on the Server

• Installing OWB on Oracle Database 11g Release 2
• Working with the OWB Standalone Install Package
• Installing Oracle Warehouse Builder Through Oracle Universal Installer
• After the Install
• Silent Install Response Values

3 Configuring Oracle Warehouse Builder for Windows

• Configuring OWB Installed as Part of Oracle Database 11g Release 2
• Configuring OWB Installed as a Standalone Instance
  • About Configuring OWB 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
  • Setting the OWB Home for Remote Installations
• Creating the First Workspace in the Repository

4 Configuring Oracle Warehouse Builder for Linux

• Configuring OWB Installed as Part of Oracle Database 11g Release 2
• Configuring OWB Installed as a Standalone Instance
  • About Configuring OWB 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
  • Setting the OWB Home for Remote Installations
• Creating the First Workspace in the Repository

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 Migrating Oracle Warehouse Builder from Earlier Releases

• Migrating the Repository on the Same Database Instance
  • Preparing for Repository Migration
  • Upgrading an OWB 11g R1 Repository
  • Upgrading an OWB 10g R2 Repository
    • Exporting a Repository to a File
    • Importing a File into a Repository
• Migrating the Repository to a Different Oracle Database Instance
  • Exporting a Repository
  • Importing a Repository
• Upgrading Locations

7 Installing Optional Components

• Modifying the OC4J Startup Script
• Configuring Control Center Agent Server-side Logging
• Configuring the Audit Data Source
• Configuring 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
• Configuring the Repository Browser Environment
  • Changing the Session Timeout
• 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 OWB 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
  • OWB Repository and Location Administration Utilities
• OWB 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

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 Managing Content

• 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 Using the Metadata Loader

• 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 OWB 9.2
  • Changes to Workspace Objects When Upgrading from OWB 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 Warehouse Builder
  • Credential Memory on Logon Panel
  • Changing Passwords that Access Warehouse Builder
  • Encrypting Passwords to Warehouse Builder Locations

A Troubleshooting the Installation and Setup

• General Steps for Troubleshooting Warehouse Builder
• Inspecting Log Files in Warehouse Builder
• Error Messages Related to Installation
• Troubleshooting Other Installation Problems
• Checking Java Virtual Machine (JVM)
• Generating Log Files for a Specific Warehouse Builder Component
• Checking the System Path of Oracle Warehouse Builder
• Configuring OWB for RAC

Index