Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Migrating from Oracle 7.3.4.4 to 8.x

Migrating from Oracle 7.3.4.4 to 8.x

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Fri, 17 Dec 1999 10:28:28 -0500
Message-ID: <385A569C.42837F64@Unforgettable.com>


I will soon be given the opportunity to migrate some databases from Oracle 7.3.4.0 on a UW 2.1.2 platform to Oracle 8.x on SunOS5.6/Solaris 2.6.

Are there any hidden "gotchas" that I should be aware of? I plan to build the databases using the same scripts that I used to build the 7.3.4.0. We have no immediate plans to use any specific 8.x features above and beyond those that are available in 7.3.4 - however, are there any that I should probably consider in constructing the database?

Once the database is read I just plan to do a full export of the old database and then perform the import user-by-user.

Currently the application is using MTS because of the large number of users (cira 80). I've tried to follow some of the discussions about MTS on these groups and from what I can surmise it may not be necessary to use MTS under Oracle 8. Is this true? Is there any negative aspects about setting up MTS anyhow?

What about sqlnet issues. I understand that with Oracle 8 I'll be using Net8. Is there any major differences in how the listner.ora is set up? What about tnsnames.ora?

Are there any major tuning issues that change dramatically?

I do plan to get a book on Oracle 8 DBA and Oracle 8 Tuning before I actually start the work, but I also think it is worthwhile to get imput from those who are already using Oracle 8. Received on Fri Dec 17 1999 - 09:28:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US