Re: Migrating from Oracle 7.3.4.4 to 8.x

Van Messner wrote:

> 
> 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.

Does the database assistant run on the server itself or is it a client tool that runs on a workstation and assumes that enterprise manager is set up?

.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
Received on Fri Dec 17 1999 - 15:00:52 CST