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

This chapter describes the tasks required to upgrade the 11g Oracle Data Integrator standalone agent environment to Oracle Fusion Middleware 12c (see Section 1.1 for valid 11g starting points).

The following upgrade scenarios are covered:

  • Upgrading an 11g Release 1 (11.1.1.6.0) or 11g Release 1 (11.1.1.7.0) standalone agent not managed by OPMN to 12c.

  • Upgrading an 11g Release 1 (11.1.1.6.0) or 11g Release 1 (11.1.1.7.0) standalone agent managed by OPMN to 12c.

The following topics are covered in this chapter:

3.1 Understanding the Standalone Agent Upgrade Process

Figure 3-1 provides an overview of the upgrade process for the standalone agent topology.

Figure 3-1 Upgrade Process Flowchart for Standalone Agents (no WebLogic Domain)

Description of Figure 3-1 follows
Description of ''Figure 3-1 Upgrade Process Flowchart for Standalone Agents (no WebLogic Domain)''

Table 3-1 describes each of the steps in the upgrade process flowchart which is shown in Figure 3-1. The table also provides information on where to go to get more information on each step in the process.

Table 3-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 11g environment.

Before you begin your upgrade, make a complete backup of your existing 11g 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 12c.

Install Oracle Data Integrator 12c. 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 11g repository schemas to Oracle Data Integrator 12c.

Section 6.3

If your standalone agent is managed by OPMN, run the Upgrade Assistant again to upgrade the Oracle Data Integrator standalone agent.

This step configures the 11g standalone agent infrastructure to 12c.

Section 6.5


3.2 Verifying the Upgrade

Perform the tasks in this section to verify that the upgrade was successful.

3.2.1 Starting the Node Manager

For more information about starting the Node Manager, see "Starting the Node Manager" in Installing and Configuring Oracle Data Integrator.

3.2.2 Starting the Standalone Agent

For more information about starting the Standalone Agent, see "Starting the Standalone Agent with Node Manager" in Installing and Configuring Oracle Data Integrator.