Re: 9.2 32-bit to 10.2 64-bit Migration

Richard Evans wrote:
> Doing a quick search I haven't found this topic covered in the groups,
> which suprises me.
>
> We're moving not only to new hardware but to a new version of Oracle
> Enterprise Edition.
>
> We're going from a 9.2 32-bit installation on SunFire 280Rs to a 10.2
> 64-bit installation on SunFire V240s. The only thing they have in
> common is they are still SPARC Solaris. That's some comfort, I suppose
> ;-)
>
> Best practices??? Warnings???
>
> I'm assuming this will be difficult because of the 32->64bit migration.
> I'm also assuming Recovery Manager and Export/Import Utilities will
> not play very nice.
>
> If at all possible, I would like to migration my database users
> (dba_users view) and have them keep the same user_id. Worse comes to
> worse... I suppose I can build them in the order of their user_id but
> that means I will have to account for gaps (deleted users) as I do it.
> Yuck.
>
> I would prefer not to upgrade my 9.2 32-bit version to 10.2 64-bit
> version on the production databases. I want to keep them online and
> schedule a maintenance window, on a Saturday, and complete the
> migration to the new servers. Otherwise, I will have to have downtime
> for the migration of the old servers to 10.2 and for the migration to
> the new servers. It seems like a waste of effort to do both.
> Thoughts?
>
> Thanks,
> Richard

Use exp on your 9.2 database, create the 10.2 instance on the new server (create the tablespaces if you want some control over their location and configuration), then run imp on the new server. Three months ago I moved my database from 32 bit Oracle 8.1.7.3 to 64 bit Oracle 10.2.

Before switching to the newer Oracle version, take a look at "Cost-Based Oracle Fundamentals" by Jonathan Lewis. Appendix A of that book briefly reviews what to expect in cost based optimizer changes between versions.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Jul 13 2006 - 17:14:00 CDT