Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New in Oracle Database Upgrade Guide

1 Introduction to the Database Upgrade Process

• 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
• Upgrading from Oracle Database Express Edition to Oracle Database

2 Preparing to Upgrade

• Prepare to Upgrade
  • Become Familiar with New Oracle Database Features
  • Determine the Upgrade Path
  • Choose an Upgrade Method
    • Database Upgrade Assistant
      • Support for Oracle Real Application Clusters
      • Support for Automatic Storage Management
    • Manual Upgrade
      • Before the Upgrade
      • After the Upgrade
    • Export/Import
      • Export/Import Effects on Upgraded Databases
      • Export/Import Benefits
      • Time Requirements for Export/Import
  • Choose an Oracle Home Directory
  • Develop a Testing Plan
    • Upgrade Testing
    • Minimal Testing
    • Functional Testing
    • Integration Testing
    • Performance Testing
      • Database Replay
      • SQL Performance Analyzer
      • SQL Plan Management
    • Volume and Load Stress Testing
  • Prepare a Backup Strategy
• Test the Upgrade Process
• Test the Upgraded Test Database

3 Upgrading to the New Release

• System Considerations and Requirements
  • Upgrading Oracle Clusterware and Automatic Storage Management (ASM) Databases
    • Upgrading an Oracle Real Application Clusters (Oracle RAC) Database
    • Upgrading a Database that Uses Automatic Storage Management (ASM)
  • Upgrading with Read-Only and Offline Tablespaces
  • Upgrading Standby Databases
  • Upgrading Your Operating System
  • Migrating Data to a Different Operating System
  • Upgrading Databases That Use Oracle Streams Downstream Capture
• Install the New Oracle Database Software
• Install the Latest Available Patchset Release and Any Required Patches
• Run the Pre-Upgrade Information Tool
• Prepare the Database to Be Upgraded
  • Deprecated CONNECT Role
  • Database Links with Passwords
  • TIMESTAMP WITH TIME ZONE Data Type
  • Optimizer Statistics
  • Disable Oracle Database Vault
  • Save Oracle Enterprise Manager Database Control Data
• Run the Oracle Net Configuration Assistant
• Upgrade a Database Using Database Upgrade Assistant
  • Using the DBUA Graphical User Interface
  • Using DBUA in Silent Mode
• Upgrade a Database Manually
  • Back Up the Database
  • Prepare the New Oracle Home
  • Upgrade the Database
  • Troubleshoot the Upgrade
    • Resource Limits
    • Component Status
    • Rerunning the Upgrade
  • Cancel the Upgrade
• Upgrade an ASM Instance with DBUA
• Upgrade an ASM Instance Manually
  • Reconfigure Oracle Cluster Synchronization Services
  • Prepare the New ASM Oracle Home
  • Upgrade ASM
  • Troubleshoot the ASM Upgrade
  • Cancel the ASM Upgrade

4 After Upgrading to the New Release

• Required Tasks After Database Upgrades
  • Update Environment Variables (Linux and UNIX Systems Only)
  • Upgrade the Recovery Catalog
  • Upgrade Statistics Tables Created by the DBMS_STATS Package
  • Upgrade Externally Authenticated SSL Users
  • Install Oracle Text Supplied Knowledge Bases
  • Update Your Oracle Application Express Configuration
  • Configure Fine-Grained Access to External Network Services
  • Enable Oracle Database Vault
  • Deploy Database Vault Administrator (DVA)
• Recommended Tasks After Database Upgrades
  • Recommended Tasks After All Database Upgrades
    • Back Up the Database
    • Reset Passwords to Enforce Case-Sensitivity
    • Upgrade Automatic Storage Management (ASM)
    • Add New Features as Appropriate
    • Develop New Administrative Procedures as Needed
    • Set Threshold Values for Tablespace Alerts
    • Migrate From Rollback Segments to Automatic Undo Mode
    • Configure Oracle Data Guard Broker
    • Migrate Tables from the LONG Data Type to the LOB Data Type
  • Recommended Tasks After Upgrading a 10g Release 1 (10.1) Database
    • Upgrade Change Data Capture
    • Configure Secure HTTP
    • Provide Anonymous Access to XML DB Repository Data Through HTTP
  • Recommended Tasks After Upgrading an Oracle Express Edition Database
• Tasks to Complete Only After Manual Database 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
  • Configure Enterprise Manager
  • Set CLUSTER_DATABASE Initialization Parameter
• Required Tasks After ASM Upgrades
• Recommended Tasks After ASM Upgrades
  • Reset ASM Passwords to Enforce Case-Sensitivity
  • Advance the ASM and Oracle Database Disk Group Compatibility
  • Set Up ASM Preferred Read Failure Groups
• Optional Tasks After ASM Upgrade
  • Single-Instance ASM Upgrade
  • Cluster ASM Upgrade
  • Database Upgrade After ASM Upgrade
    • Keeping orauser as the Operating System User
    • Changing the Operating System User For a Single-Instance Database
    • Changing the Operating System User for an Oracle RAC Database
• Tasks to Complete Only After Manual ASM Upgrades
  • Upgrade the Oracle Cluster Registry (OCR) Configuration for ASM
  • Adjust the ASM Initialization Parameter File for the New Release
  • Install and Configure Enterprise Manager Database Control for ASM

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?
• Deprecated Features in 11g Release 1 (11.1)
• Compatibility and Interoperability Issues Introduced in 11g Release 1 (11.1)
  • Automatic Maintenance Tasks Management
  • New SYSASM Privilege and OSASM Group for ASM Administration
  • ASM Disk Group Compatibility
  • COMPUTE STATISTICS and ESTIMATE STATISTICS Clauses
  • Oracle Data Mining Models and the DMSYS Schema Objects
  • Oracle Data Mining Scoring Engine
  • SQL Plan Management and Control of SQL Plan Baselines
  • Binary XML Support for Oracle XML Database
    • When Upgrading to Oracle Database 11g Release 1 (11.1)
  • PL/SQL Native Compilation and Access Control for Network Utility Packages
    • PL/SQL Native Compilation
    • Access Control for Network Utility Packages
  • PL/SQL Control Parameters
  • Change in WebDAV ACL Evaluation Rules in Oracle XML DB
  • Summary Management and SQL Access Advisor
  • SQL Access Advisor Tasks
  • Standard Edition Starter Database
  • Core Dump Location
  • LOG_ARCHIVE_DEST_n Parameter
  • SHARED_POOL_SIZE Parameter
  • JOB_QUEUE_PROCESSES Parameter
• Compatibility and Interoperability Issues Introduced in 10g Release 2 (10.2)
  • SQL
  • CONNECT Role
  • Time Zone Files
  • New Limit for FAILED_LOGIN_ATTEMPTS
• Compatibility and Interoperability Issues Introduced in 10g Release 1 (10.1)
  • SQL Optimizer
    • Rule-Based Optimizer Desupported
    • Optimizer Statistics
    • COMPUTE STATISTICS Clause of CREATE INDEX
    • SKIP_UNUSABLE_INDEXES
  • SQL
  • Invalid Synonyms After an Upgrade
  • Manageability
  • Transaction and Space
  • Recovery and Data Guard
  • RMAN
  • CREATE DATABASE
  • Oracle Real Application Clusters
  • Materialized Views
  • Change Data Capture
  • Change in the Default Archival Processing to Remote Archive Destinations
  • Limitations on NCHAR Data Types
  • PL/SQL Native Compilation
  • Evaluation of Numeric Literals
  • SHARED_SERVERS Parameter

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
      • Major Database Release Upgrade
      • Database Maintenance Release Upgrade
    • Possible Client/Server Configurations
      • Different Computers
      • Different Oracle Home Directories on the Same Computer
      • Same Oracle Home
  • Compatibility Rules for Applications When Upgrading Client/Server Software
    • Upgrading the Oracle Database Server Software
      • If You Do Not Change the Client Environment, Then You Are Not Required to Relink.
      • Applications Can Run Against Newer or Older Oracle Database Server Releases
    • Upgrading the Oracle Database Client Software
      • Applications Can Be Linked with Newer Libraries
      • Statically-Linked Applications Must Always Be Relinked
      • Dynamically-Linked Applications Must Be Relinked When Upgrading to a Major Release
  • 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 11g Release 1 (11.1) Features
      • Changing Precompiler Applications
      • Changing OCI Applications
• Upgrading SQL*Plus Scripts and PL/SQL
  • Evaluation of Numeric Literals
• Upgrading Oracle Forms or Oracle Developer Applications

7 Downgrading a Database

• Supported Releases for Downgrading
• Check for Incompatibilities
• Perform a Full Backup
• Downgrade the Database
• Perform Post-Downgrade Tasks
  • Downgrading Oracle Clusterware Configuration
  • Restoring Oracle Enterprise Manager
  • Enabling Oracle Database Vault

8 Moving Data Using Data Pump and Export/Import

• When to Use Data Pump Export/Import Versus Original Export/Import
• Export and Import Requirements
  • Export and Import Requirements for Upgrades
  • Export and Import Requirements for Downgrades
  • 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 Oracle Database 11g Release 1 (11.1)
    • Initialization Parameters Deprecated in Oracle Database 10g Release 2 (10.2)
    • Initialization Parameters Deprecated in Oracle Database 10g Release 1 (10.1)
    • Initialization Parameters Deprecated in Oracle9i Release 2 (9.2)
  • Obsolete Initialization Parameters
    • Initialization Parameters Obsolete in Oracle Database 11g Release 1 (11.1)
    • Initialization Parameters Obsolete in Oracle Database 10g Release 2 (10.2)
    • Initialization Parameters Obsolete in Oracle Database 10g Release 1 (10.1)
    • Initialization Parameters Obsolete in Oracle9i Release 2 (9.2)
• Compatibility Issues with Initialization Parameters
  • Compatibility Issues Introduced in Oracle Database 11g Release 1 (11.1)
    • New Default Value for UNDO_MANAGEMENT
  • Compatibility Issues Introduced in Oracle Database 10g
    • 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
• Static Data Dictionary View Changes
  • Deprecated Static Data Dictionary Views
    • Static Data Dictionary Views Deprecated in Oracle Database 11g Release 1 (11.1)
    • Static Data Dictionary Views Deprecated in Oracle Database 10g Release 1 (10.1)
    • Static Data Dictionary Views Deprecated in Oracle9i Release 2 (9.2)
  • Obsolete Static Data Dictionary Views
    • Static Data Dictionary Views Obsolete in Oracle Database 10g Release 1 (10.1)
  • Static Data Dictionary Views with Dropped Columns
    • Static Data Dictionary Views with Dropped Columns in Oracle Database 11g Release 1 (11.1)
    • Static Data Dictionary Views with Dropped Columns in Oracle Database 10g Release 2 (10.2)
• Dynamic Performance View Changes
  • Deprecated Dynamic Performance Views
    • Dynamic Performance Views Deprecated in Oracle Database 10g Release 1 (10.1)
    • Dynamic Performance Views Deprecated in Release 9.2
  • Obsolete Dynamic Performance Views
    • Dynamic Performance Views Obsolete in Oracle Database 10g Release 1 (10.1)
    • Dynamic Performance Views Obsolete in Release 9.2
  • Dynamic Performance Views with Renamed Columns
    • Dynamic Performance Views with Renamed Columns in Release 9.2
  • Dynamic Performance Views with Dropped Columns
    • Dynamic Performance Views with Dropped Columns in Release 9.2

B Gathering Optimizer Statistics

• Collecting Statistics for System Component Schemas
• Creating a Statistics Table

Index