The pre upgrade, upgrade, or post upgrade steps that a user should follow to ensure a successful upgrade. For information on all these steps, see the following:. Oracle Database Upgrade Guide 11g Release 2 (Part Number E10819-02). Oracle Database Upgrade Companion 11g Release 2 (My Oracle Support Note 785351.1). Oracle Database 11g.
![]()
8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Home » Articles » 11g » Here
This article provides a brief overview of the areas involved in upgrading existing databases to Oracle 11g Release 1. The article provides the minumum information needed when preparing for the 11g Database Administation OCP upgrade exam, including:
The whole migration process is beyond the scope of this article so please refer to the Upgrading to the New Release document for further information.
Supported Upgrade Paths
Direct upgrades to 11g are possible from existing databases with versions 9.2.0.4+, 10.1.0.2+ or 10.2.0.1+. Upgrades from other versions are supported only via intermediate upgrades to a supported upgrade version.
The preferred upgrade method is to use the Database Upgrade Assistant (DBUA), a GUI tool that performs all necessary prerequisite checks and operations before upgrading the specified instances. The DBUA can be started directly from the Oracle Universal Installer (OUI) or separately after the software installation is complete.
Alternatively you may which to perform a manual upgrade which involves the following steps:
An alternative to these upgrade methods is to use the export and import utilities (exp/imp or expdp/impdp). This enables upgrades from a wider variety of Oracle versions and has the advantage of leaving the original database available as a fallback option. The down sides of this approach are it is much slower, and it requires enough disk space to hold two copies of the database and the export dump file.
Pre-Upgrade Validation Checks
The '$ORACLE_HOME/rdbms/admin/utlu111i.sql' script performs pre-update validation checks on an existing instance. The script checks a number of areas to make sure the instance is suitable for upgrade including:
The issues indicated by this script should be resolved before a manual upgrade is attempted. The type of output you can expect is displayed below.
Database Upgrade Assistant (DBUA)
The Database Upgrade Assistant (DBUA) is a GUI tool that guides the user through the whole upgrade process, including all the steps listed in the manual upgrade process. The assistant is started using the
dbua command in UNIX and Linux environments or from the Start menu (Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Upgrade Assistant) in Windows environments.
Once the assistant has started it leads the user through the several steps including:
The DBUA can also be started in silent mode provided all the necessary parameters are provided.
For more information see:
![]()
Hope this helps. Regards Tim...
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |