| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating from Oracle 7.3.4.4 to 8.x
Kenneth C Stahl wrote:
>
> 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?
>
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
> .........................................................................
Runs as part of installer under Solaris - so being "at" the console - either actually being there, or telnet-ing, or xterm-ing or using something like VNC is needed..
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Sat Dec 18 1999 - 05:33:29 CST
 |
 |