Oracle on Linux tips, tutorials and expert advice

Migrating Oracle data on Linux <<previous|next>> :Replication from Oracle to MySQL

Oracle database backup and recovery

Migrating database from Solaris to Linux

Migrating database from Solaris to Linux

By  Brian Peasland, Database Administrator, SGT, Inc.

What is the procedure to be followed to migrate a database from a Solaris machine to Red Hat Linux 9? (The size of the database is 20 GB.)
You have two options, Oracle's export/import utilities and Transportable Tablespaces (TTS). For TTS, you must be running Oracle 10g on both servers since you are going from one OS to another OS. TTS does not support cross-OS transfers prior to 10g. But I would probably use export/import since the database is not that big. On the Solaris server, perform a full export. Then create your database on the Red Hat platform. FTP the dump file to the new server (in BINARY mode). Finally, perform a full import into your new database.

12 Feb 2007