There are three major changes happening here: one is an upgrade from Oracle 10g release 1 to release2, the next is a database move to a different platform, and the final change involves converting a single-instance database to RAC. First, you will want to decide how to upgrade your database to 10.2 as well as how to migrate it from Tru64 to Linux. A good reference is the Oracle Database 10g Release 2 (10.2) Upgrade Guide.
You have a couple of choices with respect to the upgrade:
- Perform an upgrade in place to 10.2 (as long as your operating system is at 5.1b) and then use the cross-platform transportable tablepaces feature to move the database to the Linux server.
- Create a new database on the Linux server and use export/import, or a database link to copy the data across.
Which option you choose will depend on how large your database is and how much of an outage you have to perform this migration. The upgrade guide discusses all of these options. For more information on transportable tablespaces, the Oracle Database 10g Release 2 (10.2) Administrator's Guide is a good reference.
After the upgrade is completed and the database has been migrated to the Linux server, then you need to consider how to configure RAC. A good place to start is to review the Oracle Database 10g Release 2 (10.2) for Linux - Oracle Clusterware and Oracle Real Application Clusters Installation Guide.
Carefully review the section titled "Converting to Oracle Real Application Clusters from Single-Instance Oracle Databases."
Another good reference is the Oracle Database 10g Release 2 (10.2) - Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.