Monday 6 July 2015

Datapump fails with ORA-27086 on NFS



Export: Release 10.2.0.4.0 - Production on Tuesday, 2 June, 2015 11:27:50
 
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Release 10.2.0.4.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup-nfs/testdb/export/exportfull.dmp"
ORA-27086: unable to lock file - already in use
Linux Error: 37: No locks available
Additional information: 10


In this case problem was lying in NFS locking deamons - on most Unix-like systems also known as rpc.lockd and the rpc.statd. For this just restart the service



Checking if 'nfslock' service is running:
1
2
# service nfslock status
rpc.statd is stopped

Start 'nfslock' service:
1
2
# /etc/init.d/nfslock start
Starting NFS statd:                                        [  OK  ]

Status:
1
2
# service nfslock status
rpc.statd (pid  4943) is running...


Starting 'nfslock' service resolved my problem with performing export to NFS.