5 Upgrading the Oracle Data Integrator from 12.1.2 to 12.1.3

This chapter describes the tasks required to upgrade an 12.1.2 Oracle Data Integrator environment to 12.1.3.

This chapter contains the following topics:

5.1 Upgrading the Oracle Data Integrator Standalone Agent Environment

Upgrade Oracle Data Integrator Standalone agent environment from 12.1.2 to 12.1.3 using Upgrade Assistant.

To Upgrade Oracle Data Integrator Standalone agent:

Table 5-1 Oracle Data Integrator Standalone Agent Upgrade Process

Task Description More Information

Review and understand the topics in Chapter 1 of this document.

This chapter provides important information you should read and understand before beginning your upgrade process.

Chapter 1

Plan your upgrade.

Understand important concepts and tasks when planning your upgrade.

Section 6.1.1

Backup your existing 12.1.2 environment.

Before you begin your upgrade, make a complete backup of your existing 12.1.2 environment.

Section 6.1.2

If necessary, upgrade the repository database to a supported database version.

The Oracle Data Integrator Repositories are stored into database schemas. Before you can upgrade these schemas, you must make sure the database is a supported version.

Section 6.1.3

Copy (clone) existing Master and Work Repositories before running the Upgrade Assistant

Oracle recommends that you perform repository upgrades on cloned repository schemas.

Section 6.1.5

Verify that the work repositories are attached to the correct work repository schema and host

The Upgrade Assistant upgrades all work repositories attached to master repository. Each work repository must be attached to the correct work repository schema and host before performing the upgrade.

Section 6.1.7

Create a database backup of the ODI schema that will be upgraded.

Creating a backup is mandatory if the repository schemas have not been cloned and you are attempting to upgrade a non-cloned schema. Performing a backup of the ODI schemas is particularly important if the upgrade fails and corrupts the content. With a backup, you can delete the corrupted schemas and re-clone the originals to complete the upgrade.

Section 6.1.8

Install and Configure Oracle Data Integrator 12.1.3.

Install Oracle Data Integrator 12.1.3. This procedure includes creating the necessary database schemas.

The Upgrade Assistant is available as part of the ODI product installation.

Section 6.2

Run Upgrade Assistant to Upgrade the Oracle Data Integrator Master Repository and Work Repository schema.

The Upgrade Assistant upgrades the Oracle Data Integrator 12.1.2 repository schemas to Oracle Data Integrator 12.1.3.

Section 6.3

Review the configuration summary on the Configuration Summary screen, then click Reconfig to reconfigure the domain.

The Reconfiguration Wizard reconfigures the domain.

Section 6.5


5.2 Upgrading the Oracle Data Integrator Java EE Agent Environment

Upgrade Oracle Data Integrator Java EE agent environment from 12.1.2 to 12.1.3 using Upgrade Assistant.

To Upgrade Oracle Data Integrator Standalone agent:

Table 5-2 Oracle Data Integrator Java EE Upgrade Process

Task Description More Information

Review and understand the topics in Chapter 1 of this document.

This chapter provides important information you should read and understand before beginning your upgrade process.

Chapter 1

Plan your upgrade.

Understand important concepts and tasks when planning your upgrade.

Section 6.1.1

Backup your existing 12.1.2 environment.

Before you begin your upgrade, make a complete backup of your existing 12.1.2 environment.

Section 6.1.2

If necessary, upgrade the repository database to a supported database version.

The Oracle Data Integrator Repositories are stored into database schemas. Before you can upgrade these schemas, you must make sure the database is a supported version.

Section 6.1.3

Copy (clone) existing Master and Work Repositories before running the Upgrade Assistant

Oracle recommends that you perform repository upgrades on cloned repository schemas.

Section 6.1.5

Verify that the work repositories are attached to the correct work repository schema and host

The Upgrade Assistant upgrades all work repositories attached to master repository. Each work repository must be attached to the correct work repository schema and host before performing the upgrade.

Section 6.1.7

Create a database backup of the ODI schema that will be upgraded.

Creating a backup is mandatory if the repository schemas have not been cloned and you are attempting to upgrade a non-cloned schema. Performing a backup of the ODI schemas is particularly important if the upgrade fails and corrupts the content. With a backup, you can delete the corrupted schemas and re-clone the originals to complete the upgrade.

Section 6.1.8

Install and Configure Oracle Data Integrator 12.1.3.

Install Oracle Data Integrator 12.1.3. This procedure includes creating the necessary database schemas.

The Upgrade Assistant is available as part of the ODI product installation.

Section 6.2

Run Upgrade Assistant to Upgrade the Oracle Data Integrator Master Repository and Work Repository schema.

The Upgrade Assistant upgrades the Oracle Data Integrator 12.1.2 repository schemas to Oracle Data Integrator 12.1.3.

Section 6.3

Review the configuration summary on the Configuration Summary screen, then click Reconfig to reconfigure the domain.

The Reconfiguration Wizard reconfigures the domain.

Section 6.4


5.3 Upgrading the Oracle Data Integrator Colocated Standalone Agent Environment

Upgrade Oracle Data Integrator Colocated Standalone agent environment from 12.1.2 to 12.1.3 using Upgrade Assistant.

To Upgrade Oracle Data Integrator Colocated Standalone agent:

Table 5-3 Oracle Data Integrator Colocated Standalone Upgrade Process

Task Description More Information

Review and understand the topics in Chapter 1 of this document.

This chapter provides important information you should read and understand before beginning your upgrade process.

Chapter 1

Plan your upgrade.

Understand important concepts and tasks when planning your upgrade.

Section 6.1.1

Backup your existing 12.1.2 environment.

Before you begin your upgrade, make a complete backup of your existing 12.1.2 environment.

Section 6.1.2

If necessary, upgrade the repository database to a supported database version.

The Oracle Data Integrator Repositories are stored into database schemas. Before you can upgrade these schemas, you must make sure the database is a supported version.

Section 6.1.3

Copy (clone) existing Master and Work Repositories before running the Upgrade Assistant

Oracle recommends that you perform repository upgrades on cloned repository schemas.

Section 6.1.5

Verify that the work repositories are attached to the correct work repository schema and host

The Upgrade Assistant upgrades all work repositories attached to master repository. Each work repository must be attached to the correct work repository schema and host before performing the upgrade.

Section 6.1.7

Create a database backup of the ODI schema that will be upgraded.

Creating a backup is mandatory if the repository schemas have not been cloned and you are attempting to upgrade a non-cloned schema. Performing a backup of the ODI schemas is particularly important if the upgrade fails and corrupts the content. With a backup, you can delete the corrupted schemas and re-clone the originals to complete the upgrade.

Section 6.1.8

Install and Configure Oracle Data Integrator 12.1.3.

Install Oracle Data Integrator 12.1.3. This procedure includes creating the necessary database schemas.

The Upgrade Assistant is available as part of the ODI product installation.

Section 6.2

Run Upgrade Assistant to Upgrade the Oracle Data Integrator Master Repository and Work Repository schema.

The Upgrade Assistant upgrades the Oracle Data Integrator 12.1.2 repository schemas to Oracle Data Integrator 12.1.3.

Section 6.3

Upgrade your standalone agent environment (with WebLogic domain).

After upgrading the 11g schemas, you can upgrade your standalone agent environment (with WebLogic domain).

Section 6.6

Review the configuration summary on the Configuration Summary screen, then click Reconfig to reconfigure the domain.

The Reconfiguration Wizard reconfigures the domain.

Section 6.6.1


5.4 Verifying the Upgrade