Ask the Expert

Upgrade Oracle 8 on Solaris 8 to 10g on Solaris 10

Hi Maria,

We are migrating and upgrading our Oracle 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 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.

    Requires Free Membership to View

The base installation should be Oracle 10gR2 ( 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 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 to 10gR2, as well as a detailed explanation of each option.

This was first published in May 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: