DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Monday, July 6, 2015

Datapump fails with ORA-27086 on NFS

Export: Release - Production on Tuesday, 2 June, 2015 11:27:50
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Release - 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:

# service nfslock status
rpc.statd is stopped

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

# service nfslock status
rpc.statd (pid  4943) is running...

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