Home » RDBMS Server » Server Utilities » IMPDP errors
IMPDP errors [message #570842] Fri, 16 November 2012 06:42 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: IMPDP errors [message #570845 is a reply to message #570843] Fri, 16 November 2012 06:54 Go to previous messageGo to next message
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
Re: IMPDP errors [message #570846 is a reply to message #570845] Fri, 16 November 2012 06:56 Go to previous messageGo to next message
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
Re: IMPDP errors [message #570847 is a reply to message #570846] Fri, 16 November 2012 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: IMPDP errors [message #570849 is a reply to message #570847] Fri, 16 November 2012 07:50 Go to previous messageGo to next message
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.
Re: IMPDP errors [message #570853 is a reply to message #570849] Fri, 16 November 2012 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: IMPDP errors [message #571002 is a reply to message #570842] Tue, 20 November 2012 00:28 Go to previous messageGo to next message
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.
Re: IMPDP errors [message #571027 is a reply to message #571002] Tue, 20 November 2012 05:00 Go to previous messageGo to next message
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;
Re: IMPDP errors [message #571029 is a reply to message #571027] Tue, 20 November 2012 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: IMPDP errors [message #571070 is a reply to message #571029] Wed, 21 November 2012 00:10 Go to previous messageGo to next message
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.
Re: IMPDP errors [message #571095 is a reply to message #571070] Wed, 21 November 2012 01:27 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Error executing 'Impdp' utility
Next Topic: Restore Dump File Error
Goto Forum:
  


Current Time: Thu Mar 28 13:44:59 CDT 2024