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

Order of Oracle migration and upgrade

I am getting ready to purchase a new server that will have the Windows 2003 OS and will need to migrate our Oracle 8i database as well as upgrage to 10g. Can you recommend which order I should perform the upgrade/migration?

I am getting ready to purchase a new server that will have the Windows 2003 OS and will need to migrate our Oracle 8i database as well as upgrage to 10g. Our current Oracle 8i database is running on Windows 2000/NT.

Can you recommend which order I should perform the upgrade/migration? We are a small office, but rely on the system so I would like to do all of the testing on the new machine before putting it into production, as you can imagine.

Also, what should I expect with respect to OS limitations if, for example, I migrate then upgrade? Does Oracle 8i have any problems running on Windows 2003 R2 2nd Ed? Or vice versa? Thank you!

I have no information about how large the database that you need to migrate is, but I'll assume it's not very large since you mention that you work in a small office environment. My approach to this migration would be to build the new server with Windows 2003, install the Oracle 10g software, apply all relevant CPU patches and then create an empty database with all the same tablespaces as your existing database. Be sure to take advantage of 10g features when you do this, such as using locally managed tablespaces and ASSM. I would then export the 8i database and import it into the newly created 10g database. Finally, I would encourage you to test this procedure several times before performing the actual cut-over. This option gives you an easy back-out solution if the migration fails (you simply need to start up the current 8i database) and also provides opportunities for testing prior to the production migration.

Dig Deeper on Oracle database export, import and migration

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