EXPDP 时ORA-27054 问题解决方法

共计 984 个字符，预计需要花费 3 分钟才能阅读完成。

现象：

[Oracle@oracle1 ~]$ expdp xian/xian schemas=xian directory=dumpdir dumpfile=xian.dmp LOGFILE=xian.log

Export: Release 10.2.0.5.0 – 64bit Production on Friday, 02 December, 2016 20:19:48

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, 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 “/backup/xian.dmp”

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Additional information: 3

Additional information: 18

原因：

文件夹 MOUNT NFS 时未加相关参数

需要追加参数：rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

解决：改成如下

mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 10.71.13.109:/oracle/backup/ /backup

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 ：http://www.linuxidc.com/Linux/2016-12/138117.htm