Re: Migrate from 8.1.6 to 8.1.7 or to 9i

"C Chang" <cschang_at_maxinter.net> wrote in message news:3CEC625B.31D5_at_maxinter.net...
> The Raven wrote:
> >
> > "C Chang" <cschang_at_maxinter.net> wrote in message
> > news:3CEB24FB.A46_at_maxinter.net...
> > > Never did this. ( our DBA left the company abruptly) I am looking the
> > > methods to migrate our 8.1.6 either to 8.1.7 or 9i . Which one is
> > > better? or easy? ( we already have 8.1.7 CDs) Need Help. any
> > > suggestion or direction is appreciated.
> >
> > Like you, I was nominated the Oracle expert in our company despite never
> > having dealt with it before.
> >
> > Just this week I upgraded 8.1.5 to 8.1.7. It was relatively pain free.
Just
> > insert the 8.1.7 CD on the server and step through the initial screens
it
> > will eventually prompt to do a migration to the latest version.
> >
> > Ensure it all migrates nicely (it should) and then restart Oracle etcl.
> > Check you can log in with SQL*PLUS.
> >
> > Do client upgrades for each client workstation and then test.
> >
> > If you are nervous about this, as I was, select the backup option and
make
> > sure you have plenty of disk space. Oh, tell management that you take no
> > responsibility if it screws up, it's their responsibility to have some
form
> > of DBA backup.
> >
> > The Raven
> Thanks Raven. Actually I am half tester and half web developer in this
> project. I even do not deal too much on SQL. You sound it is all that
> easy.

Easy perhaps, but nerve wracking because I'm trusting the software to get it right. If it screws up I'd be fundling to reinstall the backup :-)

> What I concern the most it the original configuration and the
> integrity of original Data. My current configuration include 5 phsical
> HD with 10 G of each. The Data are spreaded around all 4 ( D,E,F,G).
> Does the 8.1.7 installatio process will cover all those?

From memory, it will identify any databases (which should be visible to the core installation) and ask you which one to convert/migrate. As per most Ora cle stuff, once complete with that database it should loop back and allow to to select another until you have converted them all.

> I will look
> into the document anyway.

That I would recommend. In my case the database was only populated with my normal test sets of data so, I really had little to lose if the data went south. In your case it sounds like you are dealing with a quantity of live data, which is all the more reason to make a backup and do a bit more research before diving in.

> Thanks again.
> C Chang

Your welcome. Just remember I'm no expert, just someone who's interest ends with the database working properly for my app.

The Raven Received on Wed May 22 2002 - 22:56:00 CDT