Oracle® Application Server 10g Upgrading from Release 1 (1.0.2.2.x) to 10g (9.0.4)
10g (9.0.4) Part No. B13674-02 |
|
![]() |
![]() |
This chapter contains step-by-step instructions for upgrading OracleAS InterConnect. It contains the following sections:
Follow the installation instructions in Oracle Application Server InterConnect components to install the Hub, Adapters, and Development Kits. The information provided in the installation procedure should reflect the configuration of the Release 1 (4.1) components. Ensure that the architecture described in the 10g (9.0.4) installation is the same as the Release 1 (4.1) architecture unless you intend to change the architecture.
Follow these steps to upgrade metadata:
Install the most recent Release 1 (4.1) Oracle Application Server InterConnect patch set.
Run the oaiexport
script provided with the Release 1 (4.1) installation by issuing the following command:
<
source_InterConnect_OH
>/oai/4.1/repository/<
repo name
>/oaiexport <
file name
> system/<
system password
> <
connect string
>
where:
repo name
is the name of the InterConnect Repository in the Oracle9iAS Release 1 (1.0.2.2.x) installation.
file name
is the file name to which you wish to save the database schema export (e.g., mytestrepo.dmp
).
system password
is the password of the SYSTEM user in the hub database.
connect string
is the TNS service name of the hub database. The service name of the default database will be used if no value is provided.
The metadata is exported to a file in the current directory.
Run the oaiimport
script provided with the 10g (9.0.4) installation by issuing the following command:
<
destination_InterConnect_OH
>/oai/9.0.4/repository/oaiimport <
file name
> <
from user
> system/<
system password
> <
oaihub904 schema password
> <
connect string
>
where:
file name
is the file name to which you wish to save the database schema export (e.g., mytestrepo.dmp
).
from user
is the user of the hub schema in the Oracle9iAS Release 1 (1.0.2.2.x) installation (oaihub
, typically).
system password
is the password of the SYSTEM user in the hub database.
oaihub904 schema password
is the password for the 10g (9.0.4) hub database
connect string
is the TNS service name of the hub database. The service name of the default database will be used if no value is provided.
The file is imported into the 10g (9.0.4) hub database.
Create the tables in the hub schema database by issuing this command in the hub schema:
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); create table lcoextratypeattr(parentid NUMBER(10) CONSTRAINT fk_lcoextratypeattr_parent REFERENCES lco(id) ON DELETE CASCADE, name VARCHAR2(600), types LONG, CONSTRAINT pk_lcoextratypeattr PRIMARY KEY (parentid,name)); create table dsoextratypeattr(parentid NUMBER(10) CONSTRAINT fk_dsoextratypeattr_parent REFERENCES dso(id) ON DELETE CASCADE, name VARCHAR2(600), types LONG, CONSTRAINT pk_dsoextratypeattr PRIMARY KEY (parentid,name));
Using SQL*Plus, connect to the hub schema in the Infrastructure database and issue these commands:
update emd set type='AQ' where type='XML'
commit;
Follow these steps to upgrade adapters:
Install the OracleAS InterConnect 10g adapter, which corresponds to the existing adapter that you have. The prompts for hub database information refer to the Oracle9iAS Release 1 Hub Database.
When prompted for all other information, provide the values from your existing configuration.
Follow these steps to upgrade iStudio and the SDKs:
Install the OracleAS InterConnect 10g Developer Kits. This includes the new version of the SDKs.
Install the OracleAS InterConnect 10g iStudio. As you create an iStudio project, the prompts for hub database information refer to the OracleAS 10g Hub Database.
Follow these steps to upgrade Management:
Install the Oracle Enterprise Manager 10g (OMS and Java Console) that gets shipped with the 9.2 database.
Configure Oracle Enterprise Manager 10g as per the install documentation for OracleAS InterConnect 10g.
Follow the instructions in the 10g (9.0.4) Oracle Application Server InterConnect installation documentation in the Oracle Application Server InterConnect documentation library (accessible from the Oracle Application Server documentation library).