Q
Manage Learn to apply best practices and optimize your operations.

How to use the Oracle Database Upgrade Assistant (DBUA)

Oracle expert Brian Peasland explains in what scenarios to use the Oracle Database Upgrade Assistant and more about the Oracle DBUA in this expert tip.

What would be best strategy for upgrading the following Oracle databases?

  1. Small size Oracle database
    (15gb to 100 gb)
    (from 9.2.0.6 to 10.2.0.4) on AIX 5.x
  2. Large size Oracle database
    (200 GB to 1 TB)
    (from 9.2.0.8 to 10.2.0.4) on AIX 5.x
For both scenarios, I would use the Database Upgrade Assistant (DBUA) in Oracle. The DBUA works well on both large and small databases. The DBUA is one of the few upgrade methods that works well and is relatively quick for large databases. And since you are staying on the same OS during your upgrades, the DBUA will work for your needs. For more information on the DBUA, please refer to the 10g Migration Guide.
This was last published in October 2009

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close