Home » RDBMS Server » Server Utilities » datapump import error: ORA-39014: One or more workers have prematurely exited (merged)
datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286829] Mon, 10 December 2007 03:21 Go to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Hi all, I get the following error while imorting a dump by using datapump method.
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

Job "SYSTEM"."SYS_IMPORT_FULL_08" stopped due to fatal error at 14:13


Any help in this regard is appreciated.

Thanx in advance,

Wilson

Report message to a moderator

datapump import error [message #286831 is a reply to message #286829] Mon, 10 December 2007 03:31 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Hi all, I get the following error while imorting a dump by using datapump (impdp) method.


Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

Job "SYSTEM"."SYS_IMPORT_FULL_08" stopped due to fatal error at 14:13


Any help in this regard is appreciated.

Thanx in advance,

Wilson

Report message to a moderator

Re: ORA-39014: One or more workers have prematurely exited [message #286833 is a reply to message #286829] Mon, 10 December 2007 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See trace file generated by the process.
If none, retry.

Regards
Michel

Report message to a moderator

Re: datapump import error [message #286834 is a reply to message #286831] Mon, 10 December 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't multipost
2/ DataPump is a Server Utilities question.

Regards
Michel

Report message to a moderator

Re: datapump import error [message #286839 is a reply to message #286834] Mon, 10 December 2007 03:43 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
hi again,
there is no trace file generated. I have tried impdp many times. but the errors are same..
Regds,

Wilson

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286844 is a reply to message #286829] Mon, 10 December 2007 04:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
What was your import command? Did you invoke parallel parameter while import. I saw this error when one tried to import with parallel value more than one. Don't use parallel and try then.

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286845 is a reply to message #286829] Mon, 10 December 2007 04:22 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
You should also specify your version and OS while posting.

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286846 is a reply to message #286844] Mon, 10 December 2007 04:24 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Hi, I used following command.

>impdp system/xxxxxx directory=ORACLE_BACKUP_DIR dumpfile=dumpfile.dmp full=y logfile=logimp.log

I use 10G enterprise edition, RHEL4

Regards,

Wilson

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286850 is a reply to message #286829] Mon, 10 December 2007 04:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:

I use 10G enterprise edition

Not enough information, use

select * from v$version;

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286852 is a reply to message #286850] Mon, 10 December 2007 04:31 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Hi,
Here is the version:

Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Linux: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production


Regds,

Wilson

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #286853 is a reply to message #286829] Mon, 10 December 2007 04:38 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Don't use system user to import. Grant permission to other user to import and then try with that user. Hopefully error will go away.

Report message to a moderator

Re: datapump import error [message #286857 is a reply to message #286839] Mon, 10 December 2007 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

there is no trace file generated

Search once more, one a process aborst, it generates a trace file.

Regards
Michel

Report message to a moderator

Re: datapump import error [message #286872 is a reply to message #286857] Mon, 10 December 2007 05:39 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Hi Michael,
I got the trc. i theink it's mainly because of system problems rather than oracle.Here is the piece of the trc text.




E8533125:0001D11C 19 642 10444 12 ABORT TRANSACTION - xid: 0x0004.017.00000070
E8547A4E:0001D12C 19 642 10960 10
E855A55D:0001D14F 19 642 10254 19 KSBCIC: (USER) starting cic on opcode KSBCIRTP [21] with args (3 0 0)
540E6185:0000057E 20 0 10280 1 0x00000014
KSTDUMP: End of in-memory trace dump
Dump event group for level SESSION
TC Addr Evt#(b10) Action TR Addr Arm Life
B73AFAA4 28657 1 b73afb0c 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
B74901E0 22935 1 b7490248 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
B74900EC 10407 1 b7490154 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
B7420FD8 25475 1 b7490060 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
B7420EE4 10904 1 b7420f4c 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
B7540768 10150 1 b75407a8 0 0
TR Name TR level TR address TR arm TR life TR type
CONTEXT 1 0 -1 2 -1218445200
Dump event group for level SYSTEM
TC Addr Evt#(b10) Action TR Addr Arm Life
ssexhd: crashing the process...
Shadow_Core_Dump = partial



Thanks & regards,

Wilson

Report message to a moderator

Re: datapump import error [message #286900 is a reply to message #286872] Mon, 10 December 2007 06:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ksbcic routine is called to get CI lock.
There are several bugs with this lock although I don't know any with datapump but some with parallel processing.
The likelyhood of bug is greater if you are in RAC.
I think you have to raise a SR.

Regards
Michel

Report message to a moderator

Re: datapump import error [message #286904 is a reply to message #286900] Mon, 10 December 2007 07:00 Go to previous messageGo to next message
wilpais
Messages: 7
Registered: December 2007
Junior Member
Many thanks for your inputs..

Wilson

Report message to a moderator

Re: datapump import error [message #323250 is a reply to message #286834] Tue, 27 May 2008 22:48 Go to previous messageGo to next message
grrus
Messages: 2
Registered: May 2008
Junior Member
Hi,
problem beside me:
when working the command expdp , appears message:

...
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYS"."SYS_EXPORT_FULL_05" stopped due to fatal error at 02:03:38
ORA-39014: One or more workers have prematurely exited.

As be?
Help.

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #323255 is a reply to message #286829] Tue, 27 May 2008 23:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
With heading this topic mismatched. Your error is expdp and heading says impdp. Anyways, what is inside your trace file? Are you in RAC environment? Are you using parallel parameter? How you specified dumpfile parameter?

Report message to a moderator

Re: datapump import error: ORA-39014: One or more workers have prematurely exited (merged) [message #323305 is a reply to message #323255] Wed, 28 May 2008 02:43 Go to previous message
grrus
Messages: 2
Registered: May 2008
Junior Member
Arju wrote on Tue, 27 May 2008 23:08
With heading this topic mismatched. Your error is expdp and heading says impdp. Anyways, what is inside your trace file? Are you in RAC environment? Are you using parallel parameter? How you specified dumpfile parameter?


I know that subject does not coincide.
the contents of the trace(fdb_dw01_3788.trc):
....
....
....
KCBS: nbseg[18] is 93
KCBS: nbseg[19] is 93
KCBS: Act cnt = 1054
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
22935 trace name CONTEXT level 1, forever
Dump event group for SYSTEM
DYNAMICALLY MODIFIED PARAMETERS:
optimizer_mode = RULE

________________________________
I exactly can not say - RAC.
No, I do not use parallel processes.
Command:
expdp "'sys/sys_fdb as sysdba'" directory=DMP_DIR dumpfile=ORENDB.DMP logfile=ORENDB.LOG full=y
C:\PROGRA~1\WinRAR\WinRAR.exe a -agYY-MM-DD -av- -ep1 -k -m5 -md4096 -o+ -r -rr -s- -y -dh F:\BACKCOPY\ORENDB\.rar F:\BACKCOPY\BIN\ORENDB.DMP
DEL F:\BACKCOPY\BIN\ORENDB.DMP

like all.
there is offers?

Report message to a moderator

Previous Topic: Counter while loading via SQL Loader
Next Topic: EXPORT import error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 05:40:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.