A Upgrading Oracle Application Server Integration InterConnect

This appendix explains the procedure to upgrade to Oracle Application Server Integration InterConnectrelease 10.1.2.0.2. You can upgrade to Oracle Application Server Integration InterConnect 10g Release 2 (10.1.2) by performing the following steps:

Reviewing Your Current Oracle Application Server Integration InterConnect Installation
Installing and Upgrading Hub Components, Adapters, and Development Kit
Upgrading Metadata
Managing Oracle Application Server Integration InterConnect

Reviewing Your Current Oracle Application Server Integration InterConnect Installation

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

In Release 2 (9.0.2), 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

The first step in upgrading to Oracle Application Server Integration InterConnect 10g Release 2 (10.1.2.0.2), is to install the release 10.1.2.0.2 Hub, Adapters, and Development Kit.

Upgrading Metadata

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

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.
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.

Provide 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.
Run the oaiimport script provided with the 10.1.2.0.2 installation.

Provide 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 connection 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 10.1.2.0.2 Hub database.

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 specified in Example A-1.
If you are upgrading from 10g (9.0.4), execute the SQL commands specified in Example A-2.
If you are upgrading from release 10g Release 2 (10.1.2.0.1), execute the SQL commands specified 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

Managing Oracle Application Server Integration InterConnect

The Oracle Application Server Integration InterConnect Management architecture has changed significantly since Release 2 (9.0.2), 10g (9.0.4), and 10g Release 2 (10.1.2.0.1). In 10g Release 2 (10.1.2), you can use the Oracle Enterprise Manager 10g to manage Oracle Application Server Integration InterConnect run-time components. You can also use the command-line tool ICManager to manage InterConnect run-time components.