Oracle® Application Server Integration InterConnect Installation Guide
10g Release 2 (10.1.2) B14070-02 |
|
Previous |
Next |
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
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.
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.
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
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. |