Lessons Learned: Upgrading to Oracle 10g

Part of the Lessons Learned series, this week's mini-lesson covers important questions to address when upgrading to Oracle 10g.

Welcome to SearchOracle.com's Lessons Learned series. Each week you will get a mini-lesson pertaining to a highly

specific database or E-Business Suite topic. The lessons are comprised of information already posted on the site in the form of expert responses and tips written by our panel of gurus. At the end of each month, you will be tested on what you've learned. E-mail us your specific lesson requests today.

Go to the Lessons Learned Library for previous lessons and quizzes.

  TABLE OF CONTENTS
   How much memory is needed for 10g?
   How long will it take to upgrade to 10g?
   Is it difficult to upgrade to 10g?
   What's the preferred way to upgrade from 9i to 10g?
   Can I migrate directly from 8i to 10g?

This week's featured experts:

 

Brian Peasland
Dan Norris

 

 

 

 

 


  How much memory is needed for 10g?
[ Return to Table of Contents ]

128 MB is not enough memory. I'd suggest at least 512 MB, maybe more if you are also running an X-Windows environment. The Oracle software takes about 2 GB of disk space. It can take more or less depending on the options you install. But the database itself can typically take up much more disk space.

Excerpted from Brian Peasland's "Skip installing 9i for 10g?"

 


 

  How long will it take to upgrade to 10g?
[ Return to Table of Contents ]

For Oracle clients, migration to 10g is easy. Oracle9i shops can migrate to 10g in less than an hour. (Yes, that's right -- less than an hour.)

The migration to 10g is most exciting for shops that are still using rule-based SQL optimization. When migrating to 10g, the Automatic Database Diagnostic Monitor and the SQLAdvisor utility quickly identifies sub-optimal SQL statements.

Excerpted from SearchOracle.com news writer Rob Westervelt's report with Don Burleson, "Getting a look at 10g."

 


  Is it difficult to upgrade to 10g?
[ Return to Table of Contents ]

It should be pretty easy if you use the Database Upgrade Assistant (DBUA). The DBUA handles all of the details for you.

Click for Brian Peasland's "Upgrading directly from 8i to 10g -- is it possible?"

 


  What's the preferred way to upgrade from 9i to 10g?
[ Return to Table of Contents ]

For a database upgrade from 9.2.0.4 to 10g, I would follow the upgrade procedures provided by Oracle's documentation in most cases. If the database required some physical reorganization, one could choose to utilize the online reorganization features or do an export and import to change the physical attributes of the database organization.

To upgrade 9iAS to OAS 10g, you'll need to follow the upgrade guide for your platform.

Click for Dan Norris' "Preferred way to upgrade to 10g."

 


 

  Can I migrate directly from 8i to 10g?
[ Return to Table of Contents ]

The answer depends on which version of Oracle8i you currently are running. If you are running Oracle 8.1.7, then you can upgrade directly to 10g. If you are running Oracle 8.1.5 or 8.1.6, then you must upgrade to either 8.1.7 or 9.0.1 or 9.2.0 before you can upgrade to 10g.

Excerpted from Brian Peasland's "Migrating directly from 8i to 10g."

 


NOTE: For more information on when and how to upgrade to Oracle10g, read the Q&A interview with Ken Jacobs, Oracle Corp.'s vice president of product strategy for server technologies and the man known as Dr. DBA.

Go to the Lessons Learned library for additional lessons and quizzes.


 

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close