Home » RDBMS Server » Server Utilities » Export Problems Oracle 10g (Oracle 10g)
Export Problems Oracle 10g [message #630770] Mon, 05 January 2015 05:25 Go to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
Hello,

I try to do a export of a database (daily backup).
To do this, I use:

exp user/pwd file=C:\Test\dbdump.dmp


and I get following error:

EXP-00056:
EXP-00000: The export process ended with errors.


/forum/fa/12411/0/

Version of Oracle is 10.2.0.1.0 Enterprise Edition.

When I go to cmd and write this command and press enter, it doesn't start. I get directly this error.

For other customers (most of them uses 11g Express) this command is successfully every night (automatically backup).

Until September 2014 this command was successfully for the problem-customer. Today we go remote to the server because
there was an error and we need the dmp and we see that the backup not be started since then.
The last dmp-File is from September 2014.

Can anyone help, please?

Thank you,

Sarah

[Updated on: Mon, 05 January 2015 05:29]

Report message to a moderator

Re: Export Problems Oracle 10g [message #630772 is a reply to message #630770] Mon, 05 January 2015 05:50 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What changed in the database on that day in September 2014?
Re: Export Problems Oracle 10g [message #630778 is a reply to message #630770] Mon, 05 January 2015 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This command, as it, is expected to be executed on the database server; is this the case?

Re: Export Problems Oracle 10g [message #630779 is a reply to message #630778] Mon, 05 January 2015 06:28 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
@gazzag: I don't know if anything was changed, maybe my workmate made a change, but he's ill. Theres no entry on Server diary for this time.

@Michael Cadot: Yes, it is the database server.
Re: Export Problems Oracle 10g [message #630780 is a reply to message #630779] Mon, 05 January 2015 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Next question, check ORACLE_HOME, ORACLE_SID and PATH are correctly set.

Re: Export Problems Oracle 10g [message #630784 is a reply to message #630780] Mon, 05 January 2015 07:01 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
Screenshot registry 1.

(Hope you mean sqlpath when you wrote "path").

/forum/fa/12412/0/
  • Attachment: reg1.jpg
    (Size: 179.55KB, Downloaded 2029 times)
Re: Export Problems Oracle 10g [message #630785 is a reply to message #630784] Mon, 05 January 2015 07:01 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
Screenshot registry 2.

/forum/fa/12413/0/
  • Attachment: reg2.jpg
    (Size: 94.98KB, Downloaded 1852 times)
Re: Export Problems Oracle 10g [message #630786 is a reply to message #630785] Mon, 05 January 2015 07:03 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
Screenshot registry 3.

Note: in picture 2 theres "ko", but usually we only use orcl.

/forum/fa/12414/0/
  • Attachment: reg3.jpg
    (Size: 95.23KB, Downloaded 2038 times)
Re: Export Problems Oracle 10g [message #630787 is a reply to message #630784] Mon, 05 January 2015 07:04 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What does the following from a command prompt yield?

C:\> path
Re: Export Problems Oracle 10g [message #630790 is a reply to message #630787] Mon, 05 January 2015 07:17 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
/forum/fa/12415/0/
  • Attachment: path.jpg
    (Size: 42.90KB, Downloaded 1982 times)
Re: Export Problems Oracle 10g [message #630791 is a reply to message #630790] Mon, 05 January 2015 07:22 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Have you tried running an Oracle trace on the export session?
Re: Export Problems Oracle 10g [message #630798 is a reply to message #630786] Mon, 05 January 2015 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Registry is not read by "DOS" command.
In the DOS box, before the "exp" command, post the result of "set", then the execution of "set".
Note that DOS box allows to copy and paste the text inside it so you don't need to post an image
(just click on the DOS box icon, then "Properties", then check "Quick edition mode" in "Options"
tab and "OK"; then you can select with the mouse some text and copy it in the clipboard clicking
on the right button of the mouse).

Re: Export Problems Oracle 10g [message #630799 is a reply to message #630770] Mon, 05 January 2015 08:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>EXP-00000: The export process ended with errors.

if LOG= is specified on command line, then errors should be reported in it.
Re: Export Problems Oracle 10g [message #630801 is a reply to message #630799] Mon, 05 January 2015 08:24 Go to previous messageGo to next message
Evfemina
Messages: 7
Registered: January 2015
Location: Germany
Junior Member
I have try using LOG=.., but the logfile contains just the error message like at cmd (EXP-00056+EXP-00000).

Actually I'm trying like the post of gazzag, run it with trace. Until now the export is running and trace file write.
Re: Export Problems Oracle 10g [message #630802 is a reply to message #630801] Mon, 05 January 2015 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And what is in the trace file?

Re: Export Problems Oracle 10g [message #630828 is a reply to message #630802] Mon, 05 January 2015 09:24 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when was the last time exp worked without error?
what changed since then?
Previous Topic: Export from 8i and Import to 10g
Next Topic: Import user Without Data
Goto Forum:
  


Current Time: Thu Mar 28 09:07:57 CDT 2024