Re: Upgrade to 8.1.6 - Advice sought from DBA's

Jane, this might not be practical, but you may be able to do a zero-downtime upgrade if you can beg, borrow, or steal another server-class machine, install 8.1.6/developer 6.1, and use create table from dblink, sql*plus "copy to", or export to named pipe then import from named pipe to copy the data. It will admitedly reduce performance on your production box, but the box will stay up.
HTH
Cliff

jane_ballard_at_my-deja.com wrote:

> 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 Wed Oct 25 2000 - 08:46:10 CDT