Q

Upgrading Oracle 9.2 to 10gR2 on Solaris 10

We have 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 server with Solaris 10. What would be your suggestion about the path?

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.

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

Dig deeper on Oracle E-Business Suite

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close