Q
Problem solve Get help with specific problems with your technologies, process and projects.

Migrating from Solaris to Linux

We need to migrate our Oracle 9.2 database from Sun Solaris to Red Hat Linux. Our datafiles are stored on EMC's SAN. Do we have to use export and import even though we use a centralized storage?

We need to migrate our Oracle 9.2 database from Sun Solaris to Red Hat Linux. Our datafiles are stored on EMC's SAN. Do we have to use export and import even though we use a centralized storage? What are our options?
Yes, even though your database datafiles reside on centralized storage, you must still migrate the data because you are moving from one operating system platform to another. There are a number of ways to do this including export/import, CTAS (create table as select), replication, using Oracle's standby, etc. The most straightforward method is to use export/import but, depending on the size of your database, this may be time-consuming so you will need to allow enough time for this in your migration plan. Visit the Oracle Technology Network for many good articles on migrating to Linux: http://www.oracle.com/technology/tech/linux/index.html.

As well, if you attended IOUG Live! 2005 in May, you can download Richmond Shee's paper entitled "Pre-Oracle10g Data Migration to Linux Best Practices Using Export/Import" from the IOUG Web site. His paper and presentation are focused on tuning the import process so that the migration takes less time. It was a great presentation and his paper may prove quite helpful to you.

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