By
Published: 30 Aug 2005
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
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information?
Continue Reading
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space?
Continue Reading