首页 > 其他 > 详细

EXPDP 时ORA-27054 问题处置

时间:2016-12-03 02:33:39      阅读:417      评论:0      收藏:0      [点我收藏+]

现象:

[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


本文出自 “麦地坞” 博客,请务必保留此出处http://yunlongzheng.blog.51cto.com/788996/1878995

EXPDP 时ORA-27054 问题处置

原文:http://yunlongzheng.blog.51cto.com/788996/1878995

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!