Export Datapump: No locks available (NFS Share)

It’s time for a new post, istn’t it?

I recently had the problem that an expdp command failed with the following message:

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup/exp.dmp"
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 9
Additional information: 37

The problem is related with that the NFS server which provides the NFS share. It has no locking service installed and/or configured. There are two options, you either install a locking service on the NFS server or change the mount options.

The option “noac” needs to be replaced with “nolock”.

In my case I did the following change to /etc/fstab:

# Before
10.10.10.10:/Oracle  /backup  nfs  rw,rsize=32768,wsize=32768,tcp,vers=3,hard,intr,noac  0 0
# After
10.10.10.10:/Oracle  /backup  nfs  rw,rsize=32768,wsize=32768,tcp,vers=3,hard,intr,nolock  0 0

That’s IT.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: