Oracle8 Migration
Release 8.0
A58243-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience and Assumed Knowledge

How Oracle8 Server Migration is Organized

Conventions Used in This Manual

Your Comments Are Welcome

1 Migration Overview

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 Version 8 Production Database

Role of the Database Administrator During Migration

Role of the Application Developer During Migration

2 Preparing to Migrate

Step 1: Prepare to Migrate

Become Familiar with the Features of the New Version 8 Database

Choose a Migration Method

Assess System Requirements vs. Resources Available

Start with Oracle Version 7, Release 7.X or Higher

Avoid Common Migration Problems

Prepare a Backup Strategy

Develop a Testing Plan

Step 2: Test the Migration Process

Step 3: Test the Migrated Test Database

3 Migrating Using the Migration Utility

Overview of Migration Using the Version 8 Migration Utility

Outline of the Migration Process

Using the Migration Utility

System Considerations and Requirements

Space Requirements

Block Size Considerations

Considerations for Replication Environments

Migrating to a Different Computer Architecture

Character Encoding Considerations

Prepare the Version 7 Source Database for Migration

Install the Version 8 Migration Utility

Review Version 8 Migration Utility Command Line Options

Migrate the Version 7 Source Database

Migration Steps in the Version 7 Environment

Preserve the Version 7 Source Database

Migration Steps in the Version 8 Environment

Errors During Migration

Abandoning the Migration

4 Migrating Using Export/Import

Basics of Export/Import

Export Requirements

Import Requirements

Additional Export/Import Information Sources

Additional Options

Migrate the Pre-Version 8 Source Database Using Export/Import

5 After Migrating the Database

Back Up the Version 8 Database

Check for Bad Date Constraints

Rebuild Invalidated Bitmap Indexes

Test the Database and Compare Results

Tune the Target Database

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

6 Upgrading Version 7 Applications

Upgrading Oracle Applications to Version 8

XA Calls: Incompatibility with Release 7.1 XA Calls

Upgrading Precompiler and OCI Applications

Upgrading Precompiler Applications

Simplified Upgrading of Existing Applications

Upgrading OCI Applications: Enabling Constraints

OCI Application Link Line

Applications Using Version 6 OCI Libraries

Upgrading LONGs to LOBs

Upgrading Version 7 Forms or Developer/2000 Applications

Data Dictionary Views Update

Upgrading SQL*Plus Scripts

PL/SQL V2 Compatibility Mode

PLSQL_V2_COMPATIBILITY Flag

Keyword Behavior Differences: Version 7 vs. Version 8

New Keywords or Types Behavior Differences: Version 7 vs. Version 8

SQL*Net or Net8

Upgrading SQL*Net V1 to SQL*Net V2

Version 7 Net2 Clients and Connection Manager

Net8 Features Available to Relinked Version 7 Clients

Version 8 Net8 Clients

Backup Management: EBU and Recovery Manager

Dictionary Protection

Password Management

Version 7 or Lower Client with Version 8 Server

Version 8 Client with Version 7 or Lower Server

Export/Import Usage, Partitioned Objects

Migration and Compatibility Issues for Thread Safety, OCI

Upgrade and Compatibility Issues for Standby Database

Compatibility Issues for Export/Import

Downward Compatibility Techniques and Limitations

NCHAR and NLS Use

Migration and NCHAR and NLS

NCHAR and NLS Compatibility and Interoperability

7 Migration Issues for the Version 8 ROWIDs

Migrating Applications and Data

DBMS_ROWID Package

ROWID Conversion Types

ROWID Conversion Functions

Conversion Procedure Examples

Snapshot Refresh

Pre-Version 8 Client Compatibility Issues

ROWID-Related Migration Questions and Answers

8 Upgrading and Downgrading

Upgrading to a New Version 8 Release

Product Configurations and Upgrading

Upgrading the Advanced Queuing Option

New Fields Enabled for the AQ$_AGENT Data Type

The Extended Address Field

New Dictionary Tables

Downgrading from Release 8.0.4 to Release 8.0.3

Downgrading Version 8 to Release 7.x

A Migration Utility Messages

B Control File Fixed View Changes

Date Columns in Control File Views

Obsolete Views Kept in Version 8

V$LOG_HISTORY Retained and Upgraded

V$ARCHIVED_LOG Replaces V$LOG_HISTORY

V$BACKUP_CORRUPTION

V$BACKUP_DATAFILE

V$BACKUP_DEVICE

V$BACKUP_REDOLOG

V$CONTROLFILE_RECORD_SECTION

V$COPY_CORRUPTION

V$DATABASE New Columns

V$DATAFILE New Columns

V$DATAFILE_COPY

V$DATAFILE_HEADER

V$DELETED_OBJECT

V$OFFLINE_RANGE

V$RESOURCE_LIMIT

Changed Column Types

Database Scheduling Facilities

Changed Fixed Views

New Fixed Views

Table (View) Name Changes

C Version 8 INIT.ORA Changes

COMPATIBLE Parameter

Migrating or Upgrading to Release 8.0.4

Data Dictionary Protection

NCHAR and NLS Parameters and Compatibility

Pre-Version 8 Parameters Renamed in Version 8

Release 7.3 Parameters Obsolete in Version 8

REPLICATION_DEPENDENCY_TRACKING for the Replication Server

Features No Longer Supported in Version 8

SERIALIZABLE=TRUE or _SERIALIZABLE

D New SQL Key and Reserved Words

E General System Requirements for Migration

Memory Requirements

Basic Memory Requirements

Version 8 Executables

Concurrent Access

Using Oracle Parallel Server

Version 8 New Sizes and Limits

CHAR and NCHAR Maximum Size Support

Copyright © 1997 Oracle Corporation.
All Rights Reserved.