| error while impdb [message #600649] |
Sun, 10 November 2013 14:49  |
jxh461
Messages: 185
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  |
John Watson
Messages: 8964
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 |
jxh461
Messages: 185
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 =
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
