Re: Oracle 8.0 Server Migration for Win NT 4.0

Hi Manfred,

I don't know why Migration Assistant did not run during installation in you environment. It is named Oracle Data Migration Assistant and is in Oracle for Windows NT group. You can run it after setup.

But I do not recommend you to use this assistant to migrate data. I tried Migration Assistant with the poor result. The problem is that this dummy
java program simply runs some scripts and does not show any error messages. My problem was with parameter checkpoint_process in my version 7.3.2 file initorcl.ora. It is obsolete in 8.0.3. Oracle 8 did not open database with this
parameter. Another problem that you can not do cold backups before critical points using assistant. If any problem occures you must start from the very beginning. So, I did not tried to run assistant again and simply recreated database in 8.0.3 and imported export file from 7.3.2.

The second database was migrated to Oracle 8 using Migration Utility. I read accurately Oracle8 Getting Started for Windows NT, Server Migration and Release Notes. I executed all steps from Oracle8 Getting Started for Windows NT one by one using Migration Utility MIG80.EXE. This approach works fine, but don't forget to upgrade your sql*net 7.3.3 from Oracle 8.0.3 installation. Migration Utility does not work without such an upgrade.

                                 Andrew Protasov

Armin Schuch <07142980027-0001_at_t-online.de> wrote in message <6an4c1$ldd$1_at_news01.btx.dtag.de>...
>We tried to install Oracle Server 8.03 on Windows NT 4.0 with
>server pack 3 on a computer where a n Oracle WGS 7.3.2.3 is
>running and we wanted to migrate (means using the existing
>database with the tablespaces, data, ...) to become the new
>database.
>In the manual (Oracle 8 Getting started for Windows NT) in chapter
>5 database co-existence and migration the data migration dialog
>box (An earlier version of the database was detected. Would you
>like to migrate to 8.0.3.0.0?) is shown, which should follow in
>the installation sequence after the dialog box where you can
>select oracle 8, oracle 8 client, custom installation.
>When we start our installation, the Data Migration Dialogbox is
>skipped and not displayed.
>What is going wrong with our setup?
>
>
>
>
>Yours Sincerely
>
>Manfred Tischendorf
>
Received on Thu Jan 29 1998 - 00:00:00 CST