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

Upgrading to Solaris 10 and Oracle 10g

Currently we are using Oracle 9i EE on Solaris 8 and it has been almost five years. Now we are planning to change the server to Solaris 10 and Oracle 10g SE. How do I migrate my data to the new server?

Currently we are using Oracle 9i EE on Solaris 8 and it has been almost five years. Now we are planning to change the server to Solaris 10 and Oracle 10g SE. How do I migrate my data to the new server?
It is unclear to me whether you are planning to upgrade the operating system and database in place, i.e., on the same server, or whether you are migrating to a new server. If you are upgrading both in place, Oracle9i and Oracle 10gR2 are supported on Solaris 10. This means you can first upgrade your database to 10gR2 and then your operating system to Solaris 10, or the other way around. I would caution against upgrading the database and operating system at the same time.

If you are planning to migrate to an entirely new server which will have Solaris 10 and Oracle 10gR2 (I would recommend this approach), then how you migrate your database will depend on the size of the database, as well as how long of an outage you have available. To review your options, refer to the Oracle Database 10g Release 2 (10.2) Upgrade Guide. This guide will provide you with prerequisite checks and information, as well as step-by-step information on how to perform the upgrade.

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