Manage

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.

Brian Peasland

Published: 26 Oct 2009

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

Small size Oracle database
(15gb to 100 gb)
(from 9.2.0.6 to 10.2.0.4) on AIX 5.x
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.

Dig Deeper on Oracle database design and architecture

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

How AI data privacy can help your enterprise

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

SearchBusinessAnalytics

Logi Analytics keeps focus on embedded app development

Kevin Greene is the new CEO of Logi Analytics after previously serving as the vendor's COO. In an interview, Greene discusses his...

Data literacy skills key to cost savings, revenue growth

As organizations develop data-driven cultures, they need to implement programs to teach employees how to work with and make ...

Yellowfin 9.3 features embedded app development upgrades

New application programming interfaces to help app designers build embedded BI apps are among more than 25 new features in the ...

SearchSAP

Decide on SAP S/4HANA Cloud: Single-tenant vs. multi-tenant edition

Understanding the benefits and limitations of S/4HANA Cloud versions is essential to making the right choice. Here are some ...

How 2 S/4HANA projects wrapped up remotely due to COVID-19

Here's how two SAP S/4HANA migration projects by De Nora Group and Vistaprint were completed on time after the COVID-19 crisis ...

Wookey returns to SAP to head Intelligent Spend unit

Industry veteran John Wookey is back at SAP to run the newly formed SAP Intelligent Spend and Business Network as SAP Ariba ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways to implement AI in software development

Further advancements to AI make it a more appealing and useful option for enterprise software development. Here are three ways to...

5 helpful tips to reduce webpage load time, improve performance

Nobody wants to wait for a webpage to load. Follow these tips to reduce website load time and improve the user experience for a ...

Is Apache Tomcat the right Java application server for you?

What is the best application server? The answer depends on what an enterprise is looking for. Compare Apache Tomcat to these four...

SearchDataCenter

IBM cloud revenues climb as hardware continues to decline

IBM cloud revenues continue to increase as hardware sales drop, sharpening the company's strategy to focus on hybrid cloud.

Figure out the differences of asset management vs. CMDB

There is no shortage of software options for change management tools. Operational goals can help IT teams decide if ITAM or CMDB ...

IBM partners with HBCUs to promote quantum computing

IBM is partnering with a group of historically Black colleges and universities to set up a quantum computing center in hopes of ...

SearchContentManagement

Choosing the right collaboration suite for business

Collaboration suites are an essential component of remote work, enabling teamwork throughout a distributed enterprise. Decide ...

Acquia Drupal, Marketing Cloud get feature boosts

Acquia users get Drupal migration tools and marketing automation features built with technology from recent acquisitions as the ...

How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

SearchHRSoftware

Tensions over politics at work have HR on guard

Politics at work may hurt productivity and office harmony. One strategy for defusing a charged atmosphere may be to get employees...

Top 9 tech skills HR professionals need for success

Today's HR departments are increasingly reliant on a range of technologies. That means human resources professionals must get ...

As contingent employee hiring rises, HR gives it focus

The use of contingent employees is increasing, Gartner said, and with it an interest from HR departments for better control over ...

Dig Deeper on Oracle database design and architecture

Oracle Cloud

Simple steps to follow for an Oracle 12c upgrade

Ten reasons to do an Oracle database upgrade

What are the complications of running Oracle on AWS?

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.