ORACLE备份库到共享目录问题
来源:互联网 发布:淘宝品牌服装代理真假 编辑:程序博客网 时间:2024/06/07 00:49
在AIX下将表导出到NFS上
oracle@localhost:/home/oracle $expdp ora/ora tables=test directory=DMPDIR dumpfile=test.dmp
会报如下错误:
Export: Release 10.2.0.5.0 - 64bit Production on Friday, 27 May, 2011 10:58:57
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, 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 "/mnt/share/test.dmp"
ORA-27086: unable to lock file - already in use
IBM AIX RISC System/6000 Error: 49: No locks available
Additional information: 10
处理办法:
将/etc/filesystems中参数改为
/mnt/share:
dev = "/mnt/nasdatavg/nasdatalv/nas"
vfs = nfs
nodename = 10.0.0.2
mount = false
options = bg,hard,nointr,noac,llock,rsize=32768,wsize=32768,sec=sys,nosuid
account = false
对应LINUX为nolock.
oracle@localhost:/home/oracle $expdp ora/ora tables=test directory=DMPDIR dumpfile=test.dmp
会报如下错误:
Export: Release 10.2.0.5.0 - 64bit Production on Friday, 27 May, 2011 10:58:57
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, 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 "/mnt/share/test.dmp"
ORA-27086: unable to lock file - already in use
IBM AIX RISC System/6000 Error: 49: No locks available
Additional information: 10
处理办法:
将/etc/filesystems中参数改为
/mnt/share:
dev = "/mnt/nasdatavg/nasdatalv/nas"
vfs = nfs
nodename = 10.0.0.2
mount = false
options = bg,hard,nointr,noac,llock,rsize=32768,wsize=32768,sec=sys,nosuid
account = false
对应LINUX为nolock.
- ORACLE备份库到共享目录问题
- ORACLE expdp备份到windows网络共享文件目录(NFS)
- jfinal 发布到tomcat使用共享目录中的jar问题
- SQl server 备份远程共享目录
- ubunt和Windows共享目录设置备份
- Oracle DB 备份恢复目录
- 备份目录A到目录B
- emacs自动备份到指定目录
- shell 备份本地文件目录到远程机器
- windows virtualbox 共享目录到虚拟机 unbuntu
- samba共享linux目录到windows
- 挂载Windows共享到Linux目录下
- Oracle体系结构及备份——目录
- Oracle数据库从开发库到备份库的简单备份
- virtualbox 4.04 挂载windows共享目录问题
- samba共享目录不可写的问题
- win7 vm10.0 centos7 共享目录问题
- linux共享目录挂载权限问题
- Makefile解读
- J2SE视频总结
- 编程之美3.8 求二叉树中节点的最大距离
- 公司参加中国国际云计算技术和应用展览会
- iOS 小笔记
- ORACLE备份库到共享目录问题
- 练手C++一些经验记录,持续更新中
- MFC工作学习笔记(更新ing)
- 13周项目一.1(理解基类中成员的访问限定符和派生类的继承方式)
- java 绑定 ffmpeg 利器:jjmpeg
- GCC使用入门
- 设置非*.xml文件以XML格式打开
- 浏览器缓存机制
- jquery 显示隐藏div 常见用处插件 setTab