Skip Headers
Oracle® Database Upgrade Guide
11g Release 1 (11.1)
Part Number B28300-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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 10
g
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 11
g
Release 1 (11.1)
Compatibility and Interoperability Issues Introduced in 11
g
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 11
g
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 10
g
Release 2 (10.2)
SQL
CONNECT Role
Time Zone Files
New Limit for FAILED_LOGIN_ATTEMPTS
Compatibility and Interoperability Issues Introduced in 10
g
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 11
g
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 11
g
Release 1 (11.1)
Initialization Parameters Deprecated in Oracle Database 10
g
Release 2 (10.2)
Initialization Parameters Deprecated in Oracle Database 10
g
Release 1 (10.1)
Initialization Parameters Deprecated in Oracle9
i
Release 2 (9.2)
Obsolete Initialization Parameters
Initialization Parameters Obsolete in Oracle Database 11
g
Release 1 (11.1)
Initialization Parameters Obsolete in Oracle Database 10
g
Release 2 (10.2)
Initialization Parameters Obsolete in Oracle Database 10
g
Release 1 (10.1)
Initialization Parameters Obsolete in Oracle9
i
Release 2 (9.2)
Compatibility Issues with Initialization Parameters
Compatibility Issues Introduced in Oracle Database 11
g
Release 1 (11.1)
New Default Value for UNDO_MANAGEMENT
Compatibility Issues Introduced in Oracle Database 10
g
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 11
g
Release 1 (11.1)
Static Data Dictionary Views Deprecated in Oracle Database 10
g
Release 1 (10.1)
Static Data Dictionary Views Deprecated in Oracle9
i
Release 2 (9.2)
Obsolete Static Data Dictionary Views
Static Data Dictionary Views Obsolete in Oracle Database 10
g
Release 1 (10.1)
Static Data Dictionary Views with Dropped Columns
Static Data Dictionary Views with Dropped Columns in Oracle Database 11
g
Release 1 (11.1)
Static Data Dictionary Views with Dropped Columns in Oracle Database 10
g
Release 2 (10.2)
Dynamic Performance View Changes
Deprecated Dynamic Performance Views
Dynamic Performance Views Deprecated in Oracle Database 10
g
Release 1 (10.1)
Dynamic Performance Views Deprecated in Release 9.2
Obsolete Dynamic Performance Views
Dynamic Performance Views Obsolete in Oracle Database 10
g
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