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