RE: any tips on migrating from 7.3.4 to 8.1.7

Sebastian:

    I would definitely make sure that sufficient backups of both Oracle Homes and databases are taken before anything occurs. I would also start with the 8.1.5 database, converting it to 8.1.7. This process is straight forward and does not require a significant amount of work. As far as the 7.3.4 database, the migration assistant can be used to solve most of the migration tasks that must be performed. Additional tasks may be necessary depending on the size of the database, etc. If you are trying to convert into a single database, be careful not to wipe out any data from either environment. If this is the case, then convert to a single database and migrate to 9.0.2.

    I would also convert to a single Oracle Listener for both databases, using 8.1.7 and then finally 9.2. Hope this helps.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Thursday, September 05, 2002 11:59 AM
To:	Multiple recipients of list ORACLE-L
Subject:	any tips on migrating from 7.3.4 to 8.1.7

> Hello All,
>
> I am currently involved in a migration project which involves combining
> two disparate databases into a single Oracle Engine. One of the databases
> currently lives on Oracle 7.3.4 and the other is 8.1.5 (both desupported
> by Oracle). My task is to upgrade to a single instance of 8.1.7 (and
> eventually 9.2.x). Are there any road bumps that I should be aware of
> before undertaking this endeavor?
>
> Any tricks/tips are appreciated.
>
> Thank you in advance
>
> Sebastian DiFelice
> DBA/Database Analyst
> Thomson
> Intelligence Data
> (617)856-1587
> www.intelligencedata.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DiFelice, Sebastian
  INET: sebastian.difelice_at_tfn.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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.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).