OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMPDP errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMPDP errors [message #570842]

Fri, 16 November 2012 06:42

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Hi Mahesh, I am getting below an errors while taking backup via expdp on SMP sambha. Note: Log file is created during the backup but dmp file is not. But we can create the dmp file under the specified directory mannualy. Please do suggest.
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/oracle_backup/backup/even/exp_01.dmp"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2

[Topics SPLIT by LF]

[Updated on: Fri, 16 November 2012 06:46] by Moderator

Report message to a moderator

Re: IMPDP errors [message #570843 is a reply to message #570842]

Fri, 16 November 2012 06:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It appears that you don't have privileges to write into that directory. Do you?

Report message to a moderator

Re: IMPDP errors [message #570845 is a reply to message #570843]

Fri, 16 November 2012 06:54

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

But I am able to create the text file, dmp file, .sh file manualy.
I am also reachable to the dirctory by CD /oracle_backup/backup/even.

It means permisions are there

Report message to a moderator

Re: IMPDP errors [message #570846 is a reply to message #570845]

Fri, 16 November 2012 06:56

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

EXP backup is running successfully under this directory, there is no error, error coming while taking backup via expdp

Report message to a moderator

Re: IMPDP errors [message #570847 is a reply to message #570846]

Fri, 16 November 2012 07:26

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The user that started the instance does not have the privileges.
The difference between exp and expdp is that the first one executes under your OS account and the second one under that instance owner account.

Regards
Michel

Report message to a moderator

Re: IMPDP errors [message #570849 is a reply to message #570847]

Fri, 16 November 2012 07:50

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

I am tking backup via Oracle user system and it has read write permission on oracle directory. OS user is Oracle and while login through this user I am able to create files under the directory, where we want take the backup. hence I am not able to understand what permissions user doesn't have.

Report message to a moderator

Re: IMPDP errors [message #570853 is a reply to message #570849]

Fri, 16 November 2012 08:40

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to post ALL information concerning the directories (from /) and involved users as well as the result of "ps -eaf | egrep 'ora|tns'".
Also copy and paste the session that gets an error including the result of "id".

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: IMPDP errors [message #571002 is a reply to message #570842]

Tue, 20 November 2012 00:28

suddhasatwa_bhaumik
Messages: 18
Registered: October 2011
Location: India

Junior Member

Please post the commands you have used to create the directory and grant permissions to it.

Report message to a moderator

Re: IMPDP errors [message #571027 is a reply to message #571002]

Tue, 20 November 2012 05:00

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

create directory sdedb_even as '/oracle_backup/backup/even'
create directory sdedb_odd as '/oracle_backup/backup/odd'

GRANT READ, WRITE ON sdedb_even TO system;
GRANT READ, WRITE ON sdedb_odd TO system;

Report message to a moderator

Re: IMPDP errors [message #571029 is a reply to message #571027]

Tue, 20 November 2012 05:05

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Fri, 16 November 2012 15:40

You have to post ALL information concerning the directories (from /) and involved users as well as the result of "ps -eaf | egrep 'ora|tns'".
Also copy and paste the session that gets an error including the result of "id".

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: IMPDP errors [message #571070 is a reply to message #571029]

Wed, 21 November 2012 00:10

suddhasatwa_bhaumik
Messages: 18
Registered: October 2011
Location: India

Junior Member

Can you please provide the entire log file contents of the failed EXPDP. Please write it using the CODE tag as Michael specified. Thanks.

Report message to a moderator

Re: IMPDP errors [message #571095 is a reply to message #571070]

Wed, 21 November 2012 01:27

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No need of the whole log file, the extract with the error in the first post is sufficient.
Now to go further OP MUST answer my questions.

Regards
Michel

Report message to a moderator

Previous Topic:	Error executing 'Impdp' utility
Next Topic:	Restore Dump File Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:09:59 CST 2025