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

Top 7 data catalog use cases for enterprises

From data lake modernization to data democratization, there are many benefits to a data catalog. Experts talk about the top ways ...

Metamorphosis of Kafka Confluent event streaming technologies

Kafka Confluent event streaming tools allow data managers, analysts and developers to capture, process, store, access and analyze...

Isima emerges with bi(OS) converged data platform

Startup launches with the general availability of a converged platform that offers the promise of integrating multiple data ...

SearchBusinessAnalytics

Maine state government modernizes with Oracle Analytics

Hampered by siloed data and a data warehouse constructed 25 years ago, Maine's state government used tools from Oracle to break ...

TigerGraph adds cloud support, helps standardize graph coding

With democratization of graph databases in mind, TigerGraph recently added support for Microsoft Azure and took steps to help ...

Looker, Google unveil first collaboration since acquisition

Six months after Google's acquisition of Looker finally closed, the two unveiled their first collaboration during Google Cloud's ...

SearchSAP

SAP S/4HANA Cloud interest increasing

In this Q&A, Jan Gilg, president of SAP S/4HANA, discusses the current state of S/4HANA Cloud and how interest in the SaaS ...

Penn State graduates from legacy ERP to SAP S/4HANA

Penn State University recently completed a greenfield SAP S/4HANA implementation to replace an old COBOL-based system with a ...

ASUG/DSAG members like S/4HANA, but implementations still lag

S/4HANA is viewed positively by most SAP customers, according to a new survey of ASUG and DSAG members, but complexity of an S/...

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

Reduced cost, responsive apps from micro front-end architecture

Micro front-end development has grown in prominence though has not yet found its footing in the enterprise. Learn more about ...

How Quarkus fits into the Red Hat Runtimes formula

Faster microservices runtimes are the center of the excitement around Quarkus. Hear what Red Hat's James Falkner thinks about the...

3 ways a volunteer programmer can help in a pandemic

DevOps pros can help local and state agencies battle COVID-19. Here are three ways they can volunteer their time during a ...

SearchDataCenter

Big Blue ties its IBM Z Series tighter to hybrid clouds

In its ongoing mission to keep mainframes relevant, IBM rolled out a raft of hardware and software offerings that move it closer ...

A mechanical refrigeration system primer for admins

Mechanical cooling is a necessity to keep data centers efficient year-round. The system type you use depends on the refrigerant, ...

Red Hat Enterprise Linux 8.3 beta released

The latest beta of Red Hat Enterprise Linux has new System Roles for logging and environmental metrics, along with improvements ...

SearchContentManagement

Consider these electronic signature best practices

Some tips to think about when creating an e-signing process include cataloging documents requiring signatures, building user ...

What the CCPA means for content security

Now that the CCPA is in full effect, businesses must adjust their processes to better protect content. Organizations should ...

Microsoft Lists app replaces some SharePoint functionality

A new Microsoft application will be accessible via Teams. It features list templates, multiple lists views and out-of-box ...

SearchHRSoftware

4 ways HR and IT can collaborate on employee experience

The COVID-19 pandemic is causing new issues for workers across industries. Here's how HR and IT can collaborate on creating a ...

Digital adoption platforms can improve employee experience

DAPs guide employees through new systems and offer tips on workflow best practices. Turnover and onboarding challenges drove ...

The HR software buying team: Roles, responsibilities, tips

Choosing the right HR software requires teamwork and forethought. Here's a look at which people to include in the evaluation and ...

Dig Deeper on Oracle database design and architecture

How to manage Oracle database upgrades and annual releases

Oracle promises NetSuite performance gains at SuiteWorld

Ellison slates AWS Aurora as Oracle posts flat second quarter

Oracle Autonomous Database Cloud gets transaction processing

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.