Home » RDBMS Server » Server Utilities » Problem with expdp through EM (10.2.0.3, Unix)
Problem with expdp through EM [message #437669] Tue, 05 January 2010 07:55 Go to next message
jspatz
Messages: 3
Registered: January 2010
Location: Long Island NY
Junior Member
On 1-3 we ran out of disk space in the middle of doing a datapump export which we have scheduled through EM to happen once a night. We cleared up the disk space issue, but since then the regularly scheduled job has been failing with the following error messages.

ORA-39002: invalid operation
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/ora-backups/data_pump/lawprod/EXPDAT01.100103.DMP" for read
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3


The file permissions to the directory are fine, but it looks like it is trying to reference the dmp file that failed on the third for some reason. I have browsed metalink but I haven't seen any similar issues. Is the job hosed, do I need to just delete it and recreate the job? Or is there a way to fix it so it tries creating a new dump file which it is supposed to do nightly anyway?
Re: Problem with expdp through EM [message #437676 is a reply to message #437669] Tue, 05 January 2010 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
do I need to just delete it and recreate the job?

This is what I should do.
Better (safer) restart with a clean environment.

Regards
Michel
Re: Problem with expdp through EM [message #437685 is a reply to message #437676] Tue, 05 January 2010 08:53 Go to previous messageGo to next message
jspatz
Messages: 3
Registered: January 2010
Location: Long Island NY
Junior Member
Thanks for the reply.. Is this a common occurrence with EM? One failed run corrupting future runs?

Re: Problem with expdp through EM [message #437687 is a reply to message #437685] Tue, 05 January 2010 08:57 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know I do not use EM.

Regards
Michel
Previous Topic: Import - indexes
Next Topic: Tunning of SQLLDR control file
Goto Forum:
  


Current Time: Thu Apr 25 01:32:20 CDT 2024