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

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

The following topics are covered in this chapter:

2.1 Understanding the Java EE Agent Environment Upgrade Roadmap

Figure 2-1 provides an overview of the upgrade process for the Java EE agent topology.

Figure 2-1 Java EE Agent Upgrade Process Flow

Description of Figure 2-1 follows
Description of ''Figure 2-1 Java EE Agent Upgrade Process Flow''

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

Table 2-1 Oracle Data Integrator J2EE 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

If necessary, re-associate your file-based security store.

If you are using a file-based security store in your 11g environment, then reassociate the file-based store with the database-based repository and OPSS schema.

Section 6.1.4

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 master repository schema and host

The Upgrade Assistant upgrades all work repositories attached to master repository. Each work repository must be attached to the correct master 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 the necessary Oracle Fusion Middleware 12c products

Install Oracle Fusion Middleware Infrastructure and Oracle Data Integrator 12c.

As part of the product installation, you should also follow the instructions to run RCU and create any new 12c schemas (for example, Service Table).

The Upgrade Assistant is available as part of the 12c 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

Upgrade your Java EE environment.

After upgrading the 11g schemas, run the reconfiguration wizard to reconfigure your 11g domain.

Running the reconfiguration wizard concludes the upgrade process for the Java EE agent environment.

Note: If any JRF component upgrade is needed, run the Upgrade Assistant again after the Reconfiguration Wizard.

Section 6.4


2.2 Completing and Verifying the Upgrade

To complete and verify the upgrade, perform the tasks in this section.

2.2.1 Configuring and Starting the Node Manager

Refer to the following to configure and start the Node Manager:

2.2.2 Starting the Administration Server

Start Administration Server, since server was down while upgrade was being done.

For more information, see "Starting and Stopping Administration Servers" in Administering Oracle Fusion Middleware.

  • Administration Console URL:

    http://administration_server_host:administration_server_port/console
    
  • Fusion Middleware Control:

    http://administration_server_host:administration_server_port/em
    

Note:

After upgrade, you must run your administration tools from the new 12c Oracle home and not from the 11g Oracle home.

2.2.3 Starting the Managed Servers

Refer to "Starting the Managed Server" in Installing and Configuring Oracle Data Integrator for instructions on how to start the Managed Server in the domain.