Re: Upgrade horror stories/victories

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Nov 1999 19:56:00 -0000
Message-ID: <943300701.8301.3.nnrp-03.9e984b29@news.demon.co.uk>

I haven't had any problems yet with migration , although the ones I have done have all been Unix boxes, and I've always done the migration by hand (using migprep and mig).

Total time required:

Backup of database time + ca. 2 hours.

Fortunately I haven't had to migrate a system with replication going. It looks quite hairy if you have to upgrade different nodes at different times.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Andre Allen wrote in message ...
>I am looking for the opinions of anyone who has had the following
>experiences
>
>Upgrading from Oracle 7.3.4.2 --> 8i
>Migrating from Oracle on Windows NT --> Some UNIX Flavor
>
>My company has high transaction IVR system that is attached to an Oracle
>RDBMS (7.3.4) which is running on a DEC AlphaServer 2100a with Windows NT
>4.0 SP6.
>
>7.3 --> 8i: Ive heard that Exp/Imp is the safest way to go, but you've got
>to have plenty of time, (which I do not have) and disk(Which is easy). The
>MIG80/Oracle Migration Assistant utility is fast, but can be known to crash
>and burn, which leaves you to restore the backups that you should have made
>prior to the upgrade.
>
>
Received on Mon Nov 22 1999 - 13:56:00 CST