Oracle® Database
Upgrade Guide
11
g
Release 1 (11.1)
B28300-03
August 2008
Oracle Database Upgrade Guide, 11
g
Release 1 (11.1)
B28300-03
Copyright © 2002, 2008, Oracle. All rights reserved.
Primary Authors: Viv Schupmann, Tony Morales, Craig B. Foch
Contributors: Thomas Baby, Michael Brey, Bridget Burke, Rae Burns, Vickie Carbonneau, Sunil
Chakkappen, Ramesh Chakravarthula, Alan Choi, George Claborn, Ian Dai, Mark Drake, Mohammad
Faisal, Mark Fallon, Steve Fogel, Leonidas Galanis, Shie-rei Huang, Pat Huey, John Hwee, Rich Long,
Venkat Maddali, Matthew McKerley, Mughees Minhas, Wataru Miyoshi, Valarie Moore, Louise Morin, Carol
Palmer, Satish Panchumarthy, Robert Pang, Ravi Pattabhi, Naga Prakash, Irfan Rafiq, Mark Ramacher,
Kathy Rich, Tsuyoshi Sano, Ranu Sharma, Janelle Simmons, Virender Singh, Jason Straub, Roy Swonger,
Carol Tagliaferri, Venkateshwaran Venkataramani, Sam Wegner, Douglas Williams, Terri Winters, Mohamed
Ziauddin
The Programs (which include both the software and documentation) contain proprietary information; they
are provided under a license agreement containing restrictions on use and disclosure and are also protected
by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly,
or decompilation of the Programs, except to the extent required to obtain interoperability with other
independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in
the documentation, please report them to us in writing. This document is not warranted to be error-free.
Except as may be expressly permitted in your license agreement for these Programs, no part of these
Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any
purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on
behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical
data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental
regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including
documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable
Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19,
Commercial Computer Software—Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway,
Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy and other measures to ensure the safe use of such applications if the Programs are used for such
purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third
parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites.
You bear all risks associated with the use of such content. If you choose to purchase any products or services
from a third party, the relationship is directly between you and the third party. Oracle is not responsible for:
(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the
third party, including delivery of products or services and warranty obligations related to purchased
products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from
dealing with any third party.
iii
Contents
Preface
................................................................................................................................................................
xi
Audience......................................................................................................................................................
xi
Documentation Accessibility....................................................................................................................
xii
Related Documentation.............................................................................................................................
xii
Conventions ...............................................................................................................................................
xiii
What’s New in Oracle Database Upgrade Guide
.....................................................................
xv
1 Introduction to the Database Upgrade Process
Overview of the Database Upgrade Process
.......................................................................................
1-1
Oracle Release Numbers
.........................................................................................................................
1-5
Running Multiple Oracle Releases ..................................................................................................
1-5
Install Databases in Multiple Oracle Homes on the Same Computer.................................
1-6
Install Databases in Multiple Oracle Homes on Separate Computers................................
1-6
Upgrade a Database to the Current Release ...........................................................................
1-6
Upgrade Clients to the Current Release ..................................................................................
1-6
Compatibility and Interoperability
......................................................................................................
1-6
What Is Compatibility?......................................................................................................................
1-7
The COMPATIBLE Initialization Parameter...........................................................................
1-7
What Is Interoperability? ..................................................................................................................
1-8
Using Optimal Flexible Architecture (OFA)
.......................................................................................
1-9
Converting Databases to 64-bit Oracle Database Software
.............................................................
1-9
Rolling Upgrades
...................................................................................................................................
1-10
Moving From the Standard Edition to the Enterprise Edition
.....................................................
1-11
Moving From the Enterprise Edition to the Standard Edition
.....................................................
1-12
Upgrading from Oracle Database Express Edition to Oracle Database
.....................................
1-12
2 Preparing to Upgrade
Prepare to Upgrade
...................................................................................................................................
2-1
Become Familiar with New Oracle Database Features.................................................................
2-1
Determine the Upgrade Path............................................................................................................
2-2
Choose an Upgrade Method.............................................................................................................
2-3
Database Upgrade Assistant .....................................................................................................
2-3
Manual Upgrade .........................................................................................................................
2-3
Export/Import.............................................................................................................................
2-4
iv
Choose an Oracle Home Directory..................................................................................................
2-5
Develop a Testing Plan......................................................................................................................
2-5
Upgrade Testing..........................................................................................................................
2-6
Minimal Testing ..........................................................................................................................
2-6
Functional Testing.......................................................................................................................
2-6
Integration Testing......................................................................................................................
2-6
Performance Testing...................................................................................................................
2-6
Volume and Load Stress Testing ..............................................................................................
2-9
Prepare a Backup Strategy................................................................................................................
2-9
Test the Upgrade Process
.....................................................................................................................
2-10
Test the Upgraded Test Database
.......................................................................................................
2-10
3 Upgrading to the New Release
System Considerations and Requirements
.........................................................................................
3-1
Upgrading Oracle Clusterware and Automatic Storage Management (ASM) Databases .....
3-2
Upgrading an Oracle Real Application Clusters (Oracle RAC) Database..........................
3-2
Upgrading Automatic Storage Management (ASM) Instances............................................
3-3
Upgrading with Read-Only and Offline Tablespaces...................................................................
3-4
Upgrading Standby Databases.........................................................................................................
3-4
Upgrading Your Operating System.................................................................................................
3-5
Migrating Data to a Different Operating System ..........................................................................
3-5
Upgrading Databases That Use Oracle Streams Downstream Capture ....................................
3-6
Install the New Oracle Database Software
.........................................................................................
3-6
Install the Latest Available Patchset Release and Any Required Patches
....................................
3-8
Run the Pre-Upgrade Information Tool
...............................................................................................
3-8
Prepare the Database to Be Upgraded
...............................................................................................
3-12
Deprecated CONNECT Role.........................................................................................................
3-13
Access Control to Network Utility Packages ..............................................................................
3-13
Database Links with Passwords ...................................................................................................
3-14
TIMESTAMP WITH TIME ZONE Data Type.............................................................................
3-14
Optimizer Statistics.........................................................................................................................
3-15
Disable Oracle Database Vault......................................................................................................
3-15
Save Oracle Enterprise Manager Database Control Data .........................................................
3-16
Complete Materialized View Refreshes.......................................................................................
3-18
Ensure No Files Need Media Recovery .......................................................................................
3-18
Ensure No Files Are in Backup Mode..........................................................................................
3-18
Resolve Outstanding Distributed Transactions..........................................................................
3-18
Sync Standby Database with the Primary Database..................................................................
3-18
Run the Oracle Net Configuration Assistant
..................................................................................
3-19
Upgrade a Database Using Database Upgrade Assistant
..............................................................
3-19
Using the DBUA Graphical User Interface..................................................................................
3-20
Using DBUA in Silent Mode..........................................................................................................
3-37
Upgrade a Database Manually
...........................................................................................................
3-41
Back Up the Database.....................................................................................................................
3-41
Prepare the New Oracle Home .....................................................................................................
3-42
Upgrade the Database ....................................................................................................................
3-43
Troubleshoot the Upgrade.............................................................................................................
3-49
v
Resource Limits........................................................................................................................
3-49
Component Status....................................................................................................................
3-50
Rerunning the Upgrade ..........................................................................................................
3-51
Cancel the Upgrade ........................................................................................................................
3-51
Upgrade an ASM Instance with DBUA
............................................................................................
3-51
Upgrade an ASM Instance Manually
................................................................................................
3-56
Reconfigure Oracle Cluster Synchronization Services ..............................................................
3-56
Prepare the New ASM Oracle Home ...........................................................................................
3-57
Upgrade ASM..................................................................................................................................
3-58
Troubleshoot the ASM Upgrade...................................................................................................
3-60
Cancel the ASM Upgrade ..............................................................................................................
3-60
4 After Upgrading to the New Release
Required Tasks After Database Upgrades
..........................................................................................
4-1
Update Environment Variables (Linux and UNIX Systems Only).............................................
4-1
Upgrade the Recovery Catalog ........................................................................................................
4-2
Upgrade Statistics Tables Created by the DBMS_STATS Package.............................................
4-2
Upgrade Externally Authenticated SSL Users...............................................................................
4-2
Install Oracle Text Supplied Knowledge Bases .............................................................................
4-2
Update Your Oracle Application Express Configuration ............................................................
4-3
Configure Fine-Grained Access to External Network Services...................................................
4-3
Enable Oracle Database Vault..........................................................................................................
4-4
Deploy Database Vault Administrator (DVA)............................................................................... 4-4
Recommended Tasks After Database Upgrades ................................................................................ 4-6
Recommended Tasks After All Database Upgrades..................................................................... 4-6
Back Up the Database ................................................................................................................ 4-6
Reset Passwords to Enforce Case-Sensitivity.......................................................................... 4-6
Upgrade Automatic Storage Management (ASM)................................................................. 4-7
Add New Features as Appropriate .......................................................................................... 4-7
Develop New Administrative Procedures as Needed .......................................................... 4-7
Set Threshold Values for Tablespace Alerts............................................................................ 4-7
Migrate From Rollback Segments to Automatic Undo Mode.............................................. 4-8
Configure Oracle Data Guard Broker ...................................................................................... 4-9
Migrate Tables from the LONG Data Type to the LOB Data Type ..................................... 4-9
Test the Upgraded Production Database ................................................................................ 4-9
Recommended Tasks After Upgrading an Oracle Database 10g Release 1 (10.1) Database 4-10
Upgrade Change Data Capture ............................................................................................. 4-10
Configure Secure HTTP .......................................................................................................... 4-10
Provide Anonymous Access to XML DB Repository Data Through HTTP.................... 4-11
Recommended Tasks After Upgrading an Oracle Express Edition Database ....................... 4-11
Tasks to Complete Only After Manual Database Upgrades......................................................... 4-11
Change Passwords for Oracle-Supplied Accounts .................................................................... 4-12
Migrate Your Initialization Parameter File to a Server Parameter File................................... 4-12
Upgrade Oracle Text....................................................................................................................... 4-13
Upgrade the Oracle Cluster Registry (OCR) Configuration..................................................... 4-13
Adjust the Initialization Parameter File for the New Release .................................................. 4-13
Setting the COMPATIBLE Initialization Parameter ........................................................... 4-14
