Oracle8i Migration
Release 8.1.5

A67774-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

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

2 Preparing to Migrate

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

3 Migrating Using the Migration Utility

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

4 Migrating Using the Oracle Data Migration Assistant

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

5 Migrating Using Export/Import

Basics of Export/Import
Export Utility Requirements
Import Requirements
Additional Options
Migrate the Pre-Release 8.0 Source Database Using Export/Import

6 After Migrating the Database

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

7 Upgrading to the New Oracle8i Release

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

8 Compatibility and Interoperability

What Is Compatibility?
The COMPATIBLE Parameter
Features Requiring 8.1.0 or Higher Compatibility Level
Applications
Tablespaces
Schema Objects
Partitioning
Built-In Datatypes
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

9 Upgrading Your Applications

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

10 Migrating from Server Manager to SQL*Plus

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

11 Migration Issues for Physical Rowids

Migrating Applications and Data
The DBMS_ROWID Package
Rowid Conversion Types
Rowid Conversion Functions
Conversion Procedure Examples
Example 1
Example 2
Example 3
Example 4
Example 5
Snapshot Refresh
Pre-Version 8 Client Compatibility Issues
Rowid-Related Migration Questions and Answers

12 Downgrading to an Older Version 8 Release

Perform a Full Offline Backup
Remove Incompatibilities
Tablespaces
Schema Objects
Partitioning
Datatypes
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

13 Downgrading to Oracle7

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

A Troubleshooting Migration Problems

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

B Changes to Initialization Parameters

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

C Changes to Static Data Dictionary Views

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

D Changes to Dynamic Performance Views

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

E New Internal Datatypes and SQL Functions

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

Index



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index