Donnerstag, 10. November 2016

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.

Keine Kommentare:

Kommentar veröffentlichen