Ask the Expert

Migrating Oracle9i database from Solaris to AIX

We have a 300 GB database running on Oracle9i release 2 on a Solaris platform. We want to migrate the database on IBM AIX server Oracle9i rel2 on a HACMP envoirment. Please guide me on the steps involved in doing this, the downtime required for the entire process, etc.

    Requires Free Membership to View

Since the database is being migrated from Solaris to AIX, you cannot physically copy the database to the new server. You can choose to use Oracle's export and import utilities. This depends on much downtime you can afford. You can also create a new database on the AIX server and use CTAS (create table as select) to bring over your tables. This requires some additional post-migration work on your part to re-create the indexes, constraints, default values, etc. Export/import will do most of this for you.

If you have the option to upgrade to Oracle 10gR2, another possibility is to upgrade your database on the Solaris server and use transportable tablespaces to create a new 10g database on the AIX server. Transportable tablespaces in 10gR2 allow you to migrate across operating systems. Be sure to review Oracle's certification matrix to ensure that you are installing Oracle database software on a certified platform.

This was first published in October 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: