Q

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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close