Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

1 Introduction

Terminology

Oracle Releases

Database Migration

Overview of Database Migration

Overview of Upgrade Steps

Role of the Database Administrator During the Upgrade

Role of the Application Developer During the Upgrade

Running Multiple Oracle Releases

Install Databases in Multiple Oracle Homes on the Same Computer

Install Databases in Multiple Oracle Homes on Separate Computers

Upgrade a Database to the Current Release

Upgrade Clients to the Current Release

Using Optimal Flexible Architecture (OFA)

Changing Word Size

Rolling Upgrades

Deinstalling Options

2 Preparing to Upgrade

Prepare to Upgrade

Become Familiar with the Features of the New Release

Determine Your Upgrade Path to the New Release

Choose an Upgrade Method

Choose an Oracle Home Directory for the New Release

Prepare a Backup Strategy

Develop a Testing Plan

Test the Upgrade Process

Test the Upgraded Test Database

3 Upgrading a Database to the New Oracle9i Release

Install the Release 9.2 Oracle Software

Running the Database Upgrade Assistant Independently

Upgrade the Database Using the Database Upgrade Assistant

Upgrade the Database Manually

System Considerations and Requirements

Prepare the Database to be Upgraded

Upgrade the Database

Upgrading Specific Components

Troubleshooting Manual Upgrades

4 After Upgrading a Database

Tasks to Complete After Upgrading Your Database

Back Up the Database

Change Passwords for Oracle-Supplied Accounts

Upgrading from the Standard Edition to the Enterprise Edition

Migrate Your Oracle Managed Files

Upgrade Oracle OLAP

Migrate Your Initialization Parameter File to a Server Parameter File

Migrate Tables from LONGs to LOBs

Modify Your listener.ora File

Upgrade Your Standby Database

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

Adjust Your Parameter File for the New Release

Tasks to Complete Only After Upgrading a Release 8.1.7 or Lower Database

Upgrade User NCHAR Columns

Migrate Your Server Manager Line Mode Scripts to SQL*Plus

Tasks to Complete Only After Upgrading a Release 8.0.6 or Lower Database

Avoid Problems with Parallel Execution

Normalize Filenames on Windows Operating Systems

Rebuild Unusable Function-Based Indexes

Upgrade Materialized Views

Upgrade Your Queue Tables

Upgrade the Recovery Catalog

Upgrade Statistics Tables Created by the DBMS_STATS Package

Tasks to Complete Only After Upgrading a Release 7.3.4 Database

Rebuild Unusable Bitmap Indexes

Migrate Partition Views to Partition Tables

Check for Bad Date Constraints

Upgrade to the New Release of Oracle Net Services (Optional)

Test the Database and Compare Results

Tune the Upgraded Database

Changing the Word Size of Your Current Release

5 Compatibility and Interoperability

What Is Compatibility?

The COMPATIBLE Initialization Parameter

Setting the COMPATIBLE Initialization Parameter

Features Requiring a COMPATIBLE Setting

What Is Interoperability?

Compatibility and Interoperability Issues Between Release 9.2 and Release 9.0.1

Locally Managed SYSTEM Tablespace

New AnyData DAtatypes

Dictionary Managed Tablespaces

Change in Compatibility for Automatic Segment-Space Managed Tablespaces

Compatibility and Object Types

Oracle Managed Files

Log Format Change with Parallel Redo

Oracle Dynamic Services

Oracle Syndication Server

Compatibility and Interoperability Issues Between Release 9.2 and Previous Releases

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

6 Upgrading Your Applications

Overview of Upgrading Applications

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

7 Downgrading a Database Back to the Previous Oracle Release

Supported Releases for Downgrading

Perform a Full Offline Backup

Remove Incompatibilities

Checking the Compatibility Level of Your Database

Identifying Incompatibilities

Removing Release 9.2 Incompatibilities

Removing Release 9.0.1 Incompatibilities

Reset Database Compatibility

Downgrading Specific Components

Removing OLAP Incompatibilities Before Downgrading to Release 8.1.7

Downgrading Oracle Spatial

Downgrading Oracle interMedia

Downgrading Oracle Visual Information Retrieval

Downgrading Oracle Text

Downgrading Oracle Ultra Search

Downgrade the Database

8 Database Migration Using Export/Import

Export Dump File Compatibility

Export/Import Usage on Data Incompatible with a Previous Release

Source Database and Target Database

Export Utility Requirements

Import Utility Requirements

Upgrade the Source Database Using Export/Import

A Changes to Initialization Parameters and the Data Dictionary

Initialization Parameter Changes

Deprecated Initialization Parameters

Obsolete Initialization Parameters

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

Static Data Dictionary View Changes

Deprecated Static Data Dictionary Views

Obsolete Static Data Dictionary Views

Static Data Dictionary Views with Renamed Columns

Static Data Dictionary Views with Dropped Columns

Static Data Dictionary Views with Columns That May Return Nulls

Dynamic Performance View Changes

Deprecated Dynamic Performance Views

Obsolete Dynamic Performance Views

Dynamic Performance Views with Renamed Columns

Dynamic Performance Views with Dropped Columns

B Upgrade Considerations for Oracle Net Services

Overview of Unsupported Oracle Net Services Features

Unsupported Parameters and 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

Upgrading to Oracle Net Services

Step 1: Verify Service Name and Instance Name

Step 2: Perform Software Upgrade on the Database Server

Step 3: Perform Software Upgrade on the Client

Step 4: Perform Functional Upgrade

Using Oracle Names Version 9

Upgrading from Oracle Names Version 2 Using a Database

Upgrading from Oracle Names Version 2 with the Dynamic Discovery Option

Upgrading from ROSFILES

Upgrading Region Checkpoint Files to Domain and Topology Checkpoint Files

Reviewing Upgrade Checklist

C 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

D Upgrading an Oracle7 Database Using the MIG Utility

Overview of the MIG Utility

Outline of the Upgrade Process Using the MIG Utility

System Considerations and Requirements for Using the MIG Utility

Space Requirements

Block Size Considerations

Considerations for SQL*Net

Considerations for Replication Environments

Considerations for Migrating from ConText to Oracle Text

Distributed Database Considerations

Prepare the Oracle7 Database to be Upgraded

Review MIG Utility Command-Line Options

Run the MIG Utility

Run the MIG Utility on UNIX Operating Systems

Run the MIG Utility on Windows Platforms

Check the MIG Utility Results

Preserve the Oracle7 Database

MIG Utility Messages

Troubleshooting MIG Utility Errors

Problems Using the MIG Utility

Problems at the ALTER DATABASE CONVERT Statement

Abandoning the Oracle7 Upgrade

Migration Issues for Physical Rowids

Upgrading Applications and Migrating Data

The DBMS_ROWID Package

Snapshot Refresh

Oracle7 Client Compatibility Issues

ROWID Migration and Compatibility Issues

Changes to Initialization Parameters and the Data Dictionary in Release 8.0

Initialization Parameter Changes in Release 8.0

Static Data Dictionary View Changes in Release 8.0

E Database Migration and Compatibility for Replication Environments

Database Migration Overview for Replication

Upgrading All Sites at Once

Upgrading Incrementally

Preparing Oracle7 Master Sites for an Incremental Upgrade

Incremental Upgrade of Materialized View Sites

Incremental Upgrade 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 an Upgrade 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