Actually, you don't even have a choice since 805 is not supported on W2K.
So you must upgrade Oracle first.
I agree with Ron that W2K should be a separate step. It's a whole can of
worms.
I've migrated 7 databases (using the data migration assistant) so far on NT4
and they worked fine. Make sure that you have lots of free space in the
System tablespace.
I've had one migration fail on me. Somehow 817 is detecting a phantom
datafile that once upon a time indeed existed in the 805 database. That
datafile was deleted a long time ago. So it looks like I have a corrupt data
dictionary.
Make sure that you check for BUG: 839342, corrupt dictionary objects.
Metalink has more information about that.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Ron Reidy" <rereidy_at_indra.com> wrote in message
news:3BD6ED9B.C6C94437_at_indra.com...
> Brek Noice wrote:
> >
> > I'm looking for anyone who can provide information about thier
> > successes, failures, and overall issues with a migration from Oracle
> > 8.0.5 to Oracle 8.1.7. My company is looking to do this within the
> > next week or so, and we need all the advice we can get. We are also
> > going to try to change our OS from Windows NT to W2K. Has anyone had
> > any issues with Oracle and W2K? Any information that you can provide
> > about your experiences is greatly appreciated!
> >
> > Thanks in advance,
> > Brek Noice
> > Support/Maintenance Programmer
> > Harman Management Corporation
> > Salt Lake City, Utah
> I think you are biting off too much at once. IME, an OS and RDBMS
> upgrade at the same time is a recipe for a disaster. My suggestion is
> to to the RDBMS upgrade first and make sure all is well before
> attempting to do the OS upgrade.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Wed Oct 24 2001 - 11:56:00 CDT
