Skip Headers

Oracle9i Database Migration
Release 2 (9.2)

Part Number A96530-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to next page
View PDF


Title and Copyright Information

Send Us Your Comments


Related Documentation
Documentation Accessibility

1 Introduction

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
Oracle OLAP
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
Schema Objects
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 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
Oracle Names
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
Blank Lines
The Hyphen Continuation Character
COMMIT Command

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