Re: Oracle 7 > Oracle 9 question

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 27 Apr 2004 05:02:55 +1000
Message-ID: <408d5cda$0$439$afc38c87@news.optusnet.com.au>

DjPaolo wrote:

> Hi,
>
> I have a Windows NT 4 Server (SP6a) with Oracle 7.3.4. There are 2
> things I would like to do:
>
> 1. Upgrade Win NT 4 to Win 2000 Server (servername will change too)
> 2. Install/upgrade Oracle 7.3.4 to Oracle 9I
>
> I thought of the following method to do this:
>
> - Delete Oracle 7.3.4
> - Upgrade NT to 2000
> - Install Oracle 9I
>
> Because this server has more financial applications it is not an
> option to install a clean installation of Windows 2000.
>
> Is this the right way for installation or can I expect some problems
> here?
>
> Thanks,
> Paolo

Two disasters in the making here, then.

First, although it is possible to upgrade NT4 to Win2K, it inevitably produces a complete mess when you do so... much more so, at any rate, than if you do a clean install of W2K.

Second, although it is indeed possible to migrate a 7.3.4 database direct to 9i, you haven't mentioned anything about actually doing so. Installing Oracle's software is not the same thing as migrating a database. You're going to have do rather a lot more research on what actually constitutes a database migration (http://tahiti.oracle.com is your friend).

Regards
HJR Received on Mon Apr 26 2004 - 14:02:55 CDT