This Content Component encountered an error

Oracle on Linux tips, tutorials and expert advice

Installing and upgrading Oracle on Linux <<previous|next>> :Transportable tablespaces for Oracle on Linux upgrade

Upgrading Oracle 9.2 to 10gR2 on Solaris 10

Upgrading Oracle 9.2 to 10gR2 on Solaris 10

By  Maria Anderson, Production DBA, Autodesk

SearchOracle.com

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.

02 May 2007