This content has been marked as final. Show 13 replies
expdp.exe system/<password>@srvdb01-girprtes FULL=Y DIRECTORY=DTPUMP DUMPFILE=SRVDB01-GIRPRTESDP.dmpwhat's -girprtes
Hello Anantha R,
SRVDB01: Is the name of the linux Server
GIRPRTES: Is the name of the Oracle Instance
Error 39006 shows:
39006, 00000, "internal error"
// *Cause: An unexpected error occurred while processing a Data Pump job.
// Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS
// will further describe the error.
// *Action: Contact Oracle Customer Support.
Can you please list the complete error that is reported. The other error will help in determining what the error really is.
Thanks for your feedback Dean Gagne.
This is the single error that appear.
Hi, I discover that the problem is when I try to do export Data Pump into a directory mounted, becuase if I change for other local directory the export Data Pump works fine.
And the export.log show this errors when I try to do this into a directory mounted:
ORA-39097: Data Pump job encountered unexpected error -31643
ORA-39065: unexpected master process exception in FILE
ORA-31643: unable to close dump file "/mnt/rman/expdp_VSEVOTES.dmp"
ORA-19510: failed to set size of 1 blocks for file "/mnt/rman/expdp_VSEVOTES.dmp" (blocksize=4096)
ORA-27045: unable to close the file
Linux-x86_64 Error: 5: Input/output error
was there any resolution to this other than backing up locally? I am trying to perform the same task. expdp from linux64 to a cifs mount of a win2k3 64.
I haven´t the correct solution still, but I can solved it doing the backup locally and then moving these to the windows server through the mv command.
I had the same exact problem.
What I have done was to execute the export command from the windows side.
And I don't now if also contributed to the solution but I used in windows the normal exp command instead of data pump expdp command
Remove All locking instances onto your tablespace or schema. Then that error would not appear. Try making Readonly first from command line before using your expdp or whatever command.
I had exactly the same errors when backing up my oracle db with expdp on a cifs mounted file-system.
The problem what corrected by using the "directio" option.
From my "fstab" file:
//bck/backup /mnt/backup cifs directio,noperm,rsize=32768,wsize=32768,uid=root,credentials=/etc/cifspw.backup,_netdev 0 0
Looks like your datapump utility is corrupted.
Execute the below query and check , if you get the output of the query as zero than you need to reload the datapump utility.
SQL> select count(*) from metanametrans$;
Reload the datapump utility by executing the below scripts:
After executing the above query , try to take the export uisng expdp.
Thanks and Regards,
if you still the issue check that your mount directory is not across OS. It is happening to me and found that I am trying to expdp ona windows mounted directory on linux...I changed to a mounted directory from linux on linux...it worked...hope this helps!
Please check your disk left. when there is no space, this error occurs.