Q

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

We are migrating and upgrading our Oracle 8.1.7.4 database on Solaris 8 (64-bit) to a completely new location. The OS will be Solaris 10. The database will be upgraded to 10.2.0.2. What would be the best approach to do that?

Hi Maria,

We are migrating and upgrading our Oracle 8.1.7.4 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 8.1.7.4 to 10gR2, as well as a detailed explanation of each option.

This was first published in May 2007

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close