Ask the Expert

Upgrading Oracle 9.2 to 10gR2 on Solaris 10

We have Oracle E-Business Suite 11.5.10.2 on Oracle Database 9.2.0.6 on Solaris 9. We are planning to upgrade the DB to 10gR2 and move the complete environment onto a new powerful server having Solaris 10. What would be your suggestion about the path? Where to start the upgrade, OS or DB first? Thanks in advance for the help.

    Requires Free Membership to View

If you refer to Oracle's Certification Matrix you will see that both Oracle 9.2.0.6 and 10gR2 are certified and supported on the Solaris 10 operating system. This gives you some options in terms of whether you want to first upgrade the database or the operating system.

Since you are moving to completely new hardware, you can choose to migrate the 9.2 database to the new server and then upgrade it to 10gR2, or you could perform the upgrade at the same time as the migration.

Because this is an Oracle E-Business Suite database, I will assume that it is a large database and that export and import is not feasible. Review the Oracle Database 10g Release 2 (10.2) Upgrade Guide for options on how to migrate a database to 10gR2. I would also urge you to consult the required Oracle E-Business Suite documentation to ensure that whatever upgrade option you choose is supported.

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: