Oracle8 Migration
Release 8.0

A58243-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience and Assumed Knowledge
How Oracle8 Server Migration is Organized
Conventions Used in This Manual
Your Comments Are Welcome

1 Migration Overview

Terminology
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 Version 8 Production Database
Role of the Database Administrator During Migration
Role of the Application Developer During Migration

2 Preparing to Migrate

Step 1: Prepare to Migrate
Become Familiar with the Features of the New Version 8 Database
Choose a Migration Method
Assess System Requirements vs. Resources Available
Start with Oracle Version 7, Release 7.X or Higher
Avoid Common Migration Problems
Prepare a Backup Strategy
Develop a Testing Plan
Step 2: Test the Migration Process
Step 3: Test the Migrated Test Database

3 Migrating Using the Migration Utility

Overview of Migration Using the Version 8 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 to a Different Computer Architecture
Character Encoding Considerations
Prepare the Version 7 Source Database for Migration
Install the Version 8 Migration Utility
Review Version 8 Migration Utility Command Line Options
Migrate the Version 7 Source Database
Migration Steps in the Version 7 Environment
Preserve the Version 7 Source Database
Migration Steps in the Version 8 Environment
Errors During Migration
Abandoning the Migration

4 Migrating Using Export/Import

Basics of Export/Import
Export Requirements
Import Requirements
Additional Export/Import Information Sources
Additional Options
Migrate the Pre-Version 8 Source Database Using Export/Import

5 After Migrating the Database

Back Up the Version 8 Database
Check for Bad Date Constraints
Rebuild Invalidated Bitmap Indexes
Test the Database and Compare Results
Tune the Target Database
Add New Features as Appropriate
Develop New Administrative Procedures as Needed

6 Upgrading Version 7 Applications

Upgrading Oracle Applications to Version 8
XA Calls: Incompatibility with Release 7.1 XA Calls
Upgrading Precompiler and OCI Applications
Upgrading Precompiler Applications
Simplified Upgrading of Existing Applications
Upgrading OCI Applications: Enabling Constraints
OCI Application Link Line
Applications Using Version 6 OCI Libraries
Upgrading LONGs to LOBs
Upgrading Version 7 Forms or Developer/2000 Applications
Data Dictionary Views Update
Upgrading SQL*Plus Scripts
PL/SQL V2 Compatibility Mode
PLSQL_V2_COMPATIBILITY Flag
Keyword Behavior Differences: Version 7 vs. Version 8
New Keywords or Types Behavior Differences: Version 7 vs. Version 8
SQL*Net or Net8
Upgrading SQL*Net V1 to SQL*Net V2
Version 7 Net2 Clients and Connection Manager
Net8 Features Available to Relinked Version 7 Clients
Version 8 Net8 Clients
Backup Management: EBU and Recovery Manager
Dictionary Protection
Password Management
Version 7 or Lower Client with Version 8 Server
Version 8 Client with Version 7 or Lower Server
Export/Import Usage, Partitioned Objects
Migration and Compatibility Issues for Thread Safety, OCI
Upgrade and Compatibility Issues for Standby Database
Compatibility Issues for Export/Import
Downward Compatibility Techniques and Limitations
NCHAR and NLS Use
Migration and NCHAR and NLS
NCHAR and NLS Compatibility and Interoperability

7 Migration Issues for the Version 8 ROWIDs

Migrating Applications and Data
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

8 Upgrading and Downgrading

Upgrading to a New Version 8 Release
Product Configurations and Upgrading
Upgrading the Advanced Queuing Option
New Fields Enabled for the AQ$_AGENT Data Type
The Extended Address Field
New Dictionary Tables
Downgrading
Downgrading from Release 8.0.4 to Release 8.0.3
Downgrading Version 8 to Release 7.x

A Migration Utility Messages

B Control File Fixed View Changes

Date Columns in Control File Views
Obsolete Views Kept in Version 8
V$LOG_HISTORY Retained and Upgraded
V$ARCHIVED_LOG Replaces V$LOG_HISTORY
V$BACKUP_CORRUPTION
V$BACKUP_DATAFILE
V$BACKUP_DEVICE
V$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION
V$DATABASE New Columns
V$DATAFILE New Columns
V$DATAFILE_COPY
V$DATAFILE_HEADER
V$DELETED_OBJECT
V$INSTANCE
V$OFFLINE_RANGE
V$RESOURCE_LIMIT
V$TABLESPACE
V$THREAD
Changed Column Types
Database Scheduling Facilities
Changed Fixed Views
New Fixed Views
Table (View) Name Changes

C Version 8 INIT.ORA Changes

COMPATIBLE Parameter
Migrating or Upgrading to Release 8.0.4
Data Dictionary Protection
DML_LOCKS
NCHAR and NLS Parameters and Compatibility
Pre-Version 8 Parameters Renamed in Version 8
Release 7.3 Parameters Obsolete in Version 8
REPLICATION_DEPENDENCY_TRACKING for the Replication Server
Features No Longer Supported in Version 8
SERIALIZABLE=TRUE or _SERIALIZABLE

D New SQL Key and Reserved Words

E General System Requirements for Migration

Memory Requirements
Basic Memory Requirements
Version 8 Executables
Concurrent Access
Using Oracle Parallel Server
Version 8 New Sizes and Limits
CHAR and NCHAR Maximum Size Support


Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Index