Q

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.

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.
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

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close