Home » RDBMS Server » Server Utilities » EXPDP on NFS error
EXPDP on NFS error [message #573546] Mon, 31 December 2012 04:17 Go to next message
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
Member
Hi ,

We are getting below error while taking EXPDP on NFS, please do help us to get the solution.

Error:-
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/metabkp2012/metadbbkp/SI_INFORMTN_SCHEMA.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

Server Details:-
Linux momafilter 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux

Permision is already there and below is the details of fstab

nfs rw,hard,nointr,rsize=32768,wsize= 32768,noac,vers=3

Report message to a moderator

Re: EXPDP on NFS error [message #573547 is a reply to message #573546] Mon, 31 December 2012 04:34 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Cause: The file was on an NFS partition and either reading the mount tab file failed or the partition was not mounted with the correct mount option.

Action: Make sure mount tab file has read access for Oracle user and the NFS partition where the file resides is mounted correctly. For the list of mount options to use refer to your platform specific documentation.


By the way, what are these 3 "additional information"? Do they reveal something useful?

Report message to a moderator

Re: EXPDP on NFS error [message #573558 is a reply to message #573547] Mon, 31 December 2012 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The "additional information" is a code Oracle got from the system.
Most often it is a standard OS error; "3" means "The system cannot find the path specified."

Regards
Michel

Report message to a moderator

Re: EXPDP on NFS error [message #573567 is a reply to message #573558] Mon, 31 December 2012 05:53 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ah! I see; thank you!

Report message to a moderator

Previous Topic: export dump
Next Topic: no change in rows(sqlldr)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 21:57:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.