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

Home -> Community -> Mailing Lists -> Oracle-L -> If it smells like a duck and waddles like a duck......Core Dump d

If it smells like a duck and waddles like a duck......Core Dump d

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 12 Dec 2000 09:46:41 -0500
Message-Id: <10708.124317@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0644A.56DAA0E0
Content-Type: text/plain;

        charset="iso-8859-1"

Jay

<gasp on> Do you mean you could not import from 734 to 8i? <gasp off>
Maybe you need another round of assertions that it works? ;->

Seriously, if you use the 8i exp binaries to pull the data from the 7x dbms, you'll be OK. You may not have this option.

In that case, piggyback the data through the 8.0 dbms, using the 734 exp into 8.0, then the 8i exp binaries.

You'll be fine!

Ross
-----Original Message-----
From: Jay Hostetter [mailto:jhostetter_at_decommunications.com] Sent: Tuesday, December 12, 2000 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Core Dump during Import on 8.1.6 (related to duck pecking)

  Some consultants have arrived with an export file from a 7.3.4 database. We must import this file into an 8.1.6.2.0 database (identical to the scenario that Dennis Taylor posted). Every time I import this file, I get a "Memory Fault (coredump)" error. There is no trace file, no alert log entry, just a core file.
  I am doing a full import. I have tried creating the schema owner and importing using TOUSER, but I still get the coredump. I have checked kernel parameters (this is a new system). I have relinked Oracle. I have increased the SGA and tablespaces, but to no avail. We installed 8.0.5 on the same machine, and imported the file with no problem. We exported it from 8.0.5 and tried the full import into 8.1.6, but we still get the coredump.
  I did manage to import a different export file that the consultants brought with them (from 8.0.5) into a seperated 8.1.6 database.   I have logged a TAR, but thought I would run it by the real experts for some suggestions.
  This is a new install of 8.1.6, patched to 8.1.6.2 on a cluster running Tru64 version 5.1.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.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).

------_=_NextPart_001_01C0644A.56DAA0E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>If it smells like a duck and waddles like a duck......Core Dump =
during Import on 8.1.6 </TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Jay</FONT>
</P>

<P><FONT SIZE=3D2>&lt;gasp on&gt; Do you mean you could not import from =
734 to 8i? &lt;gasp off&gt;</FONT>
<BR><FONT SIZE=3D2>Maybe you need another round of assertions that it =
works? ;-&gt; </FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Seriously, if you use the 8i exp binaries to pull the =
data</FONT>
<BR><FONT SIZE=3D2>from the 7x dbms, you'll be OK. You may not have =
this option.</FONT>
</P>

<P><FONT SIZE=3D2>In that case, piggyback the data through the 8.0 =
dbms, using</FONT>
<BR><FONT SIZE=3D2>the 734 exp into 8.0, then the 8i exp binaries. =
</FONT>
</P>

<P><FONT SIZE=3D2>You'll be fine!</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Ross</FONT>
<BR><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jay Hostetter [<A =
HREF=3D"mailto:jhostetter_at_decommunications.com">mailto:jhostetter_at_decomm= unications.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, December 12, 2000 8:51 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Core Dump during Import on 8.1.6 (related =
to duck pecking)</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&nbsp; Some consultants have arrived with an export =
file from a 7.3.4 database.&nbsp; We must import this file into an = 8.1.6.2.0 database (identical to the scenario that Dennis Taylor = posted).&nbsp; Every time I import this file, I get a &quot;Memory = Fault (coredump)&quot; error.&nbsp; There is no trace file, no alert = log entry, just a core file.</FONT></P>
<P><FONT SIZE=3D2>&nbsp; I am doing a full import.&nbsp; I have tried =
creating the schema owner and importing using TOUSER, but I still get = the coredump.&nbsp; I have checked kernel parameters (this is a new = system).&nbsp; I have relinked Oracle.&nbsp; I have increased the SGA = and tablespaces, but to no avail.&nbsp;&nbsp; We installed 8.0.5 on the = same machine, and imported the file with no problem.&nbsp; We exported = it from 8.0.5 and tried the full import into 8.1.6, but we still get = the coredump.</FONT></P>
<P><FONT SIZE=3D2>&nbsp; I did manage to import a different export file =
that the consultants brought with them (from 8.0.5) into a seperated = 8.1.6 database.</FONT></P>
<P><FONT SIZE=3D2>&nbsp; I have logged a TAR, but thought I would run =
it by the real experts for some suggestions.</FONT>
<BR><FONT SIZE=3D2>&nbsp; This is a new install of 8.1.6, patched to =
8.1.6.2 on a cluster running Tru64 version 5.1.</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Jay Hostetter</FONT>
<BR><FONT SIZE=3D2>Oracle DBA</FONT>
<BR><FONT SIZE=3D2>D. &amp; E. Communications</FONT>
<BR><FONT SIZE=3D2>Ephrata, PA&nbsp; USA</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Jay Hostetter</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: jhostetter_at_decommunications.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
Received on Tue Dec 12 2000 - 08:46:41 CST

Original text of this message

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