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.

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.

This was last published in October 2009

Dig Deeper on Oracle database design and architecture

All
News
Get Started
Evaluate
Manage
Problem Solve

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

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Google takes a run at enterprise cloud data management

New Google Cloud boss Thomas Kurian is putting databases and data management at the forefront at Google. The vendor has forged ...

4 factors to consider in a Hadoop distributions comparison

Examine the key characteristics necessary to evaluate in a Hadoop distribution comparison, focusing on enterprise features, ...

Kafka at center of new event processing infrastructure

Events are as important as data in emerging applications underlying many e-commerce efforts. Streams of events tell a company ...

SearchBusinessAnalytics

How to integrate Power BI and SharePoint via embedded reports

Expert Brien Posey explains two methods for including Power BI reports on pages in SharePoint Online's cloud service: publishing ...

Data-rich organizations turn focus to ethical data mining

As data analytics have increasingly become a core component of organizations' strategies, concerns have arisen around how data is...

Cloud AutoML, BigQuery ML upgrades expand Google stake in ML

Google introduced a raft of updates to its cloud-based machine learning and AI products, including expanded capabilities for its ...

SearchSAP

SAP partner program promises to focus on customer happiness

SAP's partner program shifts from sales emphasis to customer happiness; to lead the efforts, SAP named Karl Fahrbach as the ...

Overview of SAP HANA features and how it's being used today

There has been a lot of hype around SAP HANA since it became available nearly a decade ago, but what is it exactly and what role ...

SAP executive board shuffle raises questions about its strategic direction

Some analysts believe SAP's recent executive changes mean the new leaders must prove their development credibility as the company...

SearchSQLServer

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But ...

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and ...

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the...

TheServerSide.com

Red Hat replaces Oracle as OpenJDK 8, OpenJDK 11 steward

Red Hat has taken control of two popular versions of the open source Java implementation, so developers can continue to build ...

JavaScript popularity drives TypeScript adoption among devs

More developers choose to work with JavaScript to build web, server-side and mobile applications, while TypeScript has quickly ...

Encrypted computing approaches practical app development

A new technology could make it easier to write apps that don't have to decrypt data and, therefore, improve security without a ...

SearchDataCenter

Build a comprehensive outline for your data center budget

Including all necessary data center expenses during budget planning can be daunting. IT managers can start with costs for ...

Open source virtualization expands VM hardware and OS options

Dive into open source virtualization software with VirtualBox, KVM or QEMU. Each offers customizable VM management capabilities ...

4 considerations for choosing a private cloud provider

Key features to look for from a private cloud provider include interoperability, scalability and how familiar admins are with the...

SearchContentManagement

Business objects are the future of content services platforms

The focus of enterprise content management must shift from a CSP-based approach to a business object services model in order to ...

5 unusual ways to use AI in content management

AI offers great opportunity for enhancing enterprise content management. Here are some more unusual use cases for AI that ...

Use data to create personalized content customers actually want

As customers demand authentic, personalized content, CX teams have turned to personalization engines. But without the right data,...

SearchHRSoftware

Diversity in hiring a key to eradicating AI bias

HR is turning to AI systems to help rank and sort job candidates. But the systems like these are mostly designed by men, who may ...

Technology can aid diversity and inclusion in HCM, with caveats

Vendors are increasingly building AI applications to be bias-free to address concerns around diversity and inclusion. The ...

As baby boomers exit, AR and VR tools help to capture their expertise

Demand for virtual and augmented reality tools is soaring, and the need to capture expertise from retiring baby boomers may be ...

Dig Deeper on Oracle database design and architecture

Related Q&A from Brian Peasland

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.