How To Upgrade From ODI 11g To 12c By Cloning The Schema On Same Database
Last updated on JANUARY 14, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
How to Upgrade Oracle Data Integrator (ODI) 11g to ODI 12c by cloning the database schema on the same database?
By following the Upgrade Guide:
Oracle® Fusion Middleware Upgrading Oracle Data Integrator
Chapter 5 Upgrading Your Oracle Data Integrator Environment
- Section 5.1 Preparing to Upgrade Oracle Data Integrator > 5.1.5 Cloning Existing Master and Work Repositories
Indicates the steps to clone the current database schemata to a different database or a current one.
- Section 5.1 Preparing to Upgrade Oracle Data Integrator > 5.1.6 Verifying that Work Repositories are Attached to the Correct Schemas
Indicates how to re-attach the cloned work repositories to the cloned Master Repositories.
- After the backup of the clone env, documentation will explain the following step:
Section 5.3 Upgrading Your Master and Work Repository Schema
The Upgrade Assistant will fail, as the newely cloned schemas are not visible to the Upgrade Assistant tool.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms