Contents

Title and Copyright Information

Preface

Documentation Accessibility

Related Documentation

1 Introduction

Overview of the Database Upgrade Process

Oracle Release Numbers

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)

Converting Databases to 64-bit Oracle Database Software

Rolling Upgrades

Moving From the Standard Edition to the Enterprise Edition

2 Preparing to Upgrade

Prepare to Upgrade

Become Familiar with the Features of the New Oracle Database 10g Release

Determine the Upgrade Path to the New Oracle Database 10g Release

Choose an Upgrade Method

Database Upgrade Assistant

Choose an Oracle Home Directory for the New Oracle Database 10g Release

Develop a Testing Plan

Upgrade Testing

Minimal Testing

Functional Testing

Integration Testing

Performance Testing

Volume and Load Stress Testing

Specific Pre-Upgrade and Post-Upgrade Tests

Prepare a Backup Strategy

Test the Upgrade Process

Test the Upgraded Test Database

3 Upgrading to the New Oracle Database 10g Release

System Considerations and Requirements

Upgrading a Cluster Database

Upgrading With Read-Only and Offline Tablespaces

Upgrading Standby Databases

Upgrading Databases in an Oracle Data Guard Configuration

Upgrading Databases in a Broker Configuration

Using SQL Apply to Perform a Rolling Upgrade of Oracle Databases

Upgrading Your Operating System

Migrating Data to a Different Operating System

Install the Release 10.2 Oracle Software

Install the Latest Available Patch Set Release and Any Required Patches

Run the Pre-Upgrade Information Tool

Using the Pre-Upgrade Information Tool

Update Parameters

Deprecated Parameters

Obsolete Parameters

Miscellaneous Warnings

SYSAUX Tablespace

Issues Requiring Further Analysis Prior to Upgrading

Deprecated CONNECT Role

Database Links With Passwords

TIMESTAMP WITH TIMEZONE Datatype

Release 8.1.7 National Character Set

Optimizer Statistics

Run the Oracle Net Configuration Assistant

Upgrade the Database Using the Database Upgrade Assistant

Using the Database Upgrade Assistant Graphical User Interface

Using the Database Upgrade Assistant in Silent Mode

Upgrade the Database Manually

Back Up the Database

Prepare the New Oracle Home

Upgrade the Database

Troubleshoot the Upgrade

SYSTEM and SYSAUX Tablespace

Public Rollback Segment

Abandon the Upgrade

4 After Upgrading a Database

Tasks to Complete After All Upgrades

Back Up the Database

Update Environment Variables After the Upgrade (UNIX Systems Only)

Set Threshold Values for Tablespace Alerts

Migrate Tables from the LONG Datatype to the LOB Datatype

Upgrade the TIMESTAMP Data

Use the Latest Time Zone File for Clients

Upgrade the Recovery Catalog

Upgrade Statistics Tables Created by the DBMS_STATS Package

Upgrade Externally Authenticated SSL Users

Install Supplied Knowledge Bases

Upgrade Change Data Capture

Configure Secure HTTP

Provide Anonymous Access to XML DB Repository Data via HTTP

Update Your HTML DB Configuration

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

Tasks to Complete Only After Manual Upgrades

Change Passwords for Oracle-Supplied Accounts

Migrate Your Initialization Parameter File to a Server Parameter File

Upgrade Oracle Text

Upgrade the Oracle Cluster Registry (OCR) Configuration

Adjust the Initialization Parameter File for the New Release

Install and Configure Enterprise Manager Database Control

Tasks to Complete Only After Upgrading a Release 8.1.7 Database

Upgrade User NCHAR Columns

Migrate Your Server Manager Line Mode Scripts to SQL*Plus

5 Compatibility and Interoperability

What Is Compatibility?

The COMPATIBLE Initialization Parameter

Downgrading and Compatibility

How the COMPATIBLE Initialization Parameter Operates

Compatibility Level

Checking the Current Value of the COMPATIBLE Initialization Parameter

When to Set the COMPATIBLE Initialization Parameter

Setting the COMPATIBLE Initialization Parameter

What Is Interoperability?

Compatibility and Interoperability Issues Introduced in Oracle Database 10g Release 10.2

Compatibility and Interoperability Issues Introduced in Oracle Database 10g Release 10.1

Rule-Based Optimizer Desupported

Optimizer Statistics

COMPUTE STATISTICS Clause of CREATE INDEX

SKIP_UNUSABLE_INDEXES

Invalid Synonyms After an Upgrade

Transaction and Space

Recovery and Data Guard

CREATE DATABASE

Real Application Clusters

Materialized Views

Change Data Capture

Change in the Default Archival Processing to Remote Archive Destinations

Limitations on NCHAR Datatypes

PL/SQL Native Compilation

Compatibility and Interoperability Issues Introduced in Oracle9i Release 9.2

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 Introduced in Oracle9i Release 9.0.1

The STARTUP Command

Change in Default Parameter File Selection

Tablespaces and Datafiles

CREATE TABLESPACE: New Behavior

Default Temporary Tablespaces

Undo Tablespaces

Datetime and Interval Datatypes

Database Character Sets

AL24UTFFSS Character Set Desupported

User-Defined Datatypes

Subtypes and Non-Final Types

Oracle Replication

CHAR Column Length Semantics

NCHAR or NVARCHAR2 Columns

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

Types of Software Upgrades

Possible Client/Server Configurations

Compatibility Rules for Applications When Upgrading Client/Server Software

Upgrading the Oracle Database Server Software

Upgrading the Oracle Database Client Software

Upgrading Options for Your Precompiler and OCI Applications

Option 1: Leave the Application Unchanged

Option 2: Precompile or Compile the Application Using the New Software

Option 3: Change the Application Code to Use New Oracle Database 10g Features

Upgrading SQL*Plus Scripts and PL/SQL

Upgrading Oracle Forms or Oracle Developer Applications

7 Downgrading a Database Back to the Previous Oracle Database Release

Supported Releases for Downgrading

Check for Incompatibilities

Perform a Full Offline Backup

Downgrade the Database

Perform Post-Downgrade Tasks

8 Data Copying Using Export/Import

Export and Import Requirements

Export/Import Usage on Data Incompatible with a Previous Release

Upgrade the Database Using Export/Import

A Initialization Parameter and Data Dictionary Changes

Initialization Parameter Changes

Deprecated Initialization Parameters

Initialization Parameters Deprecated in Release 10.2

Initialization Parameters Deprecated in Release 10.1

Initialization Parameters Deprecated in Release 9.2

Initialization Parameters Deprecated in Release 9.0.1

Obsolete Initialization Parameters

Initialization Parameters Obsolete in Release 10.2

Initialization Parameters Obsolete in Release 10.1

Initialization Parameters Obsolete in Release 9.2

Initialization Parameters Obsolete in Release 9.0.1

Compatibility Issues with Initialization Parameters

Change in Behavior for SESSION_CACHED_CURSORS

New default value for DB_BLOCK_SIZE

OPTIMIZER_MAX_PERMUTATIONS and OPTIMIZER_FEATURES_ENABLE

Change in Behavior for LOG_ARCHIVE_FORMAT

New Default Value for PGA_AGGREGATE_TARGET

Change in Behavior for SHARED_POOL_SIZE

Shared Server Parameters

New Default Value for DISPATCHERS

New Default Value for SHARED_SERVERS

New Default Value for MAX_SHARED_SERVERS

New Default Value for SHARED_SERVER_SESSIONS

New Default Value for CIRCUITS

New Default Value for MAX_DISPATCHERS

New Default Value for DB_BLOCK_CHECKSUM

Maximum Number of Job Queue Processes

New Default Value for LOG_CHECKPOINT_TIMEOUT

The O7_DICTIONARY_ACCESSIBILITY Parameter

Static Data Dictionary View Changes

Deprecated Static Data Dictionary Views

Static Data Dictionary Views Deprecated in Release 10.1

Static Data Dictionary Views Deprecated in Release 9.2

Static Data Dictionary Views Deprecated in Release 9.0.1

Obsolete Static Data Dictionary Views

Static Data Dictionary Views Obsolete in Release 10.1

Static Data Dictionary Views with Renamed Columns

Static Data Dictionary Views with Renamed Columns in Release 9.0.1

Static Data Dictionary Views with Dropped Columns

Static Data Dictionary Views with Dropped Columns in Release 10.2

Static Data Dictionary Views with Dropped Columns in Release 9.0.1

Dynamic Performance View Changes

Deprecated Dynamic Performance Views

Dynamic Performance Views Deprecated in Release 10.1

Dynamic Performance Views Deprecated in Release 9.2

Dynamic Performance Views Deprecated in Release 9.0.1

Obsolete Dynamic Performance Views

Dynamic Performance Views Obsolete in Release 10.1

Dynamic Performance Views Obsolete in Release 9.2

Dynamic Performance Views Obsolete in Release 9.0.1

Dynamic Performance Views with Renamed Columns

Dynamic Performance Views with Renamed Columns in Release 9.2

Dynamic Performance Views with Renamed Columns in Release 9.0.1

Dynamic Performance Views with Dropped Columns

Dynamic Performance Views with Dropped Columns in Release 9.2

Dynamic Performance Views with Dropped Columns in Release 9.0.1

B Migrating from Server Manager to SQL*Plus

Startup Differences

Starting Server Manager

Starting SQL*Plus

Starting SQL*Plus with the NOLOG Option

Starting SQL*Plus with Connect Information

Starting SQL*Plus without Options or Connect Information

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

REMARK Command (or REM)

SQL Comment Delimiters, /* ... */

ANSI/ISO Comments, --

Server Manager Pound (#) Comments

The Hyphen Continuation Character

Hyphens Used as Dividing Lines

Hyphens Used as Minus Signs

Using the SET ESCAPE Command

Using the SET DEFINE OFF Command

CREATE TYPE and CREATE LIBRARY Commands

C Gathering Optimizer Statistics

Collecting Statistics for System Component Schemas

Creating a Statistics Table

D Using the Database Upgrade Assistant

Index