Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Preparing to Upgrade Oracle Data Integrator

• 1.1 Understanding the Valid Starting Points for the Oracle Data Integrator Upgrade
• 1.2 Key Differences Between Oracle Data Integrator 11g and Oracle Data Integrator 12c
  • 1.2.1 Standalone Agents are Managed by the WebLogic Management Framework
  • 1.2.2 Standalone Agents are Installed in Their Own Directories
  • 1.2.3 Repository Upgrade to 12.1.3 Now Validates Name Uniqueness for Objects
• 1.3 Understanding the Oracle Data Integrator Standard Upgrade Topologies
  • 1.3.1 Oracle Data Integrator Standard Upgrade Topology for Java EE Agents
  • 1.3.2 Oracle Data Integrator Standard Upgrade Topology for Standalone Agents not Registered with a WebLogic Domain
  • 1.3.3 Oracle Data Integrator Standard Upgrade Topology for Standalone Agents Registered with a WebLogic Domain

2 Upgrading the Oracle Data Integrator Java EE Agent Environment from 11g to 12.1.3

• 2.1 Understanding the Java EE Agent Environment Upgrade Roadmap
• 2.2 Completing and Verifying the Upgrade
  • 2.2.1 Configuring and Starting the Node Manager
  • 2.2.2 Starting the Administration Server
  • 2.2.3 Starting the Managed Servers

3 Upgrading the Oracle Data Integrator Standalone Agent Environment (no WebLogic Domain) from 11g to 12.1.3

• 3.1 Understanding the Standalone Agent Upgrade Process
• 3.2 Verifying the Upgrade
  • 3.2.1 Starting the Node Manager
  • 3.2.2 Starting the Standalone Agent

4 Upgrading the Oracle Data Integrator Standalone Agent Environment (with WebLogic Domain) from 11g to 12.1.3

• 4.1 Understanding the Standalone Agent Upgrade Process
• 4.2 Verifying the Upgrade
  • 4.2.1 Configuring and Starting the Node Manager
  • 4.2.2 Restarting the Administration Server
  • 4.2.3 Starting the Colocated Standalone Agent

5 Upgrading the Oracle Data Integrator from 12.1.2 to 12.1.3

• 5.1 Upgrading the Oracle Data Integrator Standalone Agent Environment
• 5.2 Upgrading the Oracle Data Integrator Java EE Agent Environment
• 5.3 Upgrading the Oracle Data Integrator Colocated Standalone Agent Environment
• 5.4 Verifying the Upgrade

6 Upgrading the Existing Oracle Data Integrator 11g Environment

• 6.1 Preparing to Upgrade Oracle Data Integrator
  • 6.1.1 Planning the Upgrade
  • 6.1.2 Backing Up the Existing 11g Environment
  • 6.1.3 Upgrading the Database Containing the ODI Repository
  • 6.1.4 Re-Associating a File-Based Security Store
  • 6.1.5 Cloning Existing Master and Work Repositories
    • 6.1.5.1 Schema Cloning Process for Oracle Database
    • 6.1.5.2 Schema Cloning Process for MySQL Database
    • 6.1.5.3 Schema Cloning Process for Microsoft SQL Server Database
    • 6.1.5.4 Schema Cloning Process for IBM DB2 Universal Database
  • 6.1.6 Updating the Work Repository JDBC URL
  • 6.1.7 Verifying that Work Repositories are Attached to the Correct Schemas
  • 6.1.8 Creating a Backup of the ODI Repositories to be Upgraded
• 6.2 Installing Oracle Fusion Middleware 12c Products
• 6.3 Upgrading the Master and Work Repository Schema
  • 6.3.1 Stopping the Servers and Processes
  • 6.3.2 Starting the Upgrade Assistant
  • 6.3.3 Navigating the Upgrade Assistant Screens
• 6.4 Upgrading the Java EE Agent Environment
  • 6.4.1 Starting the Reconfiguration Wizard
  • 6.4.2 Navigating the Reconfiguration Wizard Screens to Reconfigure the Domain
• 6.5 Upgrading the Standalone Agent Environment (no WebLogic Domain)
  • 6.5.1 Starting the Upgrade Assistant
  • 6.5.2 Upgrading the Standalone System Component Configurations
• 6.6 Upgrading the Standalone Agent Environment (with WebLogic Domain)
  • 6.6.1 Reconfiguring the Domain Using the Reconfiguration Wizard
  • 6.6.2 Starting the Upgrade Assistant
  • 6.6.3 Upgrading the WebLogic Domain Component Configurations
• 6.7 Troubleshooting the Upgrade

A Appendix