RE: Export 7.3.4 / Import 8.1.7?

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Mon, 21 Jan 2002 05:26:43 -0800
Message-ID: <F001.003F58E6.20020121041023@fatcity.com>

Trial
and error... <cough> <roll eyes upward>
<FONT face=Arial color=#0000ff

size=2> 
We
have migrated a couple of development databases.
<FONT face=Arial color=#0000ff

size=2> 
Things
to watch out for:
<FONT face=Arial color=#0000ff

size=2> 
Oracle
says replication-related objects are not handled "very well" by export / import.  We haven't encountered any problems in that regard, but all the snapshots had been turned off before the full export.
<FONT face=Arial color=#0000ff

size=2> 
SYS
and SYSTEM objects are not included in the full export, so any public synonyms, anything referring to objects stored in there will be invalid or point to
<Unknown> objects.
<FONT face=Arial color=#0000ff

size=2> 
If you
have users with objects stored in the SYSTEM schema, kiss them bye bye.  Ironically we noticed that the default accounts (for the demo db) in one 7.3.4. database were stored in SYSTEM.  We don't need those accounts so we removed them.
<FONT face=Arial color=#0000ff

size=2> 
The
Web Development Toolkit is included in 8.1.7 by default, it is placed in the SYS schema as a built-in package.  On our databases here only one user was using the toolkit, so he had installed it in his own schema.  Now we have two copies in the new database, with public synonyms pointing to the SYS schema.
<FONT face=Arial color=#0000ff

size=2> 

Ensure
you use the same character set for both.
<FONT face=Arial color=#0000ff

size=2> Double-check everything -- take an inventory of what is in your database, what is valid / invalid, etc. in the first database, then run that test again on the new one, and compare the results.
 
Ensure
you run the same /rdbms/admin scripts in the new database as you did in the old one, before you do your migration.
 
<FONT

color=#0000ff><FONT
size=2>Change Manager is a useful tool, to a degree -- with OEM 2.2. <SPAN

class=418115411-21012002>on NT there are bugs <SPAN 
class=418115411-21012002>/ shortcomings in it<SPAN 
class=418115411-21012002>.  My list so 

far:
<FONT

color=#0000ff>--
the JVM screen properties go beserk after a while, <SPAN class=418115411-21012002>but it doesn't appear to affect the final results.  Just leave the screen alone, and if you see an error save the reports BEFORE you acknowledge the
error.
<SPAN

class=418115411-21012002>--
it is extremely slow if you don't run it from the OEM console, 
<FONT

size=2>--
it doesn't verify whether packages <SPAN class=418115411-21012002>have body text in them,
<SPAN

class=418115411-21012002><FONT
size=2>-- it does not log constraint name changes, esp. SYS_C####
names
<FONT

color=#0000ff>-- I am not sure,
I think it doesn't log the number of constraints per table either.
<FONT

color=#0000ff><SPAN
class=418115411-21012002> 
<FONT

color=#0000ff>One amazing thing is
that some objects that were invalid in the old database are valid in the new one.  Hopefully these old objects were invalid only because someone had altered a parent
object...
<FONT

color=#0000ff><SPAN
class=418115411-21012002> 
<FONT

color=#0000ff>They tightened up the
code in 8i, some of the shortcuts that were used in the older version by developers will result in invalid objects in the new version.
<FONT

color=#0000ff><SPAN
class=418115411-21012002> 
<FONT

color=#0000ff>8i doesn't prevent
people from writing code that doesn't explicitly specify the schema.
<FONT

color=#0000ff><SPAN
class=418115411-21012002> 
<FONT

color=#0000ff>run utlrp.sql from
/rdbms/admin before you do your
comparisons.
<FONT

color=#0000ff><SPAN
class=418115411-21012002> 
<SPAN

class=418115411-21012002><FONT
size=2>If others know of other shotcomings, or ideas, please let me know.
Regards, <FONT face=Arial color=#000000 size=1>Patrice Boivin Systems
Analyst <FONT face=Arial
color=#000000 size=1>(Oracle Certified DBA) Systems Admin & Operations
| Admin. et Exploit. des systèmes <FONT face="Courier New" color=#000000 size=1>Technology
Services        | Services
technologiques <FONT face="Courier New" color=#000000 size=1>Informatics Branch         |
Direction de l'informatique <FONT face="Courier New" color=#000000 size=1>Maritimes Region, DFO      | Région des Maritimes, MPO
<FONT face=Arial color=#000000

size=2>E-Mail: <FONT face=Arial
color=#0000ff size=2>boivinp_at_mar.dfo-mpo.gc.ca

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Arslan Dar   [mailto:arslandar_at_skm.org.pk]Sent: Monday, January 21, 2002 4:50   AMTo: Multiple recipients of list ORACLE-LSubject: RE:   Export 7.3.4 / Import 8.1.7?
  Hi smith !
  I haven't done it but in my opinion, there should be no   problem, but anyways, the best way to find out is to try it!!   

  Arslan Zaheer Dar <FONT
  size=2>arslandar_at_skm.org.pk Database
  Administrator Shaukat Khanum Memorial Cancer Hosptial   & Research Centre www.shaukatkhanum.org.pk   

  -----Original Message----- From:
  Smith, Ron L. [mailto:rlsmith_at_kmg.com]   Sent: Saturday, January 19, 2002 12:57 AM   To: Multiple recipients of list ORACLE-L <FONT   size=2>Subject: Export 7.3.4 / Import 8.1.7?   Can I do a full export from 7.3.4 and then do a full import   into 8.1.7?
  Ron Smith -- <FONT
  size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com"   target=_blank>http://www.orafaq.com --   Author: Smith, Ron L.  
  INET: rlsmith_at_kmg.com
  Fat City Network Services    -- (858)   538-5051  FAX: (858) 538-5051 San Diego,   California        -- Public Internet access   / Mailing Lists <FONT

  size=2>-------------------------------------------------------------------- 

  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). Received on Mon Jan 21 2002 - 07:26:43 CST