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.
