Upgrading a Database Using DBUA

Complete the following steps to upgrade a database using DBUA. If you need help at any window or want to consult more documentation about DBUA, then click the Help button to access the online Help.

To upgrade a database using DBUA:

1. Start DBUA. See "Starting DBUA".

2. At the Welcome window of DBUA, make sure the database being upgraded meets the specified conditions. Then, click Next.

3. At the Databases window, select the database you want to upgrade from the Available Databases table. Then, click Next.

   You can select only one database at a time. If you run DBUA from a user account that does not have SYSDBA privileges, then enter the user name and password credentials to enable SYSDBA privileges for the selected database.

4. DBUA displays a message saying it is getting database information. DBUA analyzes the selected database, performing pre-upgrade checks and displaying warnings as necessary:

   • It checks for any online redo log files of a size less than 4 megabytes (MB). If such files are found, then DBUA gives the option to drop or create new online redo log files.

   • It checks the initialization parameter file for any obsolete or deprecated initialization parameters.

   If no problems are found, then the Diagnostic Destination window appears.

5. In the Diagnostic Destination field, do one of the following:

   • Leave the setting at its default value, which is the Oracle base directory.

   • Enter a new destination.

   • Click Browse and select a new destination.

   Diagnostic Destination is the default location to store Oracle trace and diagnostic files. It replaces the initialization parameter settings for background dump destination, user dump destination and core dump destination from earlier Oracle Database releases.

   Click Next.

   The Move Database Files window appears.

6. Do one of the following:

   • Select Do Not Move Database Files as Part of Upgrade.

   • Select Move Database Files During Upgrade.

     If you choose to move database files, then you must also select either File System or Oracle Automatic Storage Management (Oracle ASM).

   Click Next.

   The Recompile Invalid Objects window appears.

7. (Optional) Select Recompile invalid objects at the end of upgrade and modify the value of degree of parallelism.

   When you upgrade your database to the new Oracle Database release, many of the PL/SQL modules in the database become invalid. By default, Oracle Database recompiles invalid PL/SQL modules as they are used, but this takes time and can result in poor performance. To eliminate these performance issues, select Recompile invalid objects at the end of upgrade. All the invalid PL/SQL modules are be recompiled immediately after the upgrade is performed. The task of recompiling all the invalid PL/SQL modules in your database can take a significant amount of time and increase the time it takes to complete your database upgrade.

   If you have multiple CPUs, then DBUA automatically adds a Degree of Parallelism menu to the Recompile Invalid Objects window. Parallel processing reduces the time it takes to recompile all the invalid PL/SQL modules in your database. DBUA automatically sets the degree of parallelism to one less than the number of available CPUs. You can select a different value from the menu.

   Note: Selecting Recompile invalid objects at the end of upgrade is equivalent to running the ORACLE_HOME/rdbms/admin/utlrp.sql script, which is used to recompile stored PL/SQL and Java code.

   Click Next.

   The Backup window appears.

8. Select one of the following options:

   • I have already backed up my database.

   • I would like this tool to back up the database.

     If you use DBUA to back up your database, then DBUA makes a copy of all database files in the directory that you specify in the Backup Directory field. DBUA performs this consistent backup automatically after it shuts down the database and before it begins the upgrade process. The backup does not compress the database files.

     In the Backup Directory field, do one of the following:

     • Leave the setting at its default value

     • Enter a different valid file system path. You cannot specify a raw device for the backup files.

     • Click Browse and select a new backup destination.

   Oracle strongly recommends that you back up your database before starting the upgrade. If errors occur during the upgrade, then you may need to restore the database from the backup.

   In addition to creating a backup of your database, DBUA creates an executable script in the directory specified in the Backup Directory field. If needed, you can use the executable script appropriate to your system to restore the database files:

   • Microsoft Windows: db_name_restore.bat

   • Linux or UNIX systems: db_name_restore.sh

   Click Next.

   The Recovery Configuration window appears.

9. In the Fast Recovery Area field, do one of the following:

   • Leave the setting at its default value

   • Enter a different fast recovery area

   • Click Browse and select a different fast recovery area.

   The fast recovery area can be used to recover data that would otherwise be lost during a failure. This location is also used by Enterprise Manager if you have enabled local management and daily backups on the Database Control Management Options page.

   In the Fast Recovery Area Size field, select the units you want from the list and do one of the following:

   • Leave the setting at its default value.

   • Enter a different value for Fast Recovery Area Size.

   • Use the up and down arrows to set a different Fast Recovery Area Size.

   In the Recovery Configuration window, you specify a fast recovery area and enable archiving. It is important to configure these features for your database so you can recover your data if a failure occurs.

   Click Next.

   The Summary window appears.

10. Review the list the initialization parameters that will be set for the database during the upgrade. Click Back to correct any errors, or click Finish.

    Note: The database is not be available for general use during the upgrade process that begins when you click Finish.

    A Progress window appears and DBUA begins to perform the upgrade.

11. You might encounter error messages with Ignore and Abort choices:

    • Ignore - Ignores the error, skips the current step, and proceeds with the upgrade. The ignored errors are logged and shown later in the summary. After the upgrade is complete, you can fix the problem, restart DBUA, and complete the skipped steps.

    • Abort - Stops the upgrade process. DBUA prompts you to restore the database if the database backup was performed by DBUA. After the database has been restored, correct the error and restart DBUA to perform the upgrade again. If you do not restore the database, then DBUA leaves the database in its current state so that you can proceed with a manual upgrade.

    After the upgrade has completed, the following message is displayed:

    Upgrade is complete. Click "OK" to see the results of the upgrade.
    

    Click OK.

    The Upgrade Results window appears.

12. Examine the results of the upgrade. The upgrade results summary describes the original and upgraded databases and changes made to the initialization parameters.

    The upgrade results also include an Upgrade Details section that describes the steps performed during the database upgrade. This section provides each step name, the log file for the step, and the status. In some cases, you can click the status to display details about the execution step. The Upgrade Details section also includes the directory where the various log files are stored after the upgrade. You can examine any of these log files to obtain more details about the upgrade process.

    Note: An HTML version of the Upgrade Results is also saved in the log files directory.

13. Click Configure Database Passwords.

    The Password Management dialog box appears.

14. The Password Management dialog box enables you to change the default password for a user after you upgrade the database.

    Note: To prevent unauthorized use of the database, change all user passwords immediately after you upgrade your database.

    Click the Lock Account? column for a user to lock or unlock an account. A check mark indicates that the account is locked.

    Enter a new password for a user in its New Password column.

    Confirm the new password by entering it in the Confirm Password column.

    Click OK to return to the Upgrade Results window.

15. Click Restore if you are not satisfied with the upgrade results.

    Depending on the method you used to back up your database, the restore operation performs one of the following tasks:

    • If you used DBUA to back up your database, then clicking Restore copies the original database files and the original database settings from the backup.

    • If you used your own backup procedure to back up the database, then clicking Restore copies only the original database settings. To restore the database itself, copy the data files from the backup you created using your own backup utilities.

    Click Close to quit DBUA if you are satisfied with the upgrade results.

    DBUA removes the entry of the upgraded database from the old listener.ora file and restarts the listener.