We are migrating and upgrading our Oracle 220.127.116.11 database (~220GB) currently on Solaris 8 (64-bit) to a completely new location. The OS will be Solaris 10 (SPARC, also 64-bit). The database will be upgraded to 10.2.0.2. The locations are far away from each other. What would be the best approach to do that? Also, what patches do we need (both database and OS)? I appreciate your answer a lot. My DBA experience is mostly on Windows.
The base installation should be Oracle 10gR2 (10.2.0.1.0) on the new Solaris 10 server. This can be downloaded from Oracle's Technology Network Web site. To determine which operating system patches are required prior to this installation, refer to the Oracle Database 10g Release 2 (10.2) Release Notes for Solaris Operating System (SPARC 64-Bit).
Additionally, you should read through the Oracle Database 10g Release 2 (10.2) Installation Guide for Solaris Operating System (SPARC 64-Bit). Chapter 2 (Preinstallation Tasks) documents both hardware and software requirements to successfully install Oracle 10gR2.
To be on the latest release, you will then want to download Oracle 10gR2 Patch Set 2 which is release 10.2.0.3. This patch is available via Metalink and the patch number is 5337014. Ensure that you download the correct patch for your operating system. The accompanying instructions will indicate whether you require any additional operating system patches prior to applying this patch set.
Finally, review the Oracle Database 10g Release 2 (10.2) Upgrade Guide. This guide provides several options for migrating your database from 18.104.22.168 to 10gR2, as well as a detailed explanation of each option.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
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
Can I use /var/opt/oracle/oratab to specify listener information?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.