expdp直接导出文件到NFS共享的挂载目录，报错ORA-27086: unable to lock file - already in use

最新推荐文章于 2025-09-14 18:38:39 发布

原创最新推荐文章于 2025-09-14 18:38:39 发布 · 8.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#file #oracle #application #database #testing #64bit

Troubleshooting 专栏收录该内容

5 篇文章

订阅专栏

在使用Oracle的expdp工具将数据库导出到NFS共享挂载目录时，遇到了ORA-27086错误，提示无法锁定文件，已处于使用状态。该问题可以通过在挂载NFS目录时添加'nolock'参数来解决。具体操作为：先卸载备份目录，然后重新挂载时包含'nolock'选项，例如：`umount /backup`，`mount -o nolock 10.13.12.11:/data4/111.197.25.29back /backup/`。

报错信息：

[oracle@szmlserver95_217 expdpback]$ cat !$
cat j10dba_20120809.log
;;;
Export: Release 11.2.0.1.0 - Production on Thu Aug 9 11:09:50 2012

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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup/expdpback/j10dba_217_20120809.dmp"
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10

解决方法：挂载时使用nolock参数即可

# unmount /backup

# mount -o nolock 10.13.12.11:/data4/111.197.25.29back /backup/