This topic describes the functionality of Database Upgrade Assistant (DBUA), and it includes the following topics:
DBUA helps you upgrade and configure a database, to run with the new Oracle Database 11g Release 2.
DBUA automates the upgrade process by performing all of the tasks that are normally done manually. DBUA makes appropriate recommendations for configuration options such as tablespaces, redo logs, and so on. You can then act on these recommendations. For example, DBUA recommends sizing information for the new SYSAUX tablespace, which is required in Oracle Database 11g Release 2.
Before upgrading your database, DBUA checks for invalid user accounts or roles, invalid datatypes, or desupported character sets. DBUA also checks for adequate resources, including rollback segments and free disk space and, optionally, backs up all necessary files.
DBUA does not begin the upgrade until it completes all of the the initialization steps.
Note: If you are performing an upgrade on a Windows platform (only), ensure that all of the applications that are associated with the Oracle Database Service, such as the Services Panel, Registry Editor, and the Performance Monitor, are closed before clicking on Finish, in the Summary page of the DBUA.
If any of the above-mentioned applications are left open during upgrade or when you are restoring the database (in the event of an upgrade failure), then the following error message may be displayed:
Error in Process: ORACLE_BASE\ORACLE_HOME\bin\oradim.exe
Upgrade failed due to running the step "Upgrading Oracle Server"
"DIM-00020: A service for this
SID is already created. Please enter a different SID name. No action has been
taken O/S-Error: (OS 1072) The specified service has been marked for deletion."
As a workaround to this problem, restart the machine and manually recreate the Oracle Database Service using the ORADIM utility before re-starting DBUA.
DBUA has built-in intelligence to automatically modify or create new required
tablespaces. DBUA also runs the appropriate script, archives the redo logs, and disables archiving
during an upgrade.
While the upgrade is running, DBUA shows the upgrade progress for each component.
DBUA writes detailed trace and logs files and produces a complete HTML report
for later reference. To enhance security, DBUA automatically locks new user
accounts in the upgraded database. DBUA then proceeds to create new configuration
files (init.ora, spfile, and listener files) in the new Oracle home.
DBUA is fully compliant with Oracle RAC environments. In Oracle RAC environments, DBUA upgrades all of the the database and configuration files on all of the nodes in a cluster.
DBUA supports a silent mode of operation where no user interface is presented to the user. Silent mode enables you to use a single command for the upgrade. For example, the following command upgrades a 9.2.0.4 database to Oracle Database 11.2:
dbua -silent -dbName ora9idb
For command line features, use the -help
option of DBUA. For example:
dbua -help
See Oracle Database Upgrade and your platform-specific documentation for additional instructions on upgrading your Oracle Database.
The Database Upgrade Assistant helps you upgrade the following versions of the Oracle Database to Oracle Database 11g Release 2:
Oracle9i Release 9.2.0.4 and higher (single-instance Oracle databases and Oracle RAC databases)
Oracle 10g Release 1 (10.1) (single-instance Oracle databases and Oracle RAC databases)
Overview of the Database Upgrade Assistant
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.