We are migrating and upgrading our Oracle 188.8.131.52 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 184.108.40.206 to 10gR2, as well as a detailed explanation of each option.
This was first published in May 2007