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: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
What changed in the database on that day in September 2014?

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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 2985 times)

Report message to a moderator

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 2816 times)

Report message to a moderator

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 3003 times)

Report message to a moderator

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: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
What does the following from a command prompt yield?

C:\> path

Report message to a moderator

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 2946 times)

Report message to a moderator

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: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
Have you tried running an Oracle trace on the export session?

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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).

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

And what is in the trace file?

Report message to a moderator

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?

Report message to a moderator

Previous Topic: Export from 8i and Import to 10g
Next Topic: Import user Without Data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 03 16:40:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.