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

Data hub vs. data lake: Deciphering the differences

Data lakes and data hubs are approaches to data management that are typically opposed. Here are the main differences between ...

Databricks Data Ingestion Network brings data to lakehouse

Databricks Ingest entered a public preview in a move by Databricks to enable a lakehouse that combines the best features of the ...

Lessons learned from Credit Karma GraphQL architecture

Credit Karma's vice president of engineering explains why and how the personal finance service is using the GraphQL data query ...

SearchBusinessAnalytics

Gartner's Sallam: Top BI vendors poised for next disruption

Leading analytics vendors appear poised to remain innovative as AI becomes pervasive in BI, Gartner's Rita Sallam explains in a ...

Gartner's Sallam: Top analytics platforms share common traits

In an interview, Gartner analyst Rita Sallam discusses what separates the top BI vendors from the rest as well as the trends that...

Birst analytics key to partnership between Infor, Snowflake

A new partnership between Infor and Snowflake will use BI tools from Birst, acquired by Infor in 2017, to enable users to build ...

SearchSAP

Understand SAP ECC vs. HANA vs. S/4HANA vs. R/3

SAP ECC, HANA, S/4HANA and R/3 are all valuable tools in the IT world, but it's easy to get them confused. Learn about their ...

5 tips for a successful S/4HANA Cloud implementation

Moving to S/4HANA public cloud can help you save on IT maintenance and simplify real-time analysis. Here's a look at what you can...

Take care of data before SAP S/4HANA migration

In this Q&A, Rajesh Rengarethinam of ERP security vendor Appsian discusses why reviewing data security and business processes are...

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

Take advantage of these 5 benefits of server-side rendering

From performance improvements to browser compatibility, here are five reasons why you should use server-side rendering ...

5 tips to reduce webpage weight and improve user experience

A slow landing page makes a bad first impression for any potential website visitor. Here are five tips to improve the page and ...

CSS performance optimization in 5 easy steps

Here are five CSS performance tips to help you avoid website performance problems.

SearchDataCenter

5 considerations for proper mainframe decommissioning

As organizations decide to retire mainframe systems, admins should develop a plan that addresses application migration, program ...

A look at software-defined networking upgrade guidelines

SDN brings the benefit of a mostly software-based update process. However, admins still must consider which updates are necessary...

Plan for a successful ITIL implementation

Corporate buy-in and training are essential for organizations that decide to adopt the ITIL framework. Admins should also help ...

SearchContentManagement

Contentful App Framework first major release under new CEO

Contentful CEO Steve Sloan, who joined the company in November after leaving Twilio, discusses the release of App Framework, a ...

Adobe Acrobat DC integrates PDF tools inside Google Drive

With new Google Drive integration, Adobe embeds free features for commenting and annotating PDFs inside Google Docs. Acrobat ...

4 benefits of business process automation

Companies are automating business processes to improve workflows and use technology effectively. Some benefits of BPA include ...

SearchHRSoftware

Coronavirus gets attention on Workday earnings call

The coronavirus is having an impact on Workday, prompting cancellation of a sales meeting in Orlando and placing a greater ...

Cornerstone is building learning management's Netflix

Cornerstone's acquisition of Saba Software for $1.4 billion takes out a learning management competitor and gives it a boost of ...

15 essential employee engagement survey questions

Crafting survey questions that uncover employee engagement issues is challenging. Here are some key questions and a guide to how ...

Dig Deeper on Oracle database design and architecture

Simple steps to follow for an Oracle 12c upgrade

Ten reasons to do an Oracle database upgrade

Perfect the Oracle RMAN duplicate 10g command

Oracle upgrades: Tips and trends

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.