Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

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
• Compatibility and Interoperability
  • What Is Compatibility?
    • The COMPATIBLE Initialization Parameter
  • What Is Interoperability?
• Using Optimal Flexible Architecture (OFA)
• Converting Databases to 64-bit Oracle Database Software
• About Rolling Upgrades
• Moving From the Standard Edition to the Enterprise Edition
• Moving From the Enterprise Edition to the Standard 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
    • Manual Upgrade
    • Export/Import
  • Choose an Oracle Home Directory
  • Develop a Testing Plan
    • Upgrade Testing
    • Minimal Testing
    • Functional Testing
    • High Availability Testing
    • Integration Testing
    • Performance Testing
    • 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
  • Oracle ASM is Installed with Oracle Grid Infrastructure
  • Upgrading Oracle Clusterware and Automatic Storage Management (ASM) Databases
    • Upgrading an Oracle Real Application Clusters (Oracle RAC) Database
    • Upgrading System Authentication for Oracle ASM Instances
  • Upgrading with Read-Only and Offline Tablespaces
  • Upgrading Using Standby Databases
  • Upgrading Your Operating System
  • Migrating Data to a Different Operating System
  • Upgrading Databases That Use Oracle Streams Downstream Capture
  • Upgrading Databases That Use Oracle Database Vault
• Install the New Oracle Database Software
• Install the Latest Available Patchset Release and Any Required Patches
• Run the Pre-Upgrade Information Tool
  • Pre-Upgrade Information Tool Miscellaneous Warnings
    • Deprecated CONNECT Role
    • Access Control to Network Utility Packages
    • Database Links with Passwords
    • TIMESTAMP WITH TIME ZONE Data Type
    • Optimizer Statistics
    • Invalid Objects
    • Save Oracle Enterprise Manager Database Control Data
    • Complete Materialized View Refreshes
    • Ensure No Files Need Media Recovery
    • Ensure No Files Are in Backup Mode
    • Resolve Outstanding Distributed Transactions
    • Sync Standby Database with the Primary Database
    • Purging the Database Recycle Bin
• 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
    • Manual Workaround for ORA-01408
    • Running the DBMS_DST Package After Upgrade Can Result in ORA-01822
    • Component Status
    • Rerunning the Upgrade
  • Cancel the Upgrade
• Upgrade an ASM Instance
  • 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 the Time Zone File Version
  • 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 and Revoke the DV_PATCH_ADMIN Role
• 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
    • Test the Upgraded Production Database
  • Recommended Tasks After Upgrading an Oracle Database 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
    • Setting the COMPATIBLE Initialization Parameter
  • Configure Enterprise Manager
  • Set CLUSTER_DATABASE Initialization Parameter
• Required Tasks After ASM Upgrades
  • Set Environment Variables
  • Single-Instance ASM Upgrade
  • Cluster ASM Upgrade
• 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 Upgrades
  • 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 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
    • Possible Client/Server Configurations
  • Compatibility Rules for Applications When Upgrading Client/Server Software
    • Upgrading the Oracle Database Server Software
    • Upgrading the Oracle Database Client Software
  • 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 Features
• Upgrading SQL*Plus Scripts and PL/SQL
  • Evaluation of Numeric Literals
• Upgrading Oracle Forms or Oracle Developer Applications

6 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
  • Reload Oracle Application Express

7 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
  • Importing a Full Database Using a Network Link

A Behavior Changes

• Compatibility and Interoperability Issues in Oracle Database 11g Release 2 (11.2)
  • Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
  • Initialization Parameters Obsolete in Oracle Database 11g Release 2 (11.2)
  • Static Data Dictionary Views Deprecated in Oracle Database 11g Release 2 (11.2)
  • Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)
  • Deprecated Features in Oracle Database 11g Release 2 (11.2)
  • LOG_ARCHIVE_DEST_n Parameters
• Compatibility and Interoperability Issues in Oracle Database 11g Release 1 (11.1)
  • Initialization Parameters Deprecated in Oracle Database 11g Release 1 (11.1)
  • Initialization Parameters Obsolete in Oracle Database 11g Release 1 (11.1)
  • Static Data Dictionary Views with Dropped Columns in Oracle Database 11g Release 1 (11.1)
  • Deprecated Features in Oracle Database 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
  • New Default Value for UNDO_MANAGEMENT
  • LOG_ARCHIVE_DEST_n Parameters
  • SHARED_POOL_SIZE Parameter
  • JOB_QUEUE_PROCESSES Parameter
  • Automatic Diagnostic Repository
• Compatibility and Interoperability Issues in Oracle Database 10g Release 2 (10.2)
  • Initialization Parameters Deprecated in Oracle Database 10g Release 2 (10.2)
  • Initialization Parameters Obsolete in Oracle Database 10g Release 2 (10.2)
  • Static Data Dictionary Views with Dropped Columns in Oracle Database 10g Release 2 (10.2)
  • SQL
  • CONNECT Role
  • Time Zone Files
  • New Limit for FAILED_LOGIN_ATTEMPTS
• Compatibility and Interoperability Issues in Oracle Database 10g Release 1 (10.1)
  • Initialization Parameters Deprecated in Oracle Database 10g Release 1 (10.1)
  • Initialization Parameters Obsolete in Oracle Database 10g Release 1 (10.1)
  • Static Data Dictionary Views Deprecated in Oracle Database 10g Release 1 (10.1)
  • Static Data Dictionary Views Obsolete in Oracle Database 10g Release 1 (10.1)
  • Dynamic Performance Views Deprecated in Oracle Database 10g Release 1 (10.1)
  • Dynamic Performance Views Obsolete in Oracle Database 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
  • 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

B Gathering Optimizer Statistics

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

Index