Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview of the Oracle Data Integrator Upgrade Process

• 1.1 Upgrade Roadmap

2 Oracle Data Integrator 11g for 10g Users

• 2.1 Components of the Oracle Data Integrator Installation
• 2.2 Important Changes for Oracle Data Integrator 10g Users
  • 2.2.1 Upgrade Considerations
  • 2.2.2 Changes in the Run-Time Agent
  • 2.2.3 Other Changes

3 Upgrading Your Oracle Data Integrator Environment

• 3.1 Understanding the Starting Points for Oracle Data Integrator
  • 3.1.1 Starting Points When Upgrading the Middle Tier Instance
  • 3.1.2 Starting Points When Upgrading the Oracle Data Integrator Repositories
• 3.2 Planning the Oracle Data Integrator Component Architecture
• 3.3 Upgrading the Database that Contains the ODI Repository
• 3.4 Verifying that Work Repositories are Attached to the Correct Schemas
• 3.5 Cloning Existing Master and Work Repositories
  • 3.5.1 Schema Cloning Process for Oracle Database
  • 3.5.2 Schema Cloning Process for Microsoft SQL Server Database
  • 3.5.3 Schema Cloning Process for PostgreSQL Database
  • 3.5.4 Schema Cloning Process for IBM DB2 Universal Database
    • 3.5.4.1 Same Host Cloning Process for ODI 10g Master and Work Schemas
    • 3.5.4.2 Different Host Cloning Process for ODI 10g Master and Work Schemas
  • 3.5.5 Schema Cloning Process for IBM DB2 AS/400 Database
  • 3.5.6 Schema Cloning Process for Sybase AS Enterprise 15+
  • 3.5.7 Schema Cloning Process for Hypersonic SQL 1.7.3.3
• 3.6 Creating a Backup of the ODI Repositories to be Upgraded
• 3.7 Installing and Configuring Oracle Data Integrator 11g
• 3.8 Running Upgrade Assistant to Upgrade ODI Middle Tier and Repositories
  • 3.8.1 Running the Upgrade Assistant for Oracle Data Integrator
  • 3.8.2 Upgrading the Middle Tier Instance
  • 3.8.3 Upgrading the Oracle Data Integrator Repositories
• 3.9 Performing Post-Upgrade Steps

4 Reconfiguring ODI After an Upgrade

• 4.1 Updating the Work Repository Connection Parameters
• 4.2 Updating Topology and Security Metadata
• 4.3 Re-applying ODI 10g Modifications to the ODI 11g Topology and Security Metadata
• 4.4 Re-applying Open Tools
• 4.5 Replacing KMs with Mandatory Updates

A Oracle Data Integrator Upgrade Screens

• A.1 Welcome
• A.2 Specify Operation
• A.3 Specify Source Home
• A.4 Prerequisites
• A.5 Target Database
• A.6 Examine
• A.7 Upgrade Summary
• A.8 Upgrade Progress
• A.9 End of Upgrade

Index