Upgrade the Database Using the Database Upgrade Assistant (DBUA).
1) Set the ORACLE_HOME, ORACLE_BASE, PATH environmental variable to Oracle10g accordingly.
2) Start the Database Upgrade Assistant from ORACLE_HOME/bin by entering the following command at system prompt
1) When the Database Upgrade Assistant starts, its Welcome screen appears as follows.
Click on next.
2) Next screen will display all the databases which can be upgraded to 10g. Select one which you want to upgrade. Then click next.
3) The Database Upgrade Assistant analyzes the database, performs pre-upgrade checks and displays warnings as necessary:
4) At the Creating the SYSAUX Tablespace screen, specify the attributes for the SYSAUX tablespace, which is added automatically to all new Oracle Database 10g databases. Then, click next.
5) At the Recompiling Invalid Objects screen, decide whether the Database Upgrade Assistant to recompile all invalid PL/SQL modules after the upgrade is complete. Select Recompile invalid objects at the end of upgrade. When you select this option, the Database Upgrade Assistant recompiles all the invalid PL/SQL modules immediately after the upgrade is performed. Then, click next.
6) At the Choosing a Database Backup Procedure screen, specify whether or not you want the Database Upgrade Assistant to back up database. Then, click next.
If you choose not to use the Database Upgrade Assistant for your backup, then it is assumed that you have already backed up your database using your own backup procedures. It is strongly recommended that you back up your database before the upgrade. If errors occur during the upgrade, then you may need to restore the database from the backup.
7) At the Management Options screen, you have the option of setting up your database so it can be managed with Enterprise Manager. Enterprise Manager provides Web-based management tools for managing individual database instances, as well as central management tools for managing your entire Oracle environment, including multiple databases, hosts etc.
• When you run the Database Upgrade Assistant, the assistant checks to see if the Oracle Management Agent has been installed on the host computer. If the assistant locates an Oracle Management Agent, select the Grid Control option and select an Oracle Management Service from the drop-down list. When you finish installing the Oracle Database, the database will automatically be available as a managed target within the Oracle Enterprise Manager Grid Control.
• If you are not centrally managing your Oracle environment, you can still use Enterprise Manager to manage your database. When you install an Oracle Database, you automatically install the Oracle Enterprise Manager Database Control, which provides Web-based features for monitoring and administering the single-instance or cluster database you are installing.
To configure the database so it can be managed with the Oracle Enterprise Manager Database Control, select the Database Control option.
On Database control management option you can configure OEM for E-mail notifications, Backups.
• After selecting proper choices, click next.
8) At the Recovery Configuration screen, specify a flash recovery area and enable archiving. When you are managing your database, it is important to configure the database so you can recover your data in the event of a system failure.
The Flash Recovery Area can be used to recover data that would otherwise be lost during a system failure; this location is also used by Enterprise Manager if you have enabled local management and daily backups on the Management Options screen shown previously in the Database Upgrade Assistant.
9) At the Database Credentials screen, you can set a single password, which will be applied to each of the listed Enterprise Manager user accounts, or by providing unique passwords for each user.
10) At the Summary screen, make sure all of the specifications are correct. If anything is incorrect, then click Back until you can correct the specification. If everything is correct, then click Finish.
11) A Progress dialog appears and the Database Upgrade Assistant begins to perform the upgrade.
After the upgrade has completed, the following message is displayed in the Progress dialog:
Upgrade has been completed. Click the "OK" button to see the results of the upgrade.
Click OK button.
12) At the Checking Upgrade Results screen, examine the results of the upgrade, and if necessary, restore the original database settings.