Oracle7 Server Migration Guide

Library

Product

---

• Oracle7^(tm) Server Migration

• Preface
  • Audience
  • How Oracle7 Server Migration Is Organized
  • Conventions Used in this Manual
  • Your Comments Are Welcome

• Generic Migration, Upgrading, and Downgrading Procedures

• Migration Overview
  • Migrating a Database from One Version to Another
  • Overview of the Migration Process
  • Role of the Database Administrator During Migration
  • Role of the Application Developer During Migration
  • Downgrading to a Previous Database
  • Migrating from Single Instance to Parallel Server

• Preparing to Migrate
  • Step 1: Prepare to Migrate
  • Step 2: Rehearse the Migration Process
  • Step 3: Test Your Applications
  • Step 4: Preserve the Source Database

• The Migration Utility
  • Overview of the Migration Utility
  • Blocksize Considerations
  • Migrating to a Different Computer Architecture
  • Errors During Migration
  • Step 5: Migrate the Source Database (using the Migration Utility)

• Migrating Using Export/Import
  • Export/Import
  • Data Definition Conversion
  • Space Requirements for Export/Import
  • Time Requirements for Export/Import
  • Step 5: Migrate the Source Database (using Export/Import)

• After Migrating the Database
  • Back Up the Target Database
  • Migrate Your Production Database
  • Test the Database and Compare Results
  • Tune the Target Database
  • Add New Features as Appropriate
  • Develop New Administrative Procedures as Needed

• Migrating, Upgrading, and Downgrading between Specific Versions and Releases

• System Requirements for Migration
  • General Memory Requirements
  • The Shared Global Area (SGA)
  • The Shared Pool Area (SPA)
  • The Buffer Cache
  • The Redo Log Buffer Cache
  • The Program Global Area (PGA)
  • Oracle7 Executables
  • Concurrent Access
  • Disk Capacity and Input/Output (I/O)
  • Block Size
  • CPU Resources
  • Oracle Parallel Server
  • Distributed Transactions and Network Considerations

• Migrating from Version 6 to Version 7
  • Migrating a Version 6 Database
  • Preparing to Migrate from Version 6 to Version 7
  • Using the Migration Utility to Migrate from Version 6 to a Version 7 Release
  • Using Export/Import to Migrate from Version 6 to a Version 7 Release
  • Preserving Your Version 6 Database
  • Tune the New, Release 7.x Database
  • Enabling and Disabling Release 7.x Features
  • Add New Features as Appropriate
  • Develop New Administrative Procedures as Needed
  • Downgrading to a Previous, Version 6 Database

• Migrating Version 6 Applications
  • Oracle7 Changes and the Programmatic Interfaces
  • Migrating Your Oracle Programmatic Interface Applications
  • Migrating Your Precompiler Applications
  • Migrating Your OCI Applications
  • Migrating Your Oracle Forms Applications
  • Migrating Your CASE*Dictionary Applications
  • Migrating Your SQL*Report (RPT/RPF) Reports
  • Migrating Your Oracle Reports and SQL*ReportWriter Applications
  • Migrating Your SQL*Plus Scripts
  • SQL*Net

• Upgrading and Downgrading between Oracle7 Releases
  • Upgrading to a New Release
  • Downgrading to a Previous Release
  • Downgrading from Release 7.3 to Release 7.1
  • Upgrading and Downgrading by Copying Data
  • Upgrading and Downgrading Considerations
  • Enabling Release 7.1 Features
  • Disabling Release 7.1 Features
  • Enabling Release 7.2 Features
  • Disabling Release 7.2 Features
  • Enabling Release 7.3 Features
  • Disabling Release 7.3 Features
  • Downgrading from Release 7.2 to 7.1 and the UNRECOVERABLE Parameter
  • Downgrading and Hash Clusters
  • Downgrading PL/SQL Wrapper Code
  • Downgrading after Using Resizeable Datafiles
  • PL/SQL Compatibility: Upgrading, Downgrading, and Interoperability
  • Compatibility and Migration for Sort Direct Writes
  • Migration and Compatibility Issues for Object Groups
  • Migration and Compatibility Issues for Synchronous Propagation
  • Migration and Compatibility Issues for Sort Big Keys
  • Migration and Compatibility Issues for the UNSAFE_NULL_FETCH Command
  • Migration and Compatibility Issues for Sort Segment
  • Upgrade and Downgrade Issues for Compiled Triggers
  • Upgrade and Downgrade Issues for the REMOTE_DEPENDENCIES_MODE Parameter
  • Migration and Compatibility Issues for Load Balancing in Listener
  • Migration and Compatibility Issues for the OBINDPS, ODEFINPS, OGETPI, and OSETPI Functions
  • Migration and Compatibility Issues for Thread Safety, OCI
  • Migration and Compatibility Issues for Thread Safety, Pro*
  • Migration and Compatibility Issues for Fine Grained Locking
  • Migration and Compatibility Issues for Buffer Cache LRU Latch Contention
  • Upgrade and Downgrade Issues for Histograms
  • Migration and Compatibility Issues for Standby Database
  • Migration and Compatibility Issues for Direct Path Export
  • Upgrading and the Advanced Replication Option
  • Downgrading and the Advanced Replication Option
  • Advanced Replication Compatibility Between Release 7.3 and Earlier Releases

• Appendices A, B, C, D, E, and F

• Summary of Changes in Oracle7, Release 7.0
  • Terminology
  • Functionality Enhancements
  • Backup and Recovery Enhancements
  • Security Enhancements
  • Performance Enhancements
  • Administration Enhancements
  • SQL*DBA Changes
  • Changes to Utilities
  • Changes to Views
  • Oracle Datatype Changes
  • SQL Command Changes
  • New Features of the Oracle Precompilers, Release 1.5
  • Initialization Parameters
  • Data Dictionary Changes
  • Version 6 Compatibility
  • New and Renamed SQL Scripts
  • Other Changes

• Summary of Changes in Oracle7, Release 7.1
  • Terminology
  • Functionality Enhancements
  • SQL Syntax Changes
  • Changes to Supplied Packages
  • SQL*Net and the Multi-Threaded Server
  • New Features of the Oracle Precompilers, Release 1.6
  • Advanced Replication Option
  • Initialization Parameter Changes
  • Data Dictionary Views and Dynamic Performance Tables for Release 7.1
  • Release 7.1 Backward Compatibility

• Summary of Changes in Oracle7, Release 7.2
  • Functionality Enhancements
  • Recovery Enhancements
  • Security Enhancements
  • Performance Enhancements
  • Administration Enhancements
  • Oracle7, Release 7.2 Datatype Changes
  • SQL Changes
  • New Features of the Oracle Precompilers, Release 1.7
  • Pro*C/C++, Release 2.1 New Features
  • SQL*Module Default WITH INTERFACE Clause
  • Non-blocking Oracle Call Interface (OCI)
  • Initialization Parameter Changes
  • Data Dictionary Changes
  • Standards Compliance
  • Release 7.2 Backward Compatibility
  • New, Changed, and Obsolete SQL Scripts
  • Other Changes

• Summary of Changes in Oracle7, Release 7.3
  • Administration Enhancements
  • Query Execution Enhancements
  • Scalability and Performance Enhancements
  • Parallel Server Enhancements
  • Serviceability Enhancements
  • Tuning Enhancements
  • Advanced Replication Enhancements
  • Interface Enhancements
  • PL/SQL Enhancements
  • Data Dictionary Changes
  • Initialization Parameter Changes

• Migration Utility Errors and Messages

• Operating System-Specific Information

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product