Re: Oracle Upgrade from 8.0.5 to 8i

Harry Boswell wrote:

> Yes, I did this recently on my Solaris boxes. You'll need to make sure
> ORACLE_HOME is set correctly for each database. Either listener will work
> with both db versions; I would go ahead and use the 8i listener. Instead

The listener/Net8 changed slightly. If you use the 8.0.5 listener, you >might< run into a few situations tha are not compatible with the 8i features. IIRC, most of these have to do with LOB & Object & may not affect you.

In general, latest listener always seem to be downward compatible (for all DB versions supported at the time of Listener release.)

> of using the migration utility (it never finished when I tried it on a test
> database), you might just want to export the 8.0.5 db, recreate the database
> files, and import into the new 8i database.

I encourage backing up & exporting the 8.0.5 ... I've seen some smooth upgrades but I've also seen some cases where the only choice was the export route. (The latter was mainly botched 7.3-> 8.0 upgrades that 'sorta worked' and the DBA then wanted to go up to 8i ... )

While we're there - consider going right up to 9i to ensure you keep some support around.
/Hans Received on Thu Apr 03 2003 - 13:24:36 CST