Skip Headers
< tr>
Oracle® Database Upgrade Guid e
10
g
Release 1 (10.1)
Part Number B10763-01
Home
Book List
Index
Master Index
Feedback
Next
View PDF
< div class="IND">
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Intended Audience
Docum entation Accessibility
Structure
Related Docum ents
Conventions
1
Introduction
Overview of the Dat abase Upgrade Process
Role of the Database Administrator During the Upgrade
Role of the Application Developer During the Upgrade
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 Databas e to the Current Release
Upgrade Clients to the Current Release
Using Optimal Flexible Architecture (OFA)
Changing Word Size
Rolling Upgrades
Deinstalling Options
2
Preparing to Upgrade
Prepare to Upgrade
Become Familiar with the Features of the New Oracle Database 10
g
Release
Determine the Up grade Path to the New Oracle Database 10
g
Release
Choose an Upgrade Method
Database Upgrade Assistant
Manual Upgrade
< /dd>
Export/Import
Data Copying
Choose an Oracle Home Directory for the New Oracle Database 10
g
Release
Prepare a Backup Strategy
Develop a Testing Plan
Upgrade Testing
Minimal Testing
Functional Testing
Integration Testing
P erformance Testing
Volume and Load Stress Testing
Specific Pre-Upgrade and Post-Upgrade Tests
Test the Upgrade Process
Test the Upgraded Test Database
3
Upgrading a Database to the New Oracle Database 10
g
Release< /font>
System Considerations and Requirements
Upgrading a Cluster Database
Gather Optimizer Statistics Before the Up grade
Upgrading Your Operating System
Migra ting Data to a Different Operating System
Install the Release 10.1 Oracle Soft ware
Upgrade the Database Using the Database Upgrade Assistant
Starting the Database Upgrade Assistant
Database Upgrade A ssistant Command Line Options
Upgrade the Database
Using the Database Upgrade Assistant in Silent Mode
Upgrade the Databa se Manually
Analyze the Database to be Upgraded
Database
Logfiles
Tablespaces
Options
Update Parameters
Deprecated Parameters
Obsolete Parameters
Components
SYSAUX Tablespace
< dd>
Backup the Database
Upgrade the Database
Troubleshooting the Upgrade
SYSTEM Tablespace
Shared Memory
Public Rollback Segment
< /dd>
Abandoning the Upgrade
4
After Upgrading a Database
Tasks to Complete After Upgrading Your Database
Back Up the Database
Change Passwords for Oracle-Supplied Accounts
Upgrading from the Standard Edition to the Enterprise Edition
Upgrading and Tablespace Alerts
Migrate Your Oracle Managed Files
Migrate Your Initialization Parameter File to a Server Parameter File
Migr ate Tables from LONGs to LOBs
Modify Your listener.ora File
Upgrade Your Standby Database
Prepare to Upgrade
Upgrade the Production Site
Upgrade or Downgrade the Or acle Data Guard Broker
Upgrading Oracle Text
Supplied Knowledge Bases
Copy Files from the Previous ORACLE_HOME to the New ORACLE_HOME
Add New Features as Appropriate
Develop New Administrative Procedures as Needed
Adjust Your Parame ter File for the New Release
Tasks to Complete Only After Upgrading a Release 8.1.7 or Lower Database
Upgrade User NCHAR Columns
Migrate Your Server Manager Line Mode Scripts to SQL*Plus
Ta sks to Complete Only After Upgrading a Release 8.0.6 Database
Avoid Problems w ith Parallel Execution
Normalize Filenames on Windows Operating Systems
Rebuild Unusable Function-Based Indexes
Upgrade Materialize d Views
Upgrade Your Queue Tables
Upgrade t he Recovery Catalog
Upgrade Statistics Tables Created by the DBMS_STATS Package
Test the Database and Compare Results
Tune the Upgraded Database
Changing the Word Size of Your Current Relea se
5
Compatibil ity and Interoperability
What Is Compatibility?
The COMPATIBLE Initialization Parameter
Downgrading an d 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
Raising the COMPATIBLE Initialization Parameter
What Is In teroperability?
Compatibility and Interoperability Issues Introduced in Oracle Database 1 0
g
Release 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
Real Application Clusters
Materialized Views
Change Data Capture
Change in the Default Archival Processing to Remote Archive Destinations
Compatibility and Interoperability Issues Introduced in Oracle9
i
Release 9.2
Locally Managed SYSTEM Tablespace
New AnyData DAtatypes
Dictionary Managed Tablespaces
Change in Compatibility for Automat ic Segment-Space Managed Tablespaces
Compatibility and Object Types
Oracle Managed Files
Oracle OLAP
Log Format Change with Parallel Redo
Oracle Dynamic Services
Oracle Syndication Server
Compatibility and Interope rability Issues Introduced in Oracle9
i
Release 9.0.1
The STARTUP Comma nd
Change in Default Parameter File Selection
Tablespaces and Datafiles
CREATE TABLESPACE: New Behavior< /a>
Default Temporary Tablespaces
Undo Tablespace s
Datatypes
Datetime and Interval Datatypes
Database Character Sets
AL 24UTFFSS Character Set Desupported
User-Defined Datatypes
Subtypes and Non-Final Types
Oracle Replicatio n
CHAR Column Length Semantics
NCHA R or NVARCHAR2 Columns
Compatibility and Interoperability Issues Intr oduced in Oracle8
i
Release 8.1
Applications
General Compatibility and Interoperability Issues for Applications
OCI Applications
Precompiler Applications
PL/SQL Applications
Tablespaces and Datafiles
Transportable Tablespace
Tempfiles
Data Dictionary
Data Dictionary Protection
Schema Objects
Bitmap Index Protectio n
Datatypes
Large Objects (LOBs)
Oracle ROWIDs
NCHAR and NLS Environme nt Variables and Compatibility
User-Defined Datatypes
New Format for User-Defined Datatypes
Nested Tables
Varrays Stored as LOBs
SQL and PL/SQL
Functions GREATEST_LB, LEAST_UB, and TO_LABEL Desupported
SQL Scripts utlchain.sql and utlchn1.sql
SQL Scripts utlexcpt.sql and u tlexpt1.sql
Advanced Queuing (AQ)
Interoperability and the Sender's ID Column
Rule Based Subscriptions
Oracle Optimizer
Real Application Clusters
INSTANCES Keyword in PARALLEL Clause
Database Security
Enterprise User Management
Database Backup and Recovery
Recovery Manager
< /dd>
Recovery Manager Commands
Datafile Backups
Standby Database
Fast-Start On-Demand Rollback and Fast-Start Parallel Rollback
Archiving of Redo Logs
LogMiner
Oracle Media Management API and Proxy Copy
Distributed Databases
Materialized Views
< a href="compat.htm#sthref609">Oracle Replication
Heterogeneous Services Agents
Net8
Service Naming and Connection Load Balancing
6
Upgrading Your Applications
Overview of Upgrading Application s
Compatibility Issues for Applications
Upgrading Precompiler and OCI Applications
Understanding Software Upgrade s 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 Datab ase Server Software
Upgrading the Oracle Database Client Software
Upgrading Options for Your Precompiler and OCI Applications
Option 1: Leave the Application Unchanged
Option 2: Relink the Application with the New O racle Database 10
g
Libraries
Option 3: Precompile or Compile the Application Using the New Software
Option 4: Change the Application Code to Use New Oracle Database 10
g Features
Upgrading SQL*Plus Scripts
Upgrading Oracle Forms or Oracle Developer Applications
7
Downgrading a Database Back to the Previous Oracle Database Release
< /h3>
Supported Releases for Downgrading
Che ck for Incompatibilities
Perform a Full Offline Backup
Downgrade the Database
8
Data Copying Using Export/Import
Export and Import R equirements
Export/Import Usage on Data Incompatible with a Previous Release
Upgrade the Database Using Export/Import
A
Initialization Parameter and Data Dictionary Changes< /font>
Initialization Parameter Changes
Deprecated Initialization Parameters
Initialization Parameters Dep recated in Release 10.1
Initialization Parameters Deprecated in Release 9.2
Initialization Parameters Deprecated in Release 9.0.1
Obsolete Initialization Parameters
Initialization Parameters Obsolete in Release 10.1
Initialization Parameters Obsolete in Release 9.2
Initialization Parameters Obsolete in Release 9.0.1
Initializati on Parameters Obsolete in Release 8.1
Compatibility Issues with Init ialization Parameters
Change in Behavior for SESSION_CACHED_CURSORS
< dd>
New default value for DB_BLOCK_SIZE
OPTIMIZER_MAX_PER MUTATIONS 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
New Default Value for DB_BLOCK_CHECKSUM
Maximum Number of Job Queue Processes
< dd>
SORT_AREA_SIZE and SORT_DIRECT_WRITES Parameters
New Default Value for LOG_CHECKPOINT_TIMEOUT
The O7_DICTIONARY_ACCESSIBILITY Parameter
The DB_DOMAIN Parameter
Parallel Execution Alloc ated from Large Pool
Retaining Parameter Settings without Modifications
Using PARALLEL_AUTOMATIC_TUNING
Using PARALLEL_AU TOMATIC_TUNING and Setting LARGE_POOL_SIZE
Using PARALLEL_AUTOMATIC_TUNING without Modif ying SHARED_POOL_SIZE
Archive Log Destination Parameters
Changing to the New Archive Log Destination Parameters
Changing Back to the Old Archive Log Destination Parameters
Possible Errors During the Transition in Parameters
Static Data Dictionary View Changes
Deprecated Static Data Dictionary Views
Static Data Dictionary Views Deprecated in Release 10.1
Static Data Dictionary Views Deprecated in Release 9.2
Static Data Dictionary Views Deprecated in Release 9.0. 1
Static Data Dictionary Views Deprecated in Release 8.1
Obsolete Static Data Dictionary Views
Static Data Dict ionary Views Obsolete in Release 10.1
Static Data Dictionary Views with Rename d Columns
Static Data Dictionary Views with Renamed Columns in Release 9.0.1
Static Data Dictionary Views with Dropped Columns
Static Data Dictionary Views with Dropped Columns in Release 9.0.1
Static Data Dictionary Views with Dropped Columns in Release 8.1
Static D ata Dictionary Views with Columns That May Return Nulls
Dynamic Performance Vi ew Changes
Deprecated Dynamic Performance Views
Dynamic Performance Views Deprecated in Release 10.1
Dynamic Pe rformance Views Deprecated in Release 9.2
Dynamic Performance Views Deprecated in Releas e 9.0.1
Obsolete Dynamic Performance Views
Dynamic Performance Views Obsolete in Release 10.1
Dynamic Performan ce Views Obsolete in Release 9.2
Dynamic Performance Views Obsolete in Release 9.0.1
Dynamic Performance Views Obsolete in Release 8.1
Dynamic Performance Views with Renamed Columns
Dynamic Performan ce Views with Renamed Columns in Release 9.2
Dynamic Performance Views with Renamed Colu mns in Release 9.0.1
Dynamic Performance Views with Renamed Columns in Release 8.1
Dynamic Performance Views with Dropped Columns
Dynamic Performance Views with Dropped Columns in Release 9.2
Dynamic Performance Views with Dropped Columns in Release 9.0.1
Dynamic Performance Views with Dropped Columns in Release 8.1
B
Migrating from Server Manager to SQL*Plus
Startup Differences
Starting Server Manager
Starting SQL*Plus
Starting SQL*Plus with the NOLOG Option
Starting SQL*Plus with Connect Information
Starting SQL* Plus without Options or Connect Information
Commands
Commands Introduced in SQL*Plus Release 8.1
Command s Common to Server Manager and SQL*Plus
SQL*Plus Equivalents for Server Manager Commands< /a>
Possible Differences in the SET TIMING Command
Server Manager Commands Unavailable in SQL*Plus
Syntax Differences
< dd>
Comments
REMARK Command (or REM)
SQL Comment Delimiters, /* ... */
ANSI/ISO Comm ents, --
Server Manager Pound (#) Comments
Blank Lines
The Hyphen Continuation Character
Hyphens Used as Dividing Lines
Hyphens Used as Minus Signs
Ampersands
Using the SET ESCAPE Comm and
Using the SET DEFINE OFF Command
CREATE TYPE and CREATE LIBRARY Commands
COMMIT Command
Index
< /body>
