Help - Search - Members - Calendar
Full Version: expdp error
Oracle DBA Forums > Oracle > Oracle Forum
sandhya
Hi,
I executed this statement
expdp user/user directory=dmpdir dumpfile=user.dmp logfile=user.log

Job "USER"."SYS_EXPORT_TABLE_03" stopped due to fatal error at 17:51:07

Can anyone help me out in this error??
cromagnon
look at the logfile, there is certainly some more descriptive error or an ORA-* code or something.
HAL9000
"logfile=user.log"

This log file will tell you what the error is.
shabana
It may be because of lack of memory in shared pool, please read this link
http://arjudba.blogspot.com/2008/12/expdp-...-ora-04031.html
sandhya
Hi,
When i use expdp to export my chema, i get the following error message

Starting "AAA"."SYS_EXPORT_TABLE_02": aaa/******** directory=db_dump_bkp dumpfile=aaa.dmp logfile=aaa.log tables=% query="where rownum<1"
Job "AAA"."SYS_EXPORT_TABLE_02" stopped due to fatal error at 17:57:27

when i looked in the logfile, it gave the error message
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-04063: package body "SYS.KUPW$WORKER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPW$WORKER"


Then i looked in the alert log. There it showed the following message.
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=104, OS id=21671
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'AAA', 'KUPC$C_1_20090223154615', 'KUPC$S_1_20090223154615', 0);
kupprdp: worker process DW01 started with worker id=1, pid=105, OS id=22105
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'AAA');

Could someone help me on this??
Gon
QUOTE (sandhya @ Feb 23 2009, 02:19 PM) *
Hi,
When i use expdp to export my chema, i get the following error message

Starting "AAA"."SYS_EXPORT_TABLE_02": aaa/******** directory=db_dump_bkp dumpfile=aaa.dmp logfile=aaa.log tables=% query="where rownum<1"
Job "AAA"."SYS_EXPORT_TABLE_02" stopped due to fatal error at 17:57:27

when i looked in the logfile, it gave the error message
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-04063: package body "SYS.KUPW$WORKER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPW$WORKER"


Then i looked in the alert log. There it showed the following message.
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=104, OS id=21671
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'AAA', 'KUPC$C_1_20090223154615', 'KUPC$S_1_20090223154615', 0);
kupprdp: worker process DW01 started with worker id=1, pid=105, OS id=22105
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'AAA');

Could someone help me on this??

Sometimes I have found this on my environment. I avoid it excluding grants and statistics.
burleson
>> ORA-39006: internal error

Try setting aq_tm_processes=4

There are bug reports on this, check MetaLink:

http://metalink.orcale.com

See note 4511371.8
sandhya
I tried setting aq_tm_process to 4.. Still it did not work.. I have another database in the same server.. expdp is working there fine..

"Job "PROFILE"."SYS_EXPORT_TABLE_02" stopped due to fatal error at 12:12:22"

In alert log when i checked, this error was there :
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=167, OS id=2699
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_02', 'PROFILE', 'KUPC$C_1_20090331121129', 'KUPC$S_1_20090331121129', 0);


Could someone help me out as im stuck up with us for quite a long time??
dave
you need to call oracle support
lsrao
Hi,

please check the directory permissions. if the problem still exists, then drop the directory and recreate the directory.

regards
LSRao
dave
QUOTE (lsrao @ Jan 25 2010, 05:31 AM) *
Hi,

please check the directory permissions. if the problem still exists, then drop the directory and recreate the directory.

regards
LSRao


this is nearly a year old!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.