Skip Headers

Oracle® Application Server Integration InterConnect Installation Guide 10g Release 2 (10.1.2) B14070-02 |
| Contents | Index

Previous | Next |

# A Upgrading Oracle Application Server Integration InterConnect

This section explains how to upgrade Oracle Application Server 10g Release 2 Integration InterConnect.

The upgrade process consists of the following tasks:

- Reviewing Your Current Oracle Application Server Integration InterConnect Installations

- Installing and Upgrading Hub Components, Adapters, and Development Kit

- Upgrading Metadata

- Upgrading Management

## Reviewing Your Current Oracle Application Server Integration InterConnect Installations

The location where you install Oracle Application Server Integration InterConnect components varies, depending upon the version you are using:

- In Oracle9iAS Release 2 (9.0.2) topologies, Oracle Application Server Integration InterConnect components reside in the Infrastructure or middle tier Oracle home, or a different Oracle home.

- In 10g (9.0.4), Oracle Application Server Integration InterConnect components do not reside in the Infrastructure or middle tier Oracle home. In fact, you must install them in a different Oracle home.

- In 10g Release 2 (10.1.2.0.1 and 10.1.2.0.2), Oracle Application Server Integration InterConnect components reside in the middle tier Oracle home.

## Installing and Upgrading Hub Components, Adapters, and Development Kit

Your first step in upgrading to Oracle Application Server Integration InterConnect 10g Release 2 (10.1.2.0.2), is to install the 10g Release 2 (10.1.2.0.2) Hub, Adapters, and Development Kits by following the installation instructions in the Oracle Application Server Integration InterConnect installation documentation, which is available on the Oracle Application Server documentation library CD-ROM.

The information provided in the installation procedure should reflect the configuration of the 10g Release 2 (10.1.2.0.1) components that you are upgrading.

Ensure that the architecture described in the 10g Release 2 (10.1.2.0.2) installation is the same as the 10g (9.0.4) or 10g Release 2 (10.1.2.0.1) architecture, unless you intend to change the architecture.

## Upgrading Metadata

Follow these steps to upgrade the Oracle Application Server Integration InterConnect metadata:

1. Install the most recent Oracle Application Server Integration InterConnect patch set for the version you are upgrading.

   For example, if you are upgrading from 10g (9.0.4), be sure that you have installed the latest 10g (9.0.4) patchset.

2. Run the oaiexport script provided with the Release 2 (9.0.2), 10g (9.0.4) or 10g Release 2 (10.1.2.0.1) installation.

   Supply values for repository name, file name, system password, and connect string with the following command:

   `SOURCE_ORACLE_HOME\oai\version\repository\oaiexport file_name system\system_password connect_string`

   In this example, version represents 9.0.2, 9.0.4 or 10.1.2.0.1, depending upon the version of Oracle Application Server Integration InterConnect you are upgrading.

   The metadata is exported to the file_name you provide in the current directory.

3. Run the oaiimport script provided with the 10g Release 2 (10.1.2.0.2) installation.

   Supply values for repository name, file name, from user (the user ID of the user whose metadata is being imported), system password, `ichub` schema password, and connect string with the following command:

   `DESTINATION_MIDTIER_HOME\integration\interconnect\repository\oaiimport file_name from_user system\system_password ichub_schema_password connect_string`

   When you run this command, the file_name you provide is imported into the 10g Release 2 (10.1.2.0.2) Hub database.

4. Create the tables in the hub schema database by executing one of the following SQL commands in the hub schema.

   - If you are upgrading from Release 2 (9.0.2), execute the SQL commands in Example A-1.

   - If you are upgrading from 10g (9.0.4), execute the SQL commands in Example A-2.

   - If you are upgrading from 10 g Release 2 (10.1.2.0.1), execute the SQL commands in Example A-3.

   Example A-1 Creating Oracle Application Server Integration InterConnect Tables When Upgrading From Release 2 (9.0.2)

       CREATE TABLE emdcomments (emdid NUMBER(10)
                CONSTRAINT fk_emdcomments_emdid REFERENCES emd(id) ON DELETE CASCADE
                CONSTRAINT nn_emdcomments_emdid NOT NULL, name VARCHAR2(4000)
                CONSTRAINT nn_emdcomments_name NOT NULL,comments LONG);
       DROP TABLE ComponentInfoValue;
       CREATE TABLE ComponentInfoValue (seqnum NUMBER
                CONSTRAINT fk_seqnum REFERENCES
                ComponentInfo(seqnum) ON DELETE CASCADE, value RAW(1024);
       Execute xsd.sql from
                DESTINATION_MIDTIER_HOME\integration\interconnect\repository\sql

   Example A-2 Creating Oracle Application Server Integration InterConnect Tables When Upgrading From 10g (9.0.4)·

       DROP TABLE ComponentInfoValue;
       CREATE TABLE ComponentInfoValue (seqnum NUMBER
                     CONSTRAINT fkseqnum REFERENCES
                     ComponentInfo(seqnum) ON DELETE CASCADE, value RAW(1024);
       Execute xsd.sql from
                     DESTINATION_MIDTIER_HOME\integration\interconnect\repository\sql

   Example A-3 Creating Oracle Application Server Integration InterConnect Tables When Upgrading From 10g Release2 (10.1.2.0.1)

       Execute xsd.sql from
       DESTINATION_MIDTIER_HOME\integration\interconnect\repository\sql

## Upgrading Management

The Oracle Application Server Integration InterConnect Management architecture has changed significantly since Release 2 (9.0.2), 10g (9.0.4) and from 10g Release 2 (10.1.2.0.1). Now, you can use the 10g Release 2 Oracle Application Server Enterprise Manager to manage Oracle Application Server Integration InterConnect runtime components.

The Oracle Application Server Enterprise Manager can only be used for configuring the Interconnect hub, repository and adapter properties, starting/stopping the Interconnect runtime components (Repository and Adapters) and to monitor the runtime performance metrics of the running adapters.

For other management activities, for example, to modify and resubmit the error or fault messages, you can use the ICManager command-line tool to manage InterConnect runtime components. ICManager is available at the following location within the 10g (10.1.2) Oracle Application Server Integration InterConnect Oracle home:

    DESTINATION_MIDTIER_HOME\integration\interconnect\bin\ICManager.bat

See Also: Oracle Application Server Integration InterConnect Installation Guide and the Oracle Application Server Integration InterConnect User's Guide User's Guide for more information.