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

Charles Hooper wrote:
> 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.

Additional recommendations:
* Pick up a copy of "Expert Oracle Database 10g Administration" by Sam Alapati. There are a couple small errors in the book, repeated a couple times, but this is by far the best and most thorough Oracle reference book that I have run across. The Oracle supplied manuals are good, as are the books by Tom Kyte (his Expert One-on-One Oracle book reads more like a novel than a reference book, but his second book does a better job at being a reference book - although it is directed at application DBAs and not people trying to install and configure Oracle databases).
* Pre-create the tablespaces to reduce the time that it takes to perform the import, and to reduce fragmentation at the operating system level - if you know that you will need a 25GB data file for a tablespace, create the data file at that size before the import. * If you perform a full export and a full import, your users from the old database will automatically be created in the new database. * By using two servers, you are able to practice the conversion several times to make certain that everything transfers properly - make certain that you create a log file when performing the export and the import. * Check the init.ora file, as some initialization parameters may need to be adjusted, removed, or added.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Jul 14 2006 - 06:16:04 CDT