Tuesday, May 31, 2011

Datapump fails with ORA-27086 on NFS

I've received following error while trying to perform full database export using datapump to NFS:

Export: Release 10.2.0.4.0 - Production on Tuesday, 31 May, 2011 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.



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  ]

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


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


6 comments:

  1. This issue solved my problem too.
    Thanks

    ReplyDelete
  2. My too, thanks as well

    ReplyDelete
  3. has anyone facing this problem on AIX? i cannot find lock daemon on aix OS. thanks

    ReplyDelete
  4. Yolanda S., I opened a SR today on this issue with AIX 6.1. I'm not having the issue with Red Hat. Other info: Oracle 11.2 the nfs mount is EmC data domain.

    # $EXPDP oradba/xxxxxxxxxxxxx DIRECTORY=ddbkup_dir DUMPFILE=expdp_$SID$EXT.dmp LOGFILE=expdp_$SID$EXT.log SCHEMAS=ORADBA

    Export: Release 11.2.0.1.0 - Production on Sun Sep 8 15:48:46 2013

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    ORA-39001: invalid argument value
    ORA-39000: bad dump file specification
    ORA-31641: unable to create dump file "/ddbkup/lawdb/expdp/lawtest/expdp_lawtest-2013_09_08_154753.dmp"
    ORA-27086: unable to lock file - already in use
    IBM AIX RISC System/6000 Error: 22: Invalid argument
    Additional information: 9
    Additional information: 22

    ReplyDelete
  5. Update: problem fixed with llock
    # oslevel; nfsstat -m
    6.1.0.0
    /ddbkup from /ddbkup:datadprod02
    Flags: vers=3,proto=tcp,auth=unix,hard,nointr,noac,llock,dynamic,link,symlink,rsize=32768,wsize=32768,retrans=5
    All: srtt=0 (0ms), dev=24000 (120000ms), cur=6000 (120000ms)

    ReplyDelete
  6. If restarting service does not work, please check if you have mounted nfs with -nolock option.

    ReplyDelete