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

最新推荐文章于 2024-09-05 09:50:54 发布

wonder_2012

最新推荐文章于 2024-09-05 09:50:54 发布

阅读量8.1k

点赞数

分类专栏： Troubleshooting 文章标签： file oracle application database testing 64bit

本文链接：https://blog.csdn.net/wonder_2012/article/details/7846906

版权

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

摘要由CSDN通过智能技术生成

报错信息：

[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