Re: Migrating from Oracle 7.3.4.4 to 8.x

I've done several of these. I used the Oracle database assistant to create the new databases because it takes care of all the tnsnames.ora, sqlnet.ora, stopping and starting the listener and the necessary services etc. After creating each new database I modify it to have the tablespaces and storage I will need for the new versions of the old 7.3.4 databases. Note that no matter what you do with rollback in the actual database assiatnt you will get a 12M tablespace - you'll probably want to change that. Also, I'd give the system tablespace 200M more than what you're using in the 7.3.4 version. If you'll be running OEM 2.0.4 you'll want to set processes to 200 or 250 and maybe max_enabled_roles to 50 or 60. Then do an export and an import to bring the objects and data across. Done this way you can actually try everthing out on the new server while leaving the old one alone, do some testing to see how things work, then clean out the new server and do it again for real. No real gotchas for a DBA - just small stuff.

Van

Kenneth C Stahl <BlueSax_at_Unforgettable.com> wrote in message news:385A569C.42837F64_at_Unforgettable.com...
> I will soon be given the opportunity to migrate some databases from Oracle
> 7.3.4.0 on a UW 2.1.2 platform to Oracle 8.x on SunOS5.6/Solaris 2.6.
>
> Are there any hidden "gotchas" that I should be aware of? I plan to build
> the databases using the same scripts that I used to build the 7.3.4.0. We
> have no immediate plans to use any specific 8.x features above and beyond
> those that are available in 7.3.4 - however, are there any that I should
> probably consider in constructing the database?
>
> Once the database is read I just plan to do a full export of the old
> database and then perform the import user-by-user.
>
> Currently the application is using MTS because of the large number of
users
> (cira 80). I've tried to follow some of the discussions about MTS on these
> groups and from what I can surmise it may not be necessary to use MTS
under
> Oracle 8. Is this true? Is there any negative aspects about setting up MTS
> anyhow?
>
> What about sqlnet issues. I understand that with Oracle 8 I'll be using
> Net8. Is there any major differences in how the listner.ora is set up?
What
> about tnsnames.ora?
>
> Are there any major tuning issues that change dramatically?
>
> I do plan to get a book on Oracle 8 DBA and Oracle 8 Tuning before I
> actually start the work, but I also think it is worthwhile to get imput
> from those who are already using Oracle 8.
Received on Fri Dec 17 1999 - 14:57:45 CST