Oracle8i Migration

Terminology

Running Scripts

Changing Word-Size

Using Optimal Flexible Architecture (OFA)

Rolling Upgrades for Oracle Parallel Server

Deinstalling Options

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

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

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 Replication Environments

Migrating a System with Oracle Parallel Server Installed

Migrating to a Different Operating System

Character Set Considerations

Prepare the Oracle7 Source Database for Migration

Install the Release 8.1 Oracle Software

Review Migration Utility Command-Line Options

Migrate the Oracle7 Source Database

Prepare the Oracle7 Environment for Migration

Migration Steps in the Oracle7 Environment

Preserve the Oracle7 Source Database

Migration Steps in the Oracle8i Environment

Troubleshooting Errors During Migration

Abandoning the Migration

Documentation Roadmap for Using the Oracle Data Migration Assistant

Overview of Migration Using the Oracle Data Migration Assistant

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

Downgrading

System Considerations and Requirements

Space Requirements

Block Size Considerations

Considerations for Replication Environments

Migrating to a Different Operating System

Character Set Considerations

Prepare the Oracle7 Source Database for Migration

Install the Release 8.1 Oracle Software and Migrate the Database

Running the Oracle Data Migration Assistant Independently

Finish the Migration

Troubleshooting Errors During Migration

Abandoning the Migration

Basics of Export/Import

Export Utility Requirements

Import Requirements

Additional Options

Migrate the Pre-Release 8.0 Source Database Using Export/Import

Back Up the Migrated Database

Check for Bad Date Constraints

Rebuild Unusable Bitmap Indexes

Avoid Problems with Parallel Execution

Migrate Partition Views to Partition Tables

Change the Password for the OUTLN User

Migrate or Upgrade to the New Release of Net8 (Optional)

Modify Your listener.ora File

Test the Database and Compare Results

Tune the Migrated Database

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

Upgrade Paths

Upgrading the Database to the New Oracle8i Release

Prepare to Upgrade

Upgrade the Database

Upgrading Specific Components

Upgrading Advanced Replication

Upgrading Oracle Parallel Server

Upgrading Snapshots

Upgrading the Advanced Queuing Option

Upgrading User-Defined Datatypes

Upgrading the Recovery Catalog

Recompiling Invalid PL/SQL Modules

After Upgrading to the New Release

Using the New TO_LOB Operator

Checking for Bad Date Constraints

Avoiding Problems with Parallel Execution

Adjusting Your INITsid.ORA File for the New Release

Changing the Password for the OUTLN User

Modify Your listener.ora File

Drop Java Objects

Changing the Word-Size of Your Current Release

What Is Compatibility?

The COMPATIBLE Parameter

Features Requiring 8.1.0 or Higher Compatibility Level

User-Defined Datatypes

Oracle Parallel Server

Data Protection

Distributed Databases

Data Warehousing

Data Access

Spatial and Visual Information

What Is Interoperability?

Compatibility and Interoperability Issues

Applications

Startup and Shutdown

Tablespaces and Datafiles

Data Dictionary

Schema Objects

Datatypes

User-Defined Datatypes

SQL and PL/SQL

Advanced Queuing (AQ)

Procedures and Packages

Oracle Optimizer

Oracle Parallel Server

Database Security

Database Backup and Recovery

Distributed Databases

SQL*Net or Net8

Export/Import

Miscellaneous Compatibility and Interoperability Issues

Overview of Upgrading Applications to Oracle8i

Upgrading OCI and Precompiler Applications

Upgrading OCI Applications

Upgrading Precompiler Applications

Upgrading SQL*Plus Scripts

Upgrading Oracle7 Forms or Developer/2000 Applications

Copying LONGs to LOBs

Startup Differences

Starting Server Manager

Starting SQL*Plus

Commands

New SQL*Plus Release 8.1 Commands

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

Comments

Blank Lines

The Hyphen Continuation Character

Ampersands

CREATE TYPE and CREATE LIBRARY Commands

COMMIT Command

Migrating Applications and Data

The 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

Perform a Full Offline Backup

Remove Incompatibilities

User-Defined Datatypes

SQL and PL/SQL

Java

Advanced Queuing (AQ)

Procedures and Packages

Constraints and Triggers

Oracle Optimizer

Security

Database Backup and Recovery

Distributed Databases

Net8

Reset Database Compatibility

Downgrade the Database

Regenerating Advanced Replication Support

Re-Installing the UTL_REF Package on Release 8.0.4

Re-Installing Recovery Manager Packages on Release 8.0.3

Overview of Downgrading from Oracle8i 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

Problems Using the Migration Utility or Oracle Data Migration Assistant

General Migration Problems

Migration Utility Errors

Problems at the ALTER DATABASE CONVERT Command

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 Command

Datafile Version Integrity Problem

Initialization Parameters Added in Version 8

Initialization Parameters Added in Release 8.0

Initialization Parameters Added in Release 8.1

Initialization Parameters Renamed in Version 8

Initialization Parameters Renamed in Release 8.0

Initialization Parameters Renamed in Release 8.1.4

Initialization Parameters Renamed in Release 8.1.5

Initialization Parameters Obsolete in Version 8

Initialization Parameters Obsolete in Release 8.0

Initialization Parameters Obsolete in Release 8.1

Compatibility Issues with Initialization Parameters

New Default Value for LOG_CHECKPOINT_TIMEOUT

Data Dictionary Protection

The DML_LOCKS Parameter

The DB_DOMAIN Parameter

Parallel Execution Allocated from Large Pool

Archive Log Destination Parameters

Static Data Dictionary Views Added in Version 8

Static Data Dictionary Views Added in Release 8.0

Static Data Dictionary Views Added in Release 8.1

Static Data Dictionary Views with Added Columns in Version 8

Static Data Dictionary Views with Added Columns in Release 8.0

Static Data Dictionary Views with Added Columns in Release 8.1

Static Data Dictionary Views with Dropped Columns in Version 8

Static Data Dictionary Views with Dropped Columns in Release 8.0

Static Data Dictionary Views with Dropped Columns in Release 8.1

Static Data Dictionary Views with Renamed Columns in Version 8

Static Data Dictionary Views with Renamed Columns in Release 8.0

Static Data Dictionary Views with Columns That May Return Nulls

Static Data Dictionary Views Obsolete in Version 8

Static Data Dictionary Views Obsolete in Release 8.0

Static Data Dictionary Views Obsolete in Release 8.1

Dynamic Performance Views Added in Version 8

Dynamic Performance Views Added in Release 8.0

Dynamic Performance Views Added in Release 8.1

Dynamic Performance Views Renamed in Version 8

Dynamic Performance Views Renamed in Release 8.1

Dynamic Performance Views with Added Columns in Version 8

Dynamic Performance Views with Added Columns in Release 8.0

Dynamic Performance Views with Added Columns in Release 8.1

Dynamic Performance Views with Dropped Columns in Release 8.1

Dynamic Performance Views with Dropped Columns in Release 8.1

Dynamic Performance Views Obsolete in Version 8

Dynamic Performance Views Obsolete in Release 8.1

Date Columns in Dynamic Performance Views

Internal Datatypes Added in the New Release

Internal Datatypes Added in Release 8.0

Internal Datatype Added in Release 8.1

SQL Functions Added in the New Release

SQL Functions Added in Release 8.0

SQL Functions Added in Release 8.1

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

2 Preparing to Migrate

3 Migrating Using the Migration Utility

4 Migrating Using the Oracle Data Migration Assistant

5 Migrating Using Export/Import

6 After Migrating the Database

7 Upgrading to the New Oracle8i Release

8 Compatibility and Interoperability

9 Upgrading Your Applications

10 Migrating from Server Manager to SQL*Plus

11 Migration Issues for Physical Rowids

12 Downgrading to an Older Version 8 Release

13 Downgrading to Oracle7

A Troubleshooting Migration Problems

B Changes to Initialization Parameters

C Changes to Static Data Dictionary Views

D Changes to Dynamic Performance Views

E New Internal Datatypes and SQL Functions

Index