Migrating Your Application, 4 of 4

Migration Steps

This section describes the requirements for migration as well as the steps you must take to migrate your application.

Disk Space Requirements

The migration step assumes that you have enough disk space to create a separate test environment, in addition to your production environment, that contains the following elements:

all or a subset of your production data
new application code

Hardware Considerations

A migration to Oracle8i interMedia Text involves using three Oracle homes:

pre-8.1 production Oracle home
test 8.1 Oracle home
new production 8.1 Oracle home

You might consider creating your test oracle home on a separate machine from your pre-8.1 production oracle home. Do this so that your test environment does not compete for resources such as disk space and processing time with your production environment while you recreate your application code.

You must create a new 8.1 oracle home to upgrade your database. The upgrade process for Oracle8 to Oracle8i expects this to be on the same machine, but this is not necessary.

Steps

Table 2-1 outlines a possible plan for migrating your pre-8.1 application running on Oracle8 to a working 8.1 application running on Oracle8i. This plan suggests setting up a test environment next to your production environment, outlining the steps you execute in each environment.

Note:
The following table is a recommended plan. The exact details of a migration plan will differ from site to site depending on how your application is designed.

Table 2-1

Step	Production Environment	Test Environment
1.	Running	Install interMedia Text 8.1 and Oracle8i software in an Oracle home separate from your production Oracle home. This test Oracle home is your test environment.
2.	Copy `drminst` and `drmrun` from test environment. See "Using the Index Migration Scripts" in Chapter 4.
3.	Run `drminst` and `drmrun` scripts to generate `migrate.sql`. See "Using the Index Migration Scripts" in Chapter 4.
4.	Export all or subset of production data to be used in the test environment.
5.	Running	Start Oracle8i database server.
6.	Running	Import data or subset of production data.
7.	Running	Copy `migrate.sql` from production environment.
8.	Running	Edit `migrate.sql`. See "Using the Index Migration Scripts" in Chapter 4.
9.	Running	Migrate your index by running either `migrate.sql` or your own index creation scripts. See "Migrating Your Index" in this chapter. You now have an interMedia Text 8.1 environment with schema and indexes similar to your pre-8.1 production environment.
10.	Running	Migrate pre-8.1 application code. See "Migrating Your Application Code"in this chapter.
11.	Running	Test application in interMedia Text 8.1 environment.
12.	Backup your pre-8.1 system.
13.	Drop your indexes and CTXSYS schema.
14.	Install interMedia Text 8.1 using the Oracle Universal Installer. In this process, you must create a new Oracle home for your Oracle8i interMedia Text installation. This new Oracle home will soon become your new production Oracle home. This new home is different from the old production Oracle home (which runs on Oracle8) and the test Oracle home. This installation process also creates a new CTXSYS user and the 8.1 interMedia Text data dictionary.
15.	Migrate your data (same as upgrading to Oracle8i) using the Oracle Data Migration Assistant. The Oracle Universal Installer starts this assistant automatically after you install interMedia Text. See "Migrating Your Data: Upgrading to Oracle8i" in this chapter.
16.	Copy `migrate.sql` and other newly created index creation scripts from your test Oracle home.
17.	Run `migrate.sql` and/or other index creating scripts to recreate index.
18.	Copy new 8.1 application code from test oracle home.
19.	Run 8.1 application.