8
Migrating e-Business Integration Components

This chapter explains how to migrate e-business integration components. It contains these sections:

Migrating Oracle9iAS InterConnect

This section explains how to migrate Oracle9iAS InterConnect. (The schema is in the new Release 2 (v9.0.2) database.)

Configure the Release 2 installation of Oracle9iAS InterConnect to match the Release 1 (v1.0.2.2) installation. Note that:
- The infrastructure database of Release 2 corresponds to the hub database for Release 1.
- The Oracle9iAS middle tier Oracle home corresponds to the Oracle home in which the repository in Oracle9iAS Release 1 (1.0.2.2.x) is installed.
Install the Oracle9iAS InterConnect Hub in the Oracle9iAS middle tier Oracle home.

The Oracle9iAS InterConnect Repository, Workflow, and Workflow Communication are now installed. By default, these components point to the schemas in the infrastructure database.

Run the oaiexport script provided with the Release 1 installation. Supply values for repository name, file name, system password, and connect string in the command:
```
ORACLE_HOME_1/oai/4.1/repository/repository name/oaiexport file name 
system/system password connect string
```
The metadata is exported to a file in the current directory.
Run the oaiimport script provided with the Release 2 installation. Supply values for: repository name, file name, from user (the user id of the user whose metadata is being imported), system password, oaihub902 schema password, and connect string in the command:
```
ORACLE_HOME_2/oai/9.0.2/repository/oaiimport file name from user 
system/system password oaihub902 schema password connect string
```
The file is imported into the Oracle9iAS Release 2 Infrastructure Database.
Using SQLPlus, connect to the hub schema in the Infrastructure Database and execute the commands:
```
update emd set type='AQ' where type='XML' 
commit;
```

Install the Oracle9iAS InterConnect 902 adapter, which corresponds to the existing adapter that you have. The prompts for hub database information refer to the Oracle9iAS Release 2 Infrastructure Database.
When prompted for all other information, provide the values from your existing configuration.

Install the Oracle9iAS InterConnect Developer Kits 902. This includes the new version of iStudio and the SDKs. As you create an iStudio project, the prompts for hub database information refer to the Oracle9iAS Release 2 Infrastructure Database.

Install the Oracle Enterprise Manager Console 902.

A correctly configured Oracle Enterprise Manager for Oracle9iAS InterConnect is now available.

To migrate Oracle Workflow from Oracle9iAS Release 1 (v1.0.2.2) to Release 2 (v 9.0.2), perform the following steps:

Install Oracle Workflow with Oracle9iAS Release 2 (9.0.2), including all pre- and post- installation steps as described in the Oracle9i Application Server Installation Guide.

The installation updates the Oracle Workflow server version in the database. See the Oracle9i Application Server Installation Guide for detailed instructions.
Perform all Workflow setup steps for your Release 2 installation as described in the Setting Up Oracle Workflow chapter of the Oracle Workflow Guide. In particular, ensure that you:
- Set your global Workflow preferences appropriately
- Set up a directory service for Oracle Workflow
- Create a new configuration file for the Notification Mailer that contains the parameters with which you want to run the Notification Mailer.
Copy any customized files from ORACLE_HOME_1 to ORACLE_HOME_2. Such files may include the following:
- Workflow process definition files (.wft files located in ORACLE_HOME_1/wf/res/lang)
- Business Event System definition files (.xml files located in ORACLE_HOME_1/wf/res/lang)
- SQL scripts (.sql files located in ORACLE_HOME_1/wf/sql)
- Custom help files (.htm files located in ORACLE_HOME_1/wf/doc/lang/wfcust or .hlp files located in ORACLE_HOME_1/wf/res/lang)
- Any other files containing customizations