### this has never been done or tested, it's just what *I* would try, so be
careful ... ###
- backup your 734 DB
- ensure you can downgrade from Solaris 2.7 to 2.6 ( backup your OS )
- prepare the migration of your 734 DB : migprep + mig steps ( see
migration guide + Metalink note 76460.1)
now your DB should be down.
- upgrade from Solaris 2.6 to 2.7
- install Oracle816
- set your env to Oracle8, and complete the migration
- send us feedback or champagne if it works .... ;-)
> ----------
> From: Cyril Thankappan[SMTP:cyril_thank_at_rediffmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, November 23, 2000 09:45
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: RE: 7.3.4 -> 8.1.6: Upgrade/Migrate? Or
> Install/Import
>
>
> Hi!
>
> Has any of you faced this problem and resolved it?
>
> The problem is as follows
>
> We have Oracle 7.3.4 on Intel Solaris 2.6,
> and we want to migrate to Oracle 8.1.6 which is
> supported only on Solaris 2.7
> and Oracle 7.3.4 is not supported on Solaris 2.7.
>
> Now problem is how do we do this without
> having to do an export/import.
>
> We would like to avoid export/import as this is
> a datawarehouse database with smallest table
> having 6 crore rows.
>
> Would be grateful for 'any' help offered!
>
> Thanks
> ------------- Original Message --------------
> ddorr.cs_at_clearstream.com wrote:
> To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> From:ddorr.cs_at_clearstream.com
> Date:Wed, 22 Nov 2000 02:35:24 -0800
> Subject:RE: RE: 7.3.4 -> 8.1.6: Upgrade/Migrate? Or Install/Import
>
> We migrate all our 734 databases to 816 on solaris without any problem
> using
> the following procedure :
>
> install oracle816
> migrate using migprep & mig tools ( not the migration assistant ) : the
> note
> on Metalink describes the process very well
> restart in Oracle8 and voila ...
>
> > ----------
> > From: Penny Keefe[SMTP:Penny.Keefe_at_auc.trw.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Tuesday, November 21, 2000 22:31
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: RE: 7.3.4 -> 8.1.6: Upgrade/Migrate? Or Install/Import
> >
> > Robert,
> > In my limited experience, it is better to install the new version then
> > import the database. When we upgraded from 7.3.4 to 8.1.5 and then
> > migrated the data, we got error ORA 00406(compatable parameter needs to
> > be 8.1.0.0.0 or greater). The choices to resolve this problem was to
> > rebuild each table or try the install/import method. The install/import
>
> > method worked much better!!!!
> >
> > Also check the install guide for 8.1.6, I don't know what the version
> > requirement are but I had problems installing 8.1.5 on Solaris 2.6.
> > After we upgraded to Solaris 2.7 the problems were gone.
> >
> > Hope this is helpful
> > Penny
> >
> >
> > ----- Original Message -----
> > Date: Monday, November 20, 2000 2:25 pm
> >
> > > Well, I didn't get nearly as much feedback on this as I would have
> > > liked to
> > > have, and thought I'd toss it back out there again to see if I
> > > could get
> > > anything else. Doesn't anyone have any opinions on this?
> > >
> > > -::YEX::-
> > >
> > > -----Original Message-----
> > > Sent: Thursday, November 16, 2000 9:55 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > We are currently still running on Oracle 7.3.4.5.0 on Solaris 2.6,
> > > and are
> > > planning to upgrade to Oracle 8.1.6, and possibly upgrading the OS
> > > to 2.7
> > > also in the process, sometime in the near future. I wanted to
> > > throw a
> > > feeler out to get people's opinion on what would be the easiest, most
> > > painless way to accomplish this. I've read the installation and
> > > migrationmanuals, and it doesn't sound overly difficult to do, but
> > > I know that a lot
> > > of you out there have a lot more experience with this than we do,
> > > and was
> > > wondering what would be best for us between the following two choices:
> > >
> > > Option 1) Migrate the database by using the Oracle Migration tool
> > > (of course
> > > backing everything up first).
> > >
> > > Option 2) Backup server, Export full database, remove Oracle from
> > > the system
> > > completely, do a clean install of Oracle 8.1.6, then import the
> > > data into
> > > the new database.
> > >
> > > Part of this project is going to include a re-organization of our
> > > tablespaces, as we now have a few additional hard drives to use,
> > > and would
> > > like to spread things out a little better to improve performance
> > > by reducing
> > > disk contention. That part of the project was why I thought that
> > > it might
> > > just be easier to go with Option 2 instead.
> > >
> > > Of course I am also open to any other options anybody might have
> > > as well.
> > > Any and all advice would be greatly appreciated, and thanks in
> > > advance.
> > > SSgt Robert D. Yexley
> > > Air Force Institute of Technology
> > > Applications Services Division (SCA)
> > > -- Oracle Database Programme-- Configuration Management Officer
> > > -- Microsoft Certified Professional
> > >
> > > * E-Mail: robert.yexley_at_afit.af.mil
> > > * Voice: DSN - 785-6565 x-4268
> > > Civ - (937) 255-6565 x-4268
> > > Fax: DSN - 986-7080
> > > Civ - (937) 656-7080
> > > * http://sc.afit.af.mil/sca
> > >
> > > <)))><
> > > _________________________
> > > "God who gave us life gave us liberty.
> > > Can the liberties of a nation be secure
> > > when we have removed a conviction
> > > that these liberties are a gift of God?
> > > Indeed I tremble for my country when
> > > I reflect that God is just, that his
> > > justice cannot sleep forever."
> > > - Thomas Jefferson, 3rd US President
> > > ______________________________
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Yexley Robert D SSgt AFIT/SCA
> > > INET: Robert.Yexley_at_afit.af.mil
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > -------------------------------------------------------------------
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Yexley Robert D SSgt AFIT/SCA
> > > INET: Robert.Yexley_at_afit.af.mil
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > -------------------------------------------------------------------
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Penny Keefe
> > INET: Penny.Keefe_at_auc.trw.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: ddorr.cs_at_clearstream.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
> Participate in crazy auctions at http://auctions.rediff.com/auctions/
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
Received on Thu Nov 23 2000 - 06:09:27 CST
