Re: RE: 8.1.5 upgrade=?ISO-8859-1?Q? paths to 10.2.x?=

Thanks all for your valuable suggestions!

Since we are on Solaris 7 I can't have an Oracle 10.2 installation and benefit from transportable tablespaces.

I think I'll end up doing a user export (exp 8.1.5 -> pipe -> imp 10.2 via network) for the schemas containing data. This can easily be parallelised by running a few exports and imports simultaneously. I was surprised to find that in Metalink note 132904.1 it reads that fromuser/touser will work.

Additional things to take care of are

- sys grants
- other user accounts
- 32 to 64 conversion (the new empty database on AIX is 64 bit)

And as usual, test, test, test.

Cheers,

Martin

Am 16.10.2007 um Uhr haben Sie geschrieben:
>
> Would not call them "exotic", just a darn lot faster & less error
prone.
>
>
>
> ______________________________________________________________
> Dick Goulet / Capgemini
> North America P&C / East Business Unit
> Senior Oracle DBA / Hosting
> Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> 45 Bartlett St. / Marlborough, MA 01752
>
> Together: the Collaborative Business Experience
> ______________________________________________________________
>
> ________________________________
>
> From: LS Cheng [mailto:exriscer_at_gmail.com]
> Sent: Tuesday, October 16, 2007 2:36 PM
> To: Goulet, Dick
> Cc: zimsbait_at_gmail.com; development_at_the-playground.de;
> oracle-l_at_freelists.org
> Subject: Re: 8.1.5 upgrade paths to 10.2.x
>
>
>
> with a 60gb database I wouldnt mess around with the exotic ways...
>
>
>
>
>
>
>
> On 10/16/07, Goulet, Dick <richard.goulet_at_capgemini.com> wrote:
>
>
> Better idea, which I've done recently. Upgrade DB to 8.1.7 then to
> 10.2, approximate time 3 hours. Then use Transportable database to
move
>
> datafiles to AIX, convert them with RMAN & restart your db. This
entire
> process on HP-UX to AIX took 18 hours total for a 700GB database.
Would
> have been faster if we had paralleled things.
>
> ______________________________________________________________
> Dick Goulet / Capgemini
> North America P&C / East Business Unit
> Senior Oracle DBA / Hosting
> Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> 45 Bartlett St. / Marlborough, MA 01752
>
> Together: the Collaborative Business Experience
> ______________________________________________________________
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of z b
> Sent: Monday, October 15, 2007 3:53 PM
> To: development_at_the-playground.de
> Cc: oracle-l_at_freelists.org
> Subject: Re: 8.1.5 upgrade paths to 10.2.x
>
> To "parallelize" you could use limit the dump files to, say, 500MB
> dump files. (filesize parameter)
>
> Ftp the files and start the import while the export is still running.
>
> Of course - test a couple of times before actually scheduling. :)
>
>
> On 10/15/07, development_at_the-playground.de
> < development_at_the-playground.de <mailto:development_at_the-playground.de>
>
> wrote:
> > Hello group!
> >
> > I have got a tricky problem at hand - migrate an Oracle 8.1.5 on
> Solaris
> > 7 database to 10.2.0.x on AIX. The problem here is that I am not
> allowed
> > much downtime. Having started with Oracle 8i I am not too sure how
> that
> > can be done. Obviously to get from 8.1.5 I have to go to 8.1.7
first,
> a
> > direct update is supported which is good. I am thinking of a new
> Oracle
> > home on the same machine, copying the database and migrating it.
> >
> > From there on I don't see any other way than exp/imp using pipes for
> > faster processing. It is a bit of a mystery how I can keep the
> downtime
> > low, the database is some 60GB in size btw.
> >
> > Thanks for any input on this,
> >
> > Martin
> >
> >
> >
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> This message contains information that may be privileged or
confidential
> and is the property of the Capgemini Group. It is intended only for
the
> person to whom it is addressed. If you are not the intended recipient,
> you are not authorized to read, print, retain, copy, disseminate,
> distribute, or use this message or any part thereof. If you receive
this
> message in error, please notify the sender immediately and delete all
> copies of this message.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
>
> This message contains information that may be privileged or
confidential and is
> the property of the Capgemini Group. It is intended only for the
person to whom
> it is addressed. If you are not the intended recipient, you are not
authorized
> to read, print, retain, copy, disseminate, distribute, or use this
message or
> any part thereof. If you receive this message in error, please notify
the
> sender immediately and delete all copies of this message.
>
>

--
http://www.freelists.org/webpage/oracle-l