Oracle9i Database Migration
Release 1 (9.0.1)
Part Number A90191-02

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

1 Introduction

Terminology

Versions and Releases

Migration vs. Upgrading

Source Database and Target Database

Running Multiple Versions and Releases of Oracle

Install Version 7 and Version 8 Databases in Multiple Oracle Homes

Install Version 7 and Version 8 Databases on Separate Computers

Migrate a Version 7 Database to a Version 8 Database

Upgrade a Release 8.0 Database to a Release 9.0.0 Database

Upgrade a Release 8.1 Database to the Current Release

Migrate Version 7 Clients to Version 8 Clients

Using Optimal Flexible Architecture (OFA)

Running Scripts

Changing Word-Size

Rolling Upgrades for Oracle9i Real Application Clusters

Deinstalling Options

2 Overview of Migration

Overview of Migration Steps

Step 1: Prepare to Migrate

Step 2: Test the Migration Process

Step 3: Test the Migrated Test Database

Step 4: Prepare and Preserve the Source Database

Step 5: Migrate the Production Database

Step 6: Tune and Adjust the New Production Database

Role of the Database Administrator During Migration

Role of the Application Developer During Migration

3 Preparing to Migrate

Prepare to Migrate

Become Familiar with the Features of the New Database

Choose a Migration Method

Assess System Requirements vs. Resources Available

Choose an Oracle Home Directory for the New Release

Avoid Common Migration Problems

Prepare a Backup Strategy

Develop a Testing Plan

Test the Migration Process

Test the Migrated Test Database

4 Migrating from Oracle7 Using the Migration Utility

Documentation Roadmap for Using the Migration Utility

Overview of Migration Using the Migration Utility

Outline of the Migration Process

Using the Migration Utility

System Considerations and Requirements

Space Requirements

Block Size Considerations

Considerations for SQL*Net

Considerations for Replication Environments

Migrating a System with Oracle Parallel Server Installed

Considerations for Migrating from ConText to Oracle Text

Migrating to a Different Operating System

Character Set Considerations

Distributed Database Considerations

Prepare the Oracle7 Source Database for Migration

Prepare for Migration on Windows Platforms

Install the Release 9.0.1 Oracle Software

After Installing Oracle9i on a Windows Platform

Review Migration Utility Command-Line Options

Migrate the Oracle7 Source Database

Prepare the Oracle7 Environment for Migration on UNIX Operating Systems

Perform Migration Steps in the Oracle7 Environment

Run the Migration Utility

Check the Migration Results

Preserve the Oracle7 Source Database

Perform Migration Steps in the Oracle9i Environment

Troubleshooting Errors During Migration

Abandoning the Migration

5 Migrating from Oracle7 Using the Oracle Data Migration Assistant

Documentation Roadmap for Using the Oracle Data Migration Assistant

Overview of Migration Using the Oracle Data Migration Assistant

Restrictions Related to the Oracle Data Migration Assistant

Start with an Oracle7 Database Supported by the Oracle Data Migration Assistant

System Considerations and Requirements

Space Requirements

Block Size Considerations

Considerations for SQL*Net

Considerations for Replication Environments

Considerations for Migrating from ConText to Oracle Text

Migrating to a Different Operating System

Character Set Considerations

Distributed Database Considerations

Prepare the Oracle7 Source Database for Migration

Prepare for Migration on a Windows Platform

Install the Release 9.0.1 Oracle Software and Migrate the Database

Running the Oracle Data Migration Assistant Independently

Finish the Migration

Troubleshooting Errors During Migration

Abandoning the Migration

6 Migrating Using Export/Import

Basics of Export/Import

Export Utility Requirements

Import Utility Requirements

Additional Options

Migrate the Source Database Using Export/Import

7 Upgrading from an Older Release of Oracle to the New Oracle9i Release

Upgrade Paths

Upgrading the Database to the New Oracle9i Release

Character Set Considerations

Considerations for Replication Environments

Upgrading Oracle Parallel Server

Prepare to Upgrade

Upgrade the Database

Upgrading Specific Components

Upgrading JServer

Upgrading XDK for Java

Upgrading Session Namespace, CORBA, and OSE

Upgrading Oracle Spatial

Upgrading interMedia

Upgrading Oracle Text

Upgrading Oracle Label Security

Upgrading Oracle9i Real Application Clusters

Upgrading Materialized Views

Upgrading the Advanced Queuing Option

Upgrading the Recovery Catalog

Upgrading Statistics Tables Created by the DBMS_STATS Package

Recompiling Invalid PL/SQL Modules

Changing the Word-Size of Your Current Release

8 After Migrating or Upgrading the Database

Tasks to Complete After Migrating or Upgrading Your Database

Back Up the Database

Change the Passwords for Oracle-Supplied Accounts

Upgrade User NCHAR Columns

Migrate Your Initialization Parameter File to a Server Parameter File

Install Component Java Classes

Migrate Tables from LONGs to LOBs

Check for Bad Date Constraints

Migrate Your Server Manager Line Mode Scripts to SQL*Plus

Avoid Problems with Parallel Execution

Modify Your listener.ora File

Migrate or Upgrade Your Standby Database

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

Adjust Your Initialization Parameter File for the New Release

Normalize Filenames on Windows Platforms

Tasks to Complete Only After Migrating Your Database

Rebuild Unusable Bitmap Indexes

Migrate Partition Views to Partition Tables

Migrate or Upgrade to the New Release of Oracle Net (Optional)

Test the Database and Compare Results

Tune the Migrated Database

Task to Complete Only After Upgrading Your Database

Rebuild Unusable Function-Based Indexes

9 Compatibility and Interoperability

What Is Compatibility?

The COMPATIBLE Initialization Parameter

Features Requiring 9.0.0 or Higher Compatibility Level

Built-In Datatypes

User-Defined Datatypes

Data Protection

Distributed Databases

Data Warehousing

Features Requiring 8.1.0 or Higher Compatibility Level

Built-In Datatypes

User-Defined Datatypes

Oracle Parallel Server

Data Protection

Distributed Databases

Data Warehousing

Spatial and Visual Information

What Is Interoperability?

Compatibility and Interoperability Issues

The STARTUP Command

Tablespaces and Datafiles

Data Dictionary

User-Defined Datatypes

Advanced Queuing (AQ)

Procedures and Packages

Oracle Optimizer

Oracle9i Real Application Clusters

Database Security

Database Backup and Recovery

Distributed Databases

SQL*Net or Oracle Net

Miscellaneous Compatibility and Interoperability Issues

10 Upgrading Your Applications

Overview of Upgrading Applications to Oracle9i

Compatibility Issues for Applications

Upgrading Precompiler and OCI Applications

Understanding Software Upgrades and Your Client/Server Configuration

Compatibility Rules for Applications When Upgrading Oracle Software

Upgrading Options for Your Precompiler and OCI Applications

Upgrading SQL*Plus Scripts

Upgrading Oracle7 Forms or Oracle Developer Applications

11 Migrating from Server Manager to SQL*Plus

Startup Differences

Starting Server Manager

Starting SQL*Plus

Commands Introduced in SQL*Plus Release 8.1

Commands Common to Server Manager and SQL*Plus

SQL*Plus Equivalents for Server Manager Commands

Possible Differences in the SET TIMING Command

Server Manager Commands Unavailable in SQL*Plus

Syntax Differences

The Hyphen Continuation Character

CREATE TYPE and CREATE LIBRARY Commands

12 Migration Issues for Physical Rowids

Migrating Applications and Data

The DBMS_ROWID Package

Rowid Conversion Types

Rowid Conversion Functions

Conversion Procedure Examples

Snapshot Refresh

Version 7 and Version 6 Client Compatibility Issues

ROWID Migration and Compatibility Issues

Accessing an Oracle7 Database from an Oracle9i Client

Accessing an Oracle9i Database from an Oracle7 Client

Import and Export

Frequently Asked Questions About Rowid Migration

13 Downgrading to Release 8.1

Perform a Full Offline Backup

Remove Incompatibilities

Checking the Compatibility Level of Your Database

Reset Database Compatibility

Downgrade the Database

Regenerating Replication Support

14 Removing Incompatibilities Before Downgrading to Release 8.1

Identifying Incompatibilities

Removing Incompatibilities Before Downgrading to Release 8.1.6 or Release 8.1.7

User-Defined Datatypes

Constraints and Triggers

Removing Incompatibilities Before Downgrading to Release 8.1.5

Constraints and Triggers

Advanced Queuing (AQ)

Continue with Your Downgrade to Release 8.1

15 Downgrading to an Older Release of Oracle

Downgrading from Oracle9i to Release 8.0

Downgrading a Database That Does Not Contain New or Changed Data

Downgrading a Database That Contains New or Changed Data

Alternative Downgrading Methods

Downgrading from Oracle9i to Oracle7

Downgrading a Database That Does Not Contain New or Changed Data

Downgrading a Database That Contains New or Changed Data

Alternative Downgrading Methods

A Troubleshooting Migration Problems

Expected Errors During Upgrade

Problems Using the Migration Utility or the Oracle Data Migration Assistant

Insufficient Space in the SYSTEM Tablespace

Incorrect AUDIT_TRAIL Parameter Setting

OPTIMAL Setting for the SYSTEM Rollback Segment

Small MULTIPLIER Option Setting

Problems at the ALTER DATABASE CONVERT Statement

Oracle7 Control Files Exist

Database Started in Mode Other Than NOMOUNT

Convert File Not Found

REMOTE_LOGIN_PASSWORDFILE Initialization Parameter Set to EXCLUSIVE

Database Name Mismatch

Rerunning the ALTER DATABASE CONVERT Statement

Datafile Version Integrity Problem

Problems While Running the Manual Migration and Upgrade Scripts

Script Runs for an Inordinately Long Time

Migration Utility Messages

B Changes to Initialization Parameters

Changes to Initialization Parameters in Oracle9i

Initialization Parameters Added in Oracle9i

Initialization Parameters Renamed in Oracle9i

Initialization Parameters Obsolete in Oracle9i

Changes to Initialization Parameters in Version 8

Initialization Parameters Added in Version 8

Initialization Parameters Renamed in Version 8

Initialization Parameters Obsolete in Version 8

Compatibility Issues with Initialization Parameters

New Default Value for DB_BLOCK_CHECKSUM

Maximum Number of Job Queue Processes

The ORACLE_TRACE_ENABLE Parameter

The SERIALIZABLE Parameter

SORT_AREA_SIZE and SORT_DIRECT_WRITES Parameters

New Default Value for LOG_CHECKPOINT_TIMEOUT

The O7_DICTIONARY_ACCESSIBILITY Parameter

The DML_LOCKS Parameter

The DB_DOMAIN Parameter

Parallel Execution Allocated from Large Pool

Archive Log Destination Parameters

C Changes to Static Data Dictionary Views

Changes to Static Data Dictionary Views in Oracle9i

Static Data Dictionary Views Added in Oracle9i

Static Data Dictionary Views Renamed in Oracle9i

Static Data Dictionary Views with Added Columns in Oracle9i

Changes to Static Data Dictionary Views in Version 8

Static Data Dictionary Views Added in Version 8

Static Data Dictionary Views with Added Columns in Version 8

Static Data Dictionary Views with Dropped Columns in Version 8

Static Data Dictionary Views with Renamed Columns in Version 8

Static Data Dictionary Views with Columns That May Return Nulls

Static Data Dictionary Views Obsolete in Version 8

D Changes to Dynamic Performance Views

Changes to Dynamic Performance Views in Oracle9i

Dynamic Performance Views Added in Oracle9i

Dynamic Performance Views Renamed in Oracle9i

Dynamic Performance Views with Dropped Columns in Oracle9i

Dynamic Performance Views Obsolete in Oracle9i

Changes to Dynamic Performance Views in Version 8

Dynamic Performance Views Added in Version 8

Dynamic Performance Views with Added Columns in Version 8

Dynamic Performance Views with Dropped Columns in Version 8

Dynamic Performance Views with Renamed Columns in Version 8

Dynamic Performance Views Obsolete in Version 8

E New Internal Datatypes and SQL Functions

Internal Datatypes and SQL Functions Added in Oracle9i

Internal Datatypes Added in Oracle9i

SQL Functions Added in Oracle9i

Internal Datatypes and SQL Functions Added in Version 8

Internal Datatypes Added in Version 8

SQL Functions Added in Version 8

F Migration and Compatibility for Oracle Net Services

Overview of Unsupported Oracle Net Services Features in Release 9.0

Unsupported Parameters

Unsupported Control Utility Commands

Client and Database Coexistence Issues

Oracle9i Database Connections

Oracle8 or Oracle7 Database Connections

Using the Oracle Net Manager to Handle Compatibility Issues

Migrating and Upgrading to Oracle Net Services Release 9.0

Step 1: Verify Service Name and Instance Name

Step 2: Perform Software Upgrade or Migration on the Server

Step 3: Perform Software Migration or Upgrade on the Client

Step 4: Perform Functional Upgrade and Migration

Using Oracle Names Version 9

Migrating from Oracle Names Version 2 Using a Database

Migrating from Oracle Names Version 2 with the Dynamic Discovery Option

Migrating from ROSFILES

Migrating Region Checkpoint Files to Domain and Topology Checkpoint Files

Reviewing Migration Checklist

G Migration and Compatibility for Replication Environments

Migration Overview for Replication

Migrating All Sites at Once

Migrating Incrementally

Preparing Oracle7 Master Sites for Incremental Migration

Incremental Migration of Materialized View Sites

Incremental Migration of Master Sites

Upgrading to Primary Key Materialized Views

Primary Key Materialized View Conversion at Master Sites

Primary Key Materialized View Conversion at Materialized View Sites

Features Requiring Migration to a Higher Release of Oracle

Features Requiring Oracle9i

Features Requiring Oracle8i or Higher

Features Requiring Oracle8 or Higher

Features That Work with Oracle7 and Higher Releases

Obsolete Procedures

Index

Oracle

Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.