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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
