Skip Headers
Oracle® Application Server Integration InterConnect Installation Guide
10g Release 2 (10.1.2)
B14070-02
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

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

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

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.

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.

    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.

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

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


See Also:

Oracle Application Server Integration InterConnect User's Guide for more information about Oracle Enterprise Manager 10g and IC Manager.