Q

Impact of migration from 8i to 9i

I want to migrate from Sun Solaris 5.8 Oracle Database 8i version 8.1.7.3.0 (64-bit) to Sun Solaris Oracle Database 9i version 9.2.0.5.0 (64-bit). Could you please tell me the step-by-step procedure of migration? What will be the impact of migration?

I want to migrate from Sun Solaris 5.8 Oracle Database 8i version 8.1.7.3.0 (64-bit) to Sun Solaris Oracle Database 9i version 9.2.0.5.0 (64-bit). Could you please tell me the step-by-step procedure of migration? What will be the impact of migration? We have code in Pro*C, Shell scripts, PL/SQL -- will that compiled code run? Or do we have to compile all codes, functions and procedures? We are using the SCCS utility. What should we do with that? From where do I get the patches for Oracle 8.1.7/9i?
Because you are migrating from 8.1.7, a direct upgrade path to 9.2 is supported so you have a number of choices for how to perform the upgrade. The best place to look for migration information is Oracle's Technology Web site. The Oracle9i Database Migration Release 2 (9.2) Guide states that you have the following choices for migration:

  • Use the Database Upgrade Assistant (DBUA). The Database Upgrade Assistant can be launched by the Oracle Universal Installer, depending upon the type of installation that you select, and provides a graphical user interface (GUI) that guides you through the upgrade of a database. During installation, you can choose to not use the DBUA, instead choosing to launch it as a standalone tool at any time in the future to upgrade a database.
  • Perform a manual upgrade. A manual upgrade provides a command-line upgrade of a database, using SQL scripts and utilities.
  • Perform a full or partial export from your database, followed by a full or partial import into a new Oracle9i database. Export/Import can copy a subset of the data in a database. Export/Import leaves the database unchanged, and makes a copy of the data.
  • Copy data from a database into a new Oracle9i database using the SQL*Plus COPY command or the AS clause of the CREATE TABLE SQL statement. Data copying can copy a subset of the data in a database. Data copying leaves the database unchanged, and makes a copy of the data.

The guide also describes the advantages and disadvantages of each method. You should review the migration guide to determine which method would be most beneficial in your environment.

With respect to your second question, it's difficult for me to say whether your code will run unmodified after the migration, or whether you will have to make changes. The only way to determine what the impact of a migration will be is to test it in a non-production environment, several times if possible. Doing this will not only give you some indication of what needs to be changed, it will also ensure that all applications supported by the database you are migrating will be sufficiently tested before the migration occurs in your production environment.

Patches for Oracle 8.1 and 9.2 can be downloaded from Oracle's Metalink Web site. To register for Metalink, you will need a valid Support Identifier (CSI). CSI numbers are unique support identifiers given to each customer with a current support contract. As an aside, if you are upgrading to Oracle 9.2, you might as well upgrade to the latest release which is 9.2.0.7 if it's available for your platform and operating system.

This was first published in October 2005

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close