Q
Manage Learn to apply best practices and optimize your operations.

Help with upgrading 9i to 10g

I am a new Oracle DBA, and I am working on an Orcale 9i database. 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?

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.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

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

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close