Upgrade to 8.1.6 - Advice sought from DBA's

Hello all,

     We are presently pursue a course to upgrade from oracle 8.0.5 to oracle 8.1.6.

Constraints on the upgrade.

     Live production server installed with oracle 8.0.5, developer 6.0
     4 oracle 8.0.5 instances.
     No standby server
     Archivelog mode on
     Backup could be done only for the data portion of the server
     from what the network guys tells me.

     Oracle tells me that I need to kill off oracle 8.0.5 and re-install
     oracle 8.1.6 and proceed with a fresh install.

     My concern is that if there is a problem... I will pay dearly
     for that...

     Question is:  Given the constraints... what is the best approach
     to this upgrade from 8.0.5 to 8.1.6.  One thought is to have
     multiple oracle homes on the same machine.

     eg.   install oracle 8.1.6
           install oracle developer 6.1
           export oracle 8.0.5 database
           import into oracle 8.1.6 database.

     Will this approach the best option to at least ensure the safety
     of the 8.0.5 database incase the 8.1.6 upgrade does not go well..

     Appreciate the advice.

Platform: Windows NT, service pack 4.
Database 8.0.5 for oracle
Upgrade 8.1.6 for oracle.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 23 2000 - 12:58:07 CDT