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

Migrating database from Solaris to Linux

What is the procedure to migrate an Oracle database from a Solaris machine to Red Hat Linux 9?

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.
This was last published in February 2007

Dig Deeper on Oracle database backup and recovery

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.