Home » RDBMS Server » Server Utilities » error while impdb (11.2.0, Windows Server 2008)
error while impdb [message #600649] Sun, 10 November 2013 14:49 Go to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Can someone please advise on how to get past this error ?

It is happening when I doing and impdb into a target database that I created.


I am thinking it might have something to do with tablespaces that already exist such as sysaux,system,example,etc... Thank you in advance for your cooperation.

parameter file runfile.txt contains
full=y 
directory=IMP_DIR 
dumpfile=SOURCEDB.102813.1905.exp 
logfile=impdblog2.log 


Import: Release 11.2.0.1.0 - Production on Sun Nov 10 14:59:17 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_04": system/********@target2 parfile=runfile.txt
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"SYSAUX"]
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLSetTextVar in routine kuxslSetParam:
LPX-314: an internal failure occurred

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8165

----- PL/SQL Call Stack -----
object line object
handle number name
000007FFF24FB050 18990 package body SYS.KUPW$WORKER
000007FFF24FB050 8192 package body SYS.KUPW$WORKER
000007FFF24FB050 15575 package body SYS.KUPW$WORKER
000007FFF24FB050 3945 package body SYS.KUPW$WORKER
000007FFF24FB050 8875 package body SYS.KUPW$WORKER
000007FFF24FB050 1649 package body SYS.KUPW$WORKER
000007FFFC961030 2 anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLESPACE:"SYSAUX"]
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLSetTextVar in routine kuxslSetParam:
LPX-314: an internal failure occurred

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8165

----- PL/SQL Call Stack -----
object line object
handle number name
000007FFF24FB050 18990 package body SYS.KUPW$WORKER
000007FFF24FB050 8192 package body SYS.KUPW$WORKER
000007FFF24FB050 15575 package body SYS.KUPW$WORKER
000007FFF24FB050 3945 package body SYS.KUPW$WORKER
000007FFF24FB050 8875 package body SYS.KUPW$WORKER
000007FFF24FB050 1649 package body SYS.KUPW$WORKER
000007FFFC961030 2 anonymous block

Job "SYSTEM"."SYS_IMPORT_FULL_04" stopped due to fatal error at 14:59:32
Re: error while impdb [message #600651 is a reply to message #600649] Sun, 10 November 2013 15:22 Go to previous messageGo to next message
John Watson
Messages: 4511
Registered: January 2010
Location: Global Village
Senior Member
I haven't seen an ORA-39126 before, so I put it into MOS. It is pretty clear that you need to upgrade your 11.2.0.1 to the latest patchset, 11.2.0.4. And if that doesn't fix it, raise a TAR.
Re: error while impdb [message #600738 is a reply to message #600651] Mon, 11 November 2013 17:32 Go to previous message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Actually my source is version 11.1.0 whereas my target is 11.2.0 so I doubt that it is a matter of missing a patch.

I was able to get by that error by removing full=y in my parameter file and added
TABLESPACES=TBS1,TBS2,TBS3,TBS4,...,TBS6

However only TBS1 was imported and there was no error reported for the remaining tablespaces.
I had to create the tablespaces and the users prior to running my impdp command. Please advise on the syntax of
TABLESPACES =
Previous Topic: import data in one tablespace
Next Topic: Sql Loader
Goto Forum:
  


Current Time: Thu Aug 28 08:16:12 CDT 2014

Total time taken to generate the page: 0.06666 seconds