1 / 29

Upgrading Your Database to Oracle Database 10 g

Upgrading Your Database to Oracle Database 10 g. Objectives. After completing this lesson, you should be able to do the following: Use Database Upgrade Assistant (DBUA) Use the manual upgrade method Use Export and Import to upgrade. Performing the Upgrade.

della
Download Presentation

Upgrading Your Database to Oracle Database 10 g

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Upgrading Your Database to Oracle Database 10g

  2. Objectives • After completing this lesson, you should be able to do the following: • Use Database Upgrade Assistant (DBUA) • Use the manual upgrade method • Use Export and Import to upgrade

  3. Performing the Upgrade • Perform the following steps to upgrade your database: 1. Prepare the Oracle8i database. 2. Install the Oracle Database 10g software. 3. Upgrade using the selected method. 4. Perform postupgrade steps. 5. Implement new features.

  4. Using DBUA to Upgrade the Database • Database Upgrade Assistant (DBUA): • Automates the upgrade process • Makes configuration recommendations • Performs preupgrade steps • Supports silent mode

  5. Using DBUA

  6. Oracle Database 10g: Simplified Upgrade • Automatically determines components that need to be upgraded • Performs all necessary upgrades in correct dependency order • Checks for components in the DBA_SERVER_REGISTRY table • Before Oracle Database 10g, much of the script invocation was manual.

  7. Choosing the Target • <Place screenshot here>

  8. Viewing and Responding to Warnings

  9. Viewing and Responding to Warnings

  10. Creating the SYSAUX Tablespace

  11. Recompiling Invalid Objects

  12. Backing Up the Database Before Upgrade

  13. Selecting Database Control

  14. Selecting Passwords

  15. Upgrade Summary

  16. Upgrade Progress

  17. Upgrade Results

  18. Using the New Preupgrade Information Utility • This new utility performs preupgrade validation tasks: • Checks for certain known database settings that may cause the upgrade to fail; generates warnings • Runs in the context of the database that you are upgrading (as SYSDBA) • Is automatically run by DBUA • Is called by the utlu101i.sql script SQL> spool 10gUP.log SQL> @utlu101i.sql Analyzing database. Please wait. This may take a minute or so... Oracle Database 10.1 Upgrade Information Tool 11-30-2003 19:09:31 **********************************************************

  19. Performing the Manual Upgrade • Install the Oracle 10g software. • Execute the preupgrade utility: • Make adjustments (as per preupgrade utility recommendations). • Shut down the database that is to be upgraded: SQL> spool 10gUP.log SQL> @utlu101i.sql SQL> shutdown immediate;

  20. Performing the Manual Upgrade • Switch to the new Oracle Database 10g home and start up the Oracle Database 10g database: • The UPGRADE clause is required to open the database when performing an upgrade. • The UPGRADE clause automatically handles the setting of certain system parameters to avoid problems during upgrade: • Sets JOB_QUEUE_PROCESSES to 0 SQL> startup upgrade;

  21. Performing the Manual Upgrade • Create the SYSAUX tablespace. • Run the upgrade script: SQL> spool O817_upgrade.log SQL> @u0801070.sql SQL> spool off

  22. Performing the Manual Upgrade • Run the postupgrade status utility: • Recompile any remaining stored PL/SQL and Java code: SQL> spool status.log SQL> @?/rdbms/admin/utlu101s.sql TEXT PL/SQL procedure successfully completed. SQL> spool off SQL> shutdown immediate; SQL> startup SQL> @utlrp.sql

  23. Using New Postupgrade Status Utility • This new utility performs postupgrade validation tasks: • Queries DBA_SERVER_REGISTRY to determine upgrade status • Provides information about invalid or incorrect component upgrades • Provides names of scripts to rerun if necessary • DBUA calls this script to display status and then takes corrective action. • Is called by the utlu101s.sql script SQL> @?/rdbms/admin/utlu101s.sql TEXT PL/SQL procedure successfully completed.

  24. Abandoning the Upgrade • Allow DBUA to restore the backup. • Manually restore the backup: • Use the same method to restore that you used to take the backup. • Restore the original control files.

  25. Using Export and Import to Upgrade to Oracle Database 10g 1. Export the database or schemas from the Oracle8i database. 2. Create an Oracle Database 10g database. 3. Import schemas into the Oracle Database 10g database.

  26. Using Export and Import to Upgrade to Oracle Database 10g 1. Export the database or schemas from the Oracle8i database. 2. Create an Oracle Database 10g database. 3. Import schemas into the Oracle Database 10g database.

  27. Using Export and Import to Upgrade to Oracle Database 10g 1. Export the database or schemas from the Oracle8i database. 2. Create an Oracle Database 10g database. 3. Import schemas into the Oracle Database 10g database.

  28. Summary • In this lesson, you should have learned how to: • Use DBUA • Use the manual upgrade method • Use Export and Import to upgrade

  29. Practice 3 Overview:Upgrading Your Database to Oracle Database 10g • This practice covers the following topics: • Executing the preupgrade script against the Oracle8i database • Importing a previously exported Oracle8idatabase into your Oracle Database 10g database • Using DBUA to upgrade the Oracle8i database to Oracle Database 10g

More Related