Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Help with upgrading 9i to 10g
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Help with upgrading 9i to 10g

Maria Anderson EXPERT RESPONSE FROM: Maria Anderson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 12 October 2005
I am a new Oracle DBA, and I am working on an Orcale 9i database. As part of the project I'm working on, I need to upgrade the 9i database to Oracle 10g. I have never done an upgrade before. Can you let me know how to do the upgrade? Do I need to download Oracle 10g software from the Oracle Web site? Do I need to install Oracle 10g before I upgrade? I am not aware of anything regarding upgrades; any help on this is much appreciated.

>
Yes, you will need to download Oracle 10g software in order to upgrade your database. This is basically the first step. You will then need to install the Oracle 10g software on the server where you will be performing the database upgrade.

There is an Oracle Database Upgrade Guide 10g Release 2 (10.2) available on Oracle Technology Network which details what you need to do to prepare for the upgrade, the actual upgrade process and any post-upgrade tasks that must be performed. The guide can be found here.

The one piece of advice I feel compelled to offer is to ensure that you not only test the upgrade process multiple times, but also ensure that all affected applications are tested by the application support team as well as business users.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database installation, upgrades and patches
Oracle's Java database continues push into embedded database market
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle delivers database fixes in Critical Patch Update
How to get the most out of Toad for Oracle 10
Coca-Cola Bottling swaps out Oracle for DB2
Oracle renews push into embedded open source software market
Oracle releases new database, says 11g upgrade will cut costs
Comparing servers for Oracle database 11g upgrades
Choosing the right server hardware is all about choosing the right software
The best of the Oracle 11g-ready servers

How to upgrade to Oracle 10g
Steps to migrate from Oracle 8.0.6 to Oracle 10g R2
Easiest way to migrate from Oracle 7i to Oracle 10g
How to migrate Oracle 10g to RAC cluster on Linux
Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2
Impact of Oracle 8i to Oracle 10g migration on scripts
Lessons Learned: Upgrading to Oracle 10g
Database too large for exp/imp migration
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g

Upgrading from Oracle 9i or later
How to migrate Oracle 10g to RAC cluster on Linux
Lessons Learned: Upgrading to Oracle 10g
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g
Faster way to migrate to 10g on Linux
Upgrading to Solaris 10 and Oracle 10g
Copying zipped files to 10g
Upgrading from 9.2.9.7 to 10g Express Edition
Migrate to 9.2.0.7 first or directly to 10g?

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts