Re: Migrating 8i database to 9i

That's true, actually. I forgot about that "minor" detail when doing the original reply, so it's probably/definitely going to include export and import.

But if it was me, and given Don's comments about the lack of space on his disk, I think I'd upgrade the database in situ, so that I could then take advantage of the FILESIZE limits in the 8i & 9i versions of export. A couple of exports and ftp's later, the data could be moved gradually over to the new machine (with it's separate 9i installation) without overstressing the original machine's hard disks.

So the migration utility etc. isn't a complete loss for him just yet.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message
news:a7a79g$r4c$1_at_coco.singnet.com.sg...


>

> If you are migrating from HPUX to Linux,

> Export-Import is the only option you can use

> to "migrate" from 8i to 9i.

>

> Hemant K Chitale

>

> "Don Seiler" <don.seiler_at_cellcom.com> wrote in message

> news:d9bd959f.0203200611.4f4d117_at_posting.google.com...

> > Yes I downloaded 9i and was reading the documentation.  Seems like

> > they have it all laid out for me in terms of migrating from 7 to 9i.

> > Being able to export/import would be nice, but this database is QUITE

> > large, so there is not only concern of time, but of space.  I don't

> > have enough disk to hold to concurrent copies of our database.

> >

> > I will probably be doing a cold backup and then using the migration

> > tools.

> >

> > Thanks,

> > Don.

> >

> > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message

> news:<a77vuj$1or$1_at_lust.ihug.co.nz>...

> > > Yup.  Migration is very well documented in all Oracle versions.

There's


> a

> > > migration executable which you run to generate a special sort of

control


> > > file, but you have to do a fair bit of manual manipulation of

> environment

> > > variables yourself, at precisely the right time (the doco lays it all

> out,

> > > step by step).  You are also responsible for things like copying your

> own

> > > init.ora, password files etc.  And you have to edit your own init.ora

to


> > > remove any de-supported parameters. You then have to issue a SQL

command


> to

> > > do the actual conversion, followed by a resetlogs.  You then have to

do


> some

> > > tidying up (a user account gets dropped, for example).  And then you

> have to

> > > run a fistful of sql scripts, but the precise ones you need to run

> depends

> > > entirely on what special features of the database you are using

already,


> > > what ones you intend to use, and what specific version you are

migrating


> > > from.  It is all spelled out very clearly.

> > >

> > > There are alternatives.  Installing 9i, the installation usually

detects


> > > existing earlier-version databases, and proposes to migrate them

> > > automatically.  Never tried it myself, and wouldn't know how reliable

it


> is.

> > >

> > > Both methods are 'in-place' migrations, meaning that the database is

out


> of

> > > action for the duration, and if anything goes wrong, you could be in

> deep

> > > doo-doo.  Hence the doco's stern warning to backup before you start!

A


> lot

> > > of people therefore prefer simply to install 9i, create a fresh (and

> empty)

> > > database manually, and then use boring old export (version 7) and

import


> > > (version 9i) to transfer the data.  The 7 database is still there to

> fall

> > > back to if anything goes pear-shaped, and doesn't have to be shutdown

> for

> > > the duration.  On the other hand, exporting and importing a "large"

> database

> > > is going to take for ever, export/import are not the world's most

> reliable

> > > utilities, and an awful lot can go wrong.  So I never recommend that

> > > particular route myself.

> > >

> > > But it's horses and courses, as ever.

> > >

> > > Regards

> > > HJR

> > > --

> > > ----------------------------------------------

> > > Resources for Oracle: http://www.hjrdba.com

> > > ===============================

> > >

> > >

> > > "Don Seiler" <don.seiler_at_cellcom.com> wrote in message

> > > news:d9bd959f.0203190647.51ae3599_at_posting.google.com...

> > > > At the risk of getting similar treatment:

> > > >

> > > > I "need" to upgrade an Oracle 7.3.4 database (VERY large, if that

> > > > matters) to Oracle 9i.  This is further complicated by the desire to

> > > > migrate from HP-UX (on HP :p) to Linux (on x86).

> > > >

> > > > Shall I assume that necessary instructions for such a migration are

> > > > included with the Oracle 9i .gz collections?

> > > >

> > > > Don.

> > > >

> > > > vslabs_at_onwe.co.za (Billy Verreynne) wrote in message

> > >  news:<3c909cd0.114756092_at_news.saix.net>...

> > > > > "JK Nidhi" <jk_nidhi_at_hotmail.com> wrote:

> > > > >

> > > > > >Can someone suggest the best way to migrate an oracle 8i database

> to 9i

> > > > >

> > > > > Yes sir.  You start at Step 1.

> > > > >

> > > > > 1. RTFM.

>

>