Oracle8 Enterprise Edition Getting Started
Release 8.0.6 for Windows NT

A69518-01

Library

Product

Contents

Index

Prev Next

7
Installing, Migrating, and Upgrading Databases

This chapter describes the options available to you when you have existing databases on your computer and want to install the latest release of Oracle8 Enterprise Edition. In particular, it describes how to coexist different database releases in the same Oracle home or in multiple Oracle homes, and how to migrate an Oracle7 database or upgrade an earlier Oracle8 database release to the current release of Oracle8 Enterprise Edition. This chapter also includes information on migrating a Microsoft Access database to an Oracle8 database.

Specific topics discussed are:

Intended Audience

Read this chapter if you have existing Oracle7 and/or Oracle8 databases on your computer and you want to install Oracle8 Enterprise Edition release 8.0.6. If you are installing Oracle8 Enterprise Edition on a computer that has no other Oracle database releases, you do not have to read this chapter.

Additional Information:

See Oracle8 Enterprise Edition Installation for Windows NT if you want to install Oracle8 Enterprise Edition on a computer containing no other databases. 

The generic Oracle8 Migration guide is the primary source of migration information in the Oracle documentation set. Read the first three chapters of that guide for information on how to prepare your existing databases for migration before performing a migration. Information on how to run the various migration and upgrade utilities is also provided in the generic guide, but the focus is on UNIX. This chapter provides information on using these utilities on Windows NT.

What To Do With Previous Oracle Database Releases

If you already have Oracle7, or Oracle7 and Oracle8 databases on your computer and want to install release 8.0.6, the following options are available to you.

If you are not sure what option is best for you, read the following overview sections:

Database Coexistence and Multiple Oracle Homes Overview

Releases of Oracle for Windows NT and Windows 95 prior to release 8.0.4 only supported single Oracle homes, allowing you to install and run Oracle products in a single Oracle home. Different versions of Oracle products could be installed in the same Oracle home provided they had different second-digit release numbers. For example, you could install release 7.2 products and release 7.3 products in the same Oracle home (database coexistence). However, you could not install multiple third-digit releases of the same products. For example, you could not install release 7.3.2 and release 7.3.3 versions of the same Oracle products on the same computer; one installation would overwrite the other.

The multiple Oracle homes feature enables you to install one or more releases of Oracle products on the same computer in multiple Oracle homes. For example, with multiple Oracle homes, you can install release 8.0.6 products and 8.0.4 products in different Oracle homes on the same computer. You can still install different releases of Oracle products in the same Oracle home provided they have different second-digit release numbers. See Chapter 6, "Using Multiple Oracle Homes" for more information.

Migrating, Upgrading, and Downgrading Overview

This section explains the difference between migrating, upgrading, and downgrading, and lists the Oracle database versions that can be migrated or upgraded.

What is Migrating?

Migrating is the process of transforming one database version to a later database version. For example, transforming an Oracle7 database to an Oracle8 database is migrating the database system. The term migrating is also used in this guide to refer to the transformation of a Microsoft Access database to an Oracle8 database.

What is Upgrading?

Upgrading is the process of transforming one database release to another database release of the same database version. For example, transforming an Oracle8 database release 8.0.4 to release 8.0.6 is upgrading the database system.

What is Downgrading?

Downgrading is the process of transforming an installed version of an Oracle database from a later release back into an earlier release. For example, transforming an Oracle database from release 8.0.6 back into release 8.0.3 is downgrading, and transforming an Oracle database from version 8 back into version 7 is downgrading.

Migrating and Upgrading Using Multiple Oracle Homes

You can easily migrate or upgrade databases across multiple Oracle homes. If you use the graphical user interface (GUI) Oracle Data Migration Assistant, all database instances on your system are displayed in a drop-down list. You select the Oracle database instance you want to migrate or upgrade and the assistant takes care of any multiple Oracle homes issues.

If you use the command line tools, MIG80 to migrate, or a U*.SQL script to upgrade, you need to copy files from one Oracle home directory to another. You must also ensure the PATH variable is set correctly so that any Oracle database tools you run are started from the correct Oracle home directory.

Checklist of Database Release Numbers

Check that your Oracle database release can be migrated or upgraded directly to Oracle8 Enterprise Edition. This table provides a list of the database releases you can migrate or upgrade and the tools you can use to perform these tasks:

Oracle Database Release  Use This Tool... 

Releases prior to 7.1.3.3.6 

If the database version precedes release 7.1.3.3.6, migrate it to at least release 7.1.3.3.6 before using MIG80 or Oracle Data Migration Assistant to migrate it to release 8.0.6. See the documentation that accompanied your previous database release for information on how to migrate it to release 7.1.3.3.6. 

Release 7.1.3.3.6 or later 

MIG80 can migrate databases that are Oracle7, release 7.1.x or later to release 8.0.6. Oracle Data Migration Assistant migrates from release 7.1.3.3.6 or later to release 8.0.6. 

Release 8.0.3.0.0 or later 

SQL scripts executed in Server Manager can upgrade databases release 8.0.3.0.0 or later to the current Oracle8 database release. Oracle Data Migration Assistant upgrades from release 8.0.3.0.0 or later to release 8.0.6. 

Export/Import Overview

An alternative method of migrating or upgrading is to:

  1. Export your data from the source database using the Export Utility (EXP80). The export physically copies the data to the export dump file.

  2. Create the version 8 database into which you will import the exported data.

  3. Import the exported data into the new version 8 database using the Import Utility (IMP80).

The Export Utility puts all of the data in one large binary file that can require large amounts of disk space.

Additional Information:

See "Choose a Migration Method" in Chapter 2 "Preparing to Migrate" of Oracle8 Migration for information on when to use the Export/Import utilities for migrating a database. See "Export an Existing Database" and "Import a Database" for information on using these tools. 

Version 8 and Version 7 Client/Server Configurations

Oracle7 and Oracle8 clients can communicate either with Oracle7 or Oracle8 databases. This functionality gives you maximum flexibility when designing your network and deciding when to:

Consider the following database coexistence issues before you decide which of the above options is most suitable for your requirements:

Oracle7 Database Applications

Can all my Oracle7 applications run on an Oracle8 database?

Most Oracle7 applications can run on an Oracle8 database. Some applications cannot run on an Oracle8 database unless you upgrade them to versions that support Oracle8 databases. If you have a combination of Oracle7 and Oracle8 applications, you may want to have an Oracle7 database and Oracle8 database exist on the same computer, until you have time to upgrade all your Oracle7 applications to Oracle8. Contact your application vendor to check if your third-party applications are supported with Oracle8 Enterprise Edition.

Oracle7 Client Connections to Oracle8 Databases

Check the following criteria to ensure successful Oracle7 client connections to an Oracle8 database. If the Oracle7 client and Oracle8 database are located in:

If you are using these releases:

Oracle8 Client Connections to Oracle7 Databases

Check the following criteria to ensure successful Oracle8 client connections to an Oracle7 database. If the Oracle8 client and Oracle7 database are located in:

Install Oracle7 and Oracle8 Databases in the Same Oracle Home

Install Oracle7 and Oracle8 databases in the same Oracle home directory and have both Oracle7 and Net8 clients connecting to Oracle7 and Oracle8 databases. The figure below gives an example of this network configuration:


You can install different versions of Oracle databases in the same Oracle home provided they have different first or second-digit versions. For example, you can have release 7.2.x, 7.3.x, and 8.0.x databases in the same Oracle home.

You cannot install multiple third-digit releases of the same products. For example, you cannot install release 7.3.2 and release 7.3.3, or release 8.0.3 and release 8.0.4, in the same Oracle home; one installation overwrites the other.

Ensure that each database instance has a unique SID. In particular, be careful that you do not use the default SID ORCL for subsequent installations if you already have a starter database with the SID ORCL installed. If you do so, the services of the later installation overwrite the services of the earlier installation.

Install Oracle7 and Oracle8 Databases in Multiple Oracle Homes

Install Oracle7 and Oracle8 databases in multiple (separate) Oracle homes and have both Oracle7 and Net8 clients connecting to Oracle7 and Oracle8 databases.

New Style Oracle Homes

Multiple Oracle homes functionality only works with releases 8.0.4, 8.0.5, and 8.0.6. These are known as new style Oracle homes.

Old Style Oracle Homes

If you have, for example, release 7.3.3 products already installed, you cannot install any other release 7.x products in a separate Oracle home. Also, if you have release 8.0.3 or earlier 8.0.x products already installed, you cannot install any other of these products in a separate Oracle home. These are known as old style Oracle homes. The figure below gives an example of this network configuration:


Install Oracle7 and Oracle8 Databases on Separate Computers

Install Oracle7 and Oracle8 databases on separate computers and have both Oracle7 and Net8 clients connecting to both databases. The figure below shows two computers and a number of Oracle7 and Oracle8 clients. On each computer you can have a mix of databases and products in both single and multiple Oracle homes.


Migrate an Oracle7 Database to an Oracle8 Database

Migrate your Oracle7 database to an Oracle8 database and have both Oracle7 and Oracle8 clients connecting to the Oracle8 database. You can migrate your Oracle7 database to an Oracle8 database either in the same Oracle home or in a different Oracle home. See "Migrating an Oracle7 Database to Version 8" for instructions. The figure below illustrates this network configuration:


Upgrade an Oracle8 Database to the Current Oracle8 Database Release

Upgrade your Oracle8 database, for example, release 8.0.4 to release 8.0.6 and have both Oracle7 and Oracle8 clients connecting to the release 8.0.6 Oracle8 database. You can upgrade databases either in the same Oracle home or across different Oracle homes. See "Upgrading an Oracle8 Database Release 8.0.x to 8.0.6" for instructions. The figure below illustrates this network configuration:


Migrate Oracle7 Clients to Oracle8

Migrate some or all of your Oracle7 clients to Oracle8 release 8.0.6 and migrate your Oracle7 database to an Oracle8 database or upgrade your Oracle8 database to the current Oracle8 release at a later date. See Net8 Getting Started for Windows NT and Windows 95/98 for instructions. The figure below illustrates this network configuration.


Multi-Versioning

You can run different versions of Oracle databases on the same computer system at the same time. However, each version can only access a database that is consistent with its version. For example, if you have version 7 and version 8 of Oracle installed on the same computer system, the version 7 server can access version 7 databases, but not version 8 databases, and the version 8 server can access version 8 databases but not version 7 databases. The only way for a version 8 database to read version 7 database files is to perform a migration. You should be aware that after migration, the version 7 database will no longer be able to read the files.

Installing Two or More Databases Into the Same Oracle Home

In the following example, an Oracle7 release 7.3.3 starter database named ORACLE with a SID of ORCL is already installed in C:\ORANT. Now, create an Oracle release 8.0.6 database named PROD with a SID of PROD in C:\ORANT.

To install an Oracle8 database and Oracle7 database into the same Oracle home:

  1. Ensure you have enough hard disk space and RAM for both databases. You need to add the system requirements for Oracle8 Enterprise Edition and Oracle7 Server to determine the total system requirements. See Oracle8 Enterprise Edition Installation for Windows NT for system requirements.

  2. Ensure all Oracle7 services are stopped. See "Managing Oracle Services" for information on how to stop services.

  3. Install Oracle8 Enterprise Edition for Windows NT from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    The Oracle Installation Settings dialog box appears.

    1. Do not enter a value in the Name field of the Oracle Installation Settings dialog box.

    2. Set the Oracle home directory location to the same directory where release 7.3.3 is already installed. In this example, enter C:\ORANT in the Location field of the Oracle Installation Settings dialog box. Click OK.

    The Select Installation Settings dialog box appears.

  4. Select Oracle8 Enterprise Edition from the Select Installation Options dialog box, then click OK.

    The Select Oracle8 Cartridge dialog box appears.

  5. Select any cartridges you are licensed to install, then click OK.

    The Previous Version of Oracle Database Detected dialog box appears indicating that Oracle Installer has detected an earlier version of the database. You are asked if you want to migrate your Oracle7 database to release 8.0.6 using Oracle Data Migration Assistant.

  6. Click No. If you click Yes, Oracle Data Migration Assistant is launched at the end of installation. Do not click Yes to run Oracle Data Migration Assistant while you are installing another database into the same Oracle home as an existing database.

    The Select a Starter Database Configuration dialog box appears.

  7. Select Custom Configuration (allows you to create a customized database).

  8. Complete Oracle8 Enterprise Edition installation. At the end of installation, the Oracle Database Assistant is launched.

    The following Oracle Database Assistant window appears:


  9. Respond to instructions in each Oracle Database Assistant window, and click Next when you are ready to continue to the next window.

  10. When the following Oracle Database Assistant window appears, you will notice that the Database Name and SID fields are automatically set to ORC1. Substitute PROD in both of these fields. Do not set the SID to ORCL, as you will overwrite the Oracle7 release 7.3.3 starter database.


    When you get to the last window, click Finish to start the creation of the PROD database. More documentation is included with the assistant Help.

Installing Databases Into Multiple Oracle Homes

In the following example, an Oracle7 release 7.3.3 starter database called ORACLE with a SID of ORCL is already installed in C:\ORANT. Now, install the Oracle release 8.0.6 starter database ORCL in a separate Oracle home directory called C:\ORANTv8 with an Oracle home name of TESTv8.

To install an Oracle8 database and Oracle7 database in multiple (separate) Oracle homes:

  1. Ensure you have enough hard disk space and RAM for both databases. You need to add the system requirements for Oracle8 Enterprise Edition and Oracle7 Server to determine the total system requirements. See Oracle8 Enterprise Edition Installation for Windows NT for system requirements.

  2. Ensure all Oracle7 services are stopped. See "Managing Oracle Services" for information on how to stop services.

  3. Install Oracle8 Enterprise Edition for Windows NT from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

    The Oracle Installation Settings dialog box appears.

    1. Enter the name of the new Oracle home in the Name field of the Oracle Installation Settings dialog box. In this example, enter TESTv8.

    2. Enter the location of the Oracle home directory where you want to install release 8.0.6. In this example, enter C:\ORANTv8 in the Location field of the Oracle Installation Settings dialog box. Click OK.

    The Select Installation Settings dialog box appears.

  4. Select Oracle8 Enterprise Edition from the Select Installation Options dialog box, then click OK.

    The Select Oracle8 Cartridge dialog box appears.

  5. Select any cartridges you are licensed to install, then click OK.

    The Select a Starter Database Configuration dialog box appears.

  6. Select Typical Configuration (allows you to install a pre-configured starter database).

  7. Complete Oracle8 Enterprise Edition installation.

    During installation of the release 8.0.6 database, Oracle Installer detects the listener of the previously installed release 7.3.3 database. To avoid conflicts of listening addresses (for example, the port number for TCP/IP), the new release 8.0.6 listener is not started and is set to Manual Startup mode. After installation is complete, modify the release 8.0.6 LISTENER.ORA file to resolve possible conflicts in listening addresses, and then start the listener. This is required to enable the release 8.0.6 database to accept connections from clients. See Net8 Getting Started for Windows NT and Windows 95/98 for information on how to modify the LISTENER.ORA file.

Migrating an Oracle7 Database to Version 8

This section describes how to migrate an Oracle7 database to the current Oracle8 database release. You can choose either of the following tools to perform a migration:

Oracle Corporation recommends that new users use Oracle Data Migration Assistant to migrate databases because it is the easiest method to perform a migration. If you want to perform a migration manually using command line tools, use MIG80.

Before you start a migration using the assistant or MIG, read the following sections:

Ten Issues That Can Affect Oracle7 to Oracle8 Migration

The following table lists and describes the ten issues you should be aware of that can affect Oracle7 to Oracle8 migration.

Issues That Affect Migration  Description 
  1. Running out of space

 
  • Version 8 binaries may require as much as three times the disk space required by version 7 binaries. This requirement may cause you to run out of disk space during migration. It is very important that you read "System Considerations and Requirements" and "Prepare the Version7 Source Database for Migration" in Oracle8 Migration to find out more about this and other requirements before you migrate.

  • During migration, the data dictionary requires 50% more space to hold both Oracle7 and Oracle8 data dictionaries. Actual usage can be verified by running MIG in CHECK_ONLY mode.

 
  1. Duration of migration is unrelated to database size

 

The time it takes to migrate is not dependent on the size of the database, but on the number of objects in the data dictionary. For example, actual migration for a 3 1/2 GB database with 25,473 objects on a Sun E6000 with 20 CPUs, with datafiles stripped on the file system on 128 KB slices can take 1 1/2 hours. Remember to allow extra time for backing up and restoring database in case of problems. 

  1. Avoiding problem areas

 
  • Check for usage of ROWIDs in both user columns as well as application code (including triggers & packaged procedures). These may require to be converted to use the DBMS_ROWID package.

  • Check the names of any Oracle7 database objects (for example, tables and columns) that use names that are key words or reserved words for Oracle8i Enterprise Edition. Usage of key words and reserved words can cause unexpected failures during migration. See Appendix C, "Oracle Reserved Words" of Oracle8 SQL Reference for a list of reserved words.

  • Certain version 7 initialization parameters are obsolete in version 8. Remove all obsolete parameters from the release 7.x INITSID.ORA file that start a version 8 instance. Obsolete parameters may cause errors if used with a version 8 database. Also, alter any parameter whose syntax has changed in version 8. See Appendix B, "Changes to Initialization Parameters" of Oracle8 Migration for lists of new, changed, and obsolete parameters.

 
  1. Compatibility

 

Make sure that all Oracle product versions, operating system versions, and third-party software versions are certified against Oracle8. See "Overview" for the list of supported Windows operating systems and versions. See "Oracle Products for Windows NT, Windows 95, and Windows 98" for a list of supported Oracle product versions for this release. 

  1. Invalid objects and lost statistics

 

Migration leaves all objects (packages, triggers, views, and so on) invalid except for tables. All other objects must be made valid again by recompilation. This can either be done manually (preferably by building a dependency tree before migration from dependency), otherwise this is done automatically as the objects are first accessed. The latter will of course slow down initial access. All estimated or calculated statistics are lost during migration. These need to be recalculated to ensure proper functionality of the Cost Based Optimizer. Some bitmapped indexes will get invalidated. Check all bitmapped indexes in the DBA_INDEXES table and recreate any that are marked as status unusable. 

  1. Editing the registry

 

If you edit the registry for any reason during the migration process, you need to reboot your computer. 

  1. Read-only tablespace confusions

 

Oracle7 read-only tablespaces are readable by Oracle8 and do not require any conversion. But to prevent Oracle8 rowid conversions to take place every time a table is accessed, the tablespaces in read-only mode should be made read-write. Perform full table scans on all tables in the tablespace. After the full table scans are complete, you can put the tablespaces in read-only mode again.  

  1. The point of no return

 

You can return the database to an Oracle7 version up until the ALTER DATABASE CONVERT command is run. If a failure occurs during ALTER DATABASE CONVERT (when it is converting the physical file headers of the datafiles), you must restore the database from backup and rerun the migration. Do not open the database between running the migration and executing the ALTER DATABASE CONVERT command.  

  1. Preventing large restores

 

To avoid restoring the entire database due to any failures during the ALTER DATABASE CONVERT, put all tablespaces, except SYSTEM and ROLLBACK into read-only or offline normal mode. This causes the ALTER DATABASE CONVERT command to only convert the datafile headers for SYSTEM and ROLLBACK. If any errors occur, you need only restore the datafiles for the SYSTEM and ROLLBACK and rerun the migration. If the migration is successful, the headers for the rest of the datafiles will be converted when they are read-write or online.  

  1. Testing

 

Most migration problems can be avoided if a test migration is performed first. Performing a test migration helps raise any problems that can occur as well as letting you see the amount of time it takes to migrate. See "Test the Migration Process" in Chapter 2, "Preparing to Migrate" in Oracle8 Migration

Migration Networking Issues

If you perform a migration, you may need to resolve the following networking issues:

Migrating Oracle7 Clients

Although Oracle7 clients using SQL*Net Client version 2.x can connect to Oracle8 databases, they should be migrated to Oracle8 clients configured with Net8 when their applications are upgraded to version 8. Note that SQL*Net version 2.x can coexist with Net8 in the same Oracle home directory.

Using the Net8 Listener

To use the Net8 listener, you may need to change your network configuration on either the SQL*Net version 2.x or Net8 configurations to prevent a conflict. For example, you may need to change:

You may also need to start the Net8 listener and change the status of the service to Automatic Startup, depending upon your network needs. If you make changes to the listener, you must make changes to client configuration files to reflect those listener changes.

SQL*Net version 2.x uses configuration files from ORACLE_HOME\NETWORK\ADMIN, while Net8 uses files from ORACLE_HOME\NET80\ADMIN by default. If you want SQL*Net version 2.x and Net8 to use configuration files from the same directory, you can set the registry variable TNS_ADMIN.

Additional Information:

See Net8 Getting Started for Windows NT and Windows 95 for more information on setting TNS_ADMIN. 

Editing the LISTENER.ORA File for Multiple Oracle Homes

Using MIG80

When you migrate from an Oracle7 database in one Oracle home to an Oracle8 database release 8.0.6 in a different Oracle home, remove the SID from the Oracle7 Oracle home's LISTENER.ORA file and add it to the release 8.0.6 Oracle home's LISTENER.ORA file.

Using Oracle Data Migration Assistant

When you migrate from an Oracle7 database in one Oracle home to an Oracle8 database release 8.0.6 in a different Oracle home, the assistant does not remove the SID from the Oracle7 Oracle home's LISTENER.ORA file. To prevent a conflict when you start the Oracle7 listener, remove the SID entry from the Oracle7 Oracle home's LISTENER.ORA file.

Installing Appropriate Versions of SQL*Net

When migrating from Oracle7 Server release 7.3.x to Oracle8 release 8.0.6, install the appropriate version of SQL*Net for the server before using Oracle Data Migration Assistant or MIG80. Migration will be unsuccessful if you do not install the appropriate versions of SQL*Net. You do not need to install a SQL*Net patch when migrating from Oracle7 release 7.3.4 to Oracle8 release 8.0.6.

Migrating from...  Install... 

Oracle7 release 7.3.2.x and higher to Oracle8 

SQL*Net release 2.3.2.1.4 and SQL*Net patch 2.3.2.1.12

Note: If you do not have SQL*Net release 2.3.2.1.4 on your system, you must install it before installing SQL*Net patch 2.3.2.1.12. SQL*Net release 2.3.2.1.4 is not available on the release 8.0.6 CD-ROM. You must install it from the release 7.3.2 CD-ROM. 

Oracle7 release 7.3.3.x and higher to Oracle8 

SQL*Net release 2.3.3.0.3 

 

To install SQL*Net patch 2.3.2.1.12 or 2.3.3.0.3:

  1. Start Oracle Installer from the CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

  2. Answer questions about language and Oracle home directory location.

  3. Select Custom Installation. The Software Asset Manager window appears.

  4. Click From...

  5. Navigate to \PATCHES\SQLNET\232112 on the CD-ROM if you want to install SQL*Net patch 2.3.2.1.12. Navigate to \PATCHES\SQLNET\23303 if you want to install SQL*Net release 2.3.3.0.3.

  6. Select SQL*Net Server 2.3.2.1.12 and SQL*Net Client 2.3.2.1.12 if you want to install SQL*Net patch 2.3.2.1.12. Select SQL*Net Server 2.3.3.0.3 and SQL*Net Client 2.3.3.0.3 if you want to install SQL*Net patch 2.3.3.0.3.

  7. Click Install.

    A window appears showing the progress of the installation. After installation is complete, a message appears confirming the installation.

  8. Click Exit to quit Oracle Installer.

 

Migrating Using Oracle Data Migration Assistant

Oracle Data Migration Assistant helps you migrate data from an Oracle7 database to an Oracle8 database. During installation of Oracle8 Enterprise Edition, you are prompted to migrate a database with this assistant if Oracle Installer detects that an earlier database release exists on your computer. If you do not want to migrate a database during the installation process, you can just install the assistant and use it later.

What To Do Before Using Oracle Data Migration Assistant

Complete the following steps before you use this assistant:

To migrate a database using Oracle Data Migration Assistant:

  1. Install Oracle Data Migration Assistant from the Oracle8 Enterprise Edition for Windows NT CD-ROM. See Oracle8 Enterprise Edition Installation for Windows NT for complete installation instructions.

  2. Choose Start > Programs > Oracle for Windows NT - [HOME_NAME] > Oracle Data Migration Assistant.

    The Oracle Data Migration Assistant welcome window appears:


  3. Respond to instructions in each Oracle Data Migration Assistant window, and click Next when you are ready to continue to the next window. When you get to the last window, click Finish to start the migration of the database. More documentation on this product is included with the Help.

Migrating Using MIG80

This section describes how to use MIG80 to migrate your Oracle7 database to an Oracle8 database.


Note:

Information on how to run MIG80 (sometimes referred to as the Migration Utility) is provided in Oracle8 Migration, but the focus is on UNIX. This section provides information on using MIG80 on Windows NT. 


To migrate an Oracle7 database using MIG80:

Step 1: What To Do Before Using MIG80

Step 2: Prepare for Database Backup

Step 3: Shut Down the Oracle7 Database

Step 4: Back Up the Oracle7 Database

Step 5: Install MIG80 From Oracle8 Enterprise Edition CD-ROM

Step 6: Run MIG80

Step 7: Create Oracle8 Services and Database Files

Step 8: Remove Oracle7 Software (Optional)

Step 1: What To Do Before Using MIG80

Complete the following steps before you use MIG80:

Review Migration Concepts

Use Appropriate SQL*DBA or Server Manager Versions

When you are asked to enter commands at the SQL*DBA or Server Manager prompt, remember to use the appropriate version of the tool for the version of Oracle7 Server you are migrating:

Use...  When Migrating From... 

SQLDBA71 

Oracle7 release 7.1.x 

SQLDBA72 

Oracle7 release 7.2.x 

SVRMGR23 

Oracle7 release 7.3.x 

Check Database To Be Migrated Version Number

Check that your database release can be directly migrated to Oracle8 Enterprise Edition. MIG80 only migrates databases that are Oracle7, release 7.1.x or later. If the database is an earlier version (for example, version 6), migrate it to at least Oracle7 release 7.1.3.3.6 before migrating it to an Oracle8 database.

Check Character Set

  1. Check the character set of your Oracle7 database, and compare it with the character set in the NLS_LANG environment variable, or in the registry (if the character set does not exist as an environment variable). See "NLS_LANG Parameters and Components" for information on how to check the value of NLS-LANG.

  2. Start Server Manager or SQL*DBA at the MS-DOS command prompt. If you are migrating from:

    Oracle7 Release...  Enter at the MS-DOS Command Prompt... 

    7.1.x 

    C:\> SQLDBA71 MODE=LINE 

    7.2.x 

    C:\> SQLDBA72 MODE=LINE 

    7.3.x 

    C:\> SVRMGR23 

  3. Connect to the Oracle7 database as INTERNAL, where PASSWORD is the password of the database you want to migrate:

    Oracle7 Release...  Enter at the SQLDBA or SVRMGR Command Prompt... 

    7.1.x 

    SQLDBA> CONNECT INTERNAL/PASSWORD 

    7.2.x 

    SQLDBA> CONNECT INTERNAL/PASSWORD 

    7.3.x 

    SVRMGR> CONNECT INTERNAL/PASSWORD 

  1. Obtain the value of NLS_CHARACTERSET:

    Oracle7 Release...  Enter at the SQLDBA or SVRMGR Command Prompt... 

    7.1.x 

    SQLDBA> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET'; 

    7.2.x 

    SQLDBA> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET'; 

    7.3.x 

    SVRMGR> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET'; 

The character set value is returned by the database. If the character sets are identical, then you can proceed to run MIG80.

If the character sets are different, before you run MIG80, you must set the NLS_LANG environment variable at the MS-DOS command prompt as follows:

AMERICAN_AMERICA.database character set

where database character set is substituted with the character set of your Oracle7 database. For example, if the character set of your Oracle7 database is JA16EUC, set the NLS_LANG environment variable as follows:

C:\> SET NLS_LANG=AMERICAN_AMERICA.JA16EUC 

Messages output from MIG80 will now be in English. After MIG80 finishes, reset the NLS_LANG environment variable to its original value.

Step 2: Prepare for Database Backup


Prev Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index