Skip to Main Content
  • Questions
  • Error when import large data from 11.2.0.3 into 11.2.0.4 Oracle Exadata

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Isma.

Asked: July 11, 2016 - 3:46 am UTC

Last updated: July 11, 2016 - 7:00 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi,

We hit this and no clue how it suddenly happen.
Issue cronology as below (using Toad version 10.2, 10.5 and 11).

1) Export out from Exadata DB version 11.2.0.3 table A with 4million records - ended successfully.
2) Import into Exadata DB version 11.2.0.4 of table A - teminated with error as below.

Import: Release 11.2.0.3.0 - Production on Sun Jul 10 22:23:47 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.



Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining a

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by FRS139, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)

. importing FRS139's objects into FRS139C

. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_06"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_07"
0 rows imported

. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_08"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_09"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_10"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_11"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2011_12"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_01"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_02"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_03"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_04"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_05"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_06"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_07"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_08"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_09"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_10"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_11"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2012_12"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_01"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_02"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_03"
0 rows imported

. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_04"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_05"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_06"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_07"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_08"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_09"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_10"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_11"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2013_12"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_01"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_02"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_03"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_04"
0 rows imported

. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_05"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_06"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_07"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_08"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_09"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_10"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_11"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2014_12"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2015_01"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2015_02"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2015_03"
0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2015_04"

0 rows imported
. . importing partition "IFRS_MASTER_ACCOUNT_ARCHIVE":"DOWNLOAD_DATE_2015_05"
Imported 100,000 rows
Imported 200,000 rows
Imported 300,000 rows

IMP-00058: ORACLE error 3135 encountered
ORA-03135: connection lost contact
Process ID: 16569
Session ID: 67 Serial number: 669

IMP-00058: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
IMP-00000: Import terminated unsuccessfully

Appreciate if you can assist on this issue. TQvm.

and Connor said...

In the alert log and/or trace file directory there will probably be more information as to *why* the session crashed.

In any event, I'd be much more inclined to be using data pump (expdp and impdp) - it will most likely be faster and less likely to have esoteric errors like this.

Hope this helps.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.