共计 4236 个字符，预计需要花费 11 分钟才能阅读完成。
这篇文章主要讲解了“怎么解决 Oracle 执行 expdp 写入 NFS 文件系统提示 ORA-39001 错误”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着丸趣 TV 小编的思路慢慢深入，一起来研究和学习“怎么解决 Oracle 执行 expdp 写入 NFS 文件系统提示 ORA-39001 错误”吧！
1. 执行 expdp 命令提示 ORA-27054 错误
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
oracle@cwgsdb1:~$ expdp \ / as sysdba\ directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2
Export: Release 11.2.0.4.0 – Production on Thu Oct 25 16:55:06 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, 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/hr.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
2. 查看 alert 日志信息
1
2
3
4
5
6
7
8
9
10
Thu Oct 25 16:55:08 2018
ALTER SYSTEM SET service_names= SYS$SYS.KUPC$C_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;
ALTER SYSTEM SET service_names= SYS$SYS.KUPC$C_1_20181025165507.CAMS , SYS$SYS.KUPC$S_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;
Thu Oct 25 16:55:08 2018
DM00 started with pid=55, OS id=17279, job SYS.SYS_EXPORT_SCHEMA_01
WARNING:NFS mount of file /backup/hr.dmp on filesystem /backup done with incorrect options:rw,xattr,dev=9640001
WARNING:Expected NFS mount options: rsize =32768,wsize =32768,hard,
Thu Oct 25 16:55:10 2018
ALTER SYSTEM SET service_names= SYS$SYS.KUPC$S_1_20181025165507.CAMS SCOPE=MEMORY SID= cams1 ;
ALTER SYSTEM SET service_names= cams SCOPE=MEMORY SID= cams1 ;
3. 在 MOS 上查找解决方案
使用“expdp ORA-27054”关键字查找，找到 MOS 文档：
ORA-27054: NFS File System Where the File is Created or Resides is Not Mounted With Correct Options (文档 ID 781349.1)
SYMPTOMS
You are transferring your database/installation to a NetApps NFS mount point.
The following error occurs on database startup:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file /nfs_d04/oasisxx/data/oasis_system.dbf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
The current mount point is mounted as:
rw,bg,rsize=32768,wsize=32768,hard,vers=3,nointr,timeo=600,proto=tcp,suid 0 0
CAUSE
The correct mount point options are being used but they are not in the correct order per oracle docs on correctly mounting NFS mounts for oracle software.
The correct setting should be:
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid
NOTE: the location of the parameter hard
NOTE: As per
Bug 11812928
, the intr nointr are deprecated in UEK kernels, as well as Oracle Linux 6. It is harmless to still include it, you will get a notice..
NFS: ignoring mount option: nointr.
SOLUTION
Mount the NFS mount point with the recommended options in the exact order specified in oracle documentation.
For example:
# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,forcedirectio,nointr,proto=tcp,suid host:/folder1/to1 /folder2/to2
NOTE: if settings revert back to original settings after remount, check auto-mounter options/settings. For more info on auto-mounter, please contact the OS vendor.
4. 重新挂载 NFS 文件
1
2
root@cwgsdb1:~# umount /backup
root@cwgsdb1:~# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3 100.100.100.54:/impbackup /backup
5. 结果验证
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
oracle@cwgsdb1:/backup$ expdp directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2
Export: Release 11.2.0.4.0 – Production on Thu Oct 25 17:14:26 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: system
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting SYSTEM . SYS_EXPORT_SCHEMA_01 : system/******** directory=dir_dp schemas=hr dumpfile=hr.dmp logfile=hr.log parallel=2
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 448 KB
显然该问题是由 NFS 文件系统未正确挂载引起的，通过添加关键参数，重新挂载 NFS 系统，顺利解决 Oracle 执行 expdp 写入 NFS 文件系统提示 ORA-39001 ORA-39000 ORA-31641 ORA-27054 错误的问题。
感谢各位的阅读，以上就是“怎么解决 Oracle 执行 expdp 写入 NFS 文件系统提示 ORA-39001 错误”的内容了，经过本文的学习后，相信大家对怎么解决 Oracle 执行 expdp 写入 NFS 文件系统提示 ORA-39001 错误这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是丸趣 TV，丸趣 TV 小编将为大家推送更多相关知识点的文章，欢迎关注！
