怎么解决Oracle执行expdp写入NFS文件系统提示ORA-39001错误
这篇文章主要讲解了“怎么解决Oracle执行expdp写入NFS文件系统提示ORA-39001错误”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“怎么解决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\'/assysdba\'directory=dir_dpschemas=hrdumpfile=hr.dmplogfile=hr.logparallel=2
Export:Release11.2.0.4.0-ProductiononThuOct2516:55:062018
Copyright(c)1982,2011,Oracleand
/or
itsaffiliates.Allrightsreserved.
Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,
DataMiningandRealApplicationTestingoptions
ORA-39001:invalidargumentvalue
ORA-39000:baddump
file
specification
ORA-31641:unabletocreatedump
file
"/backup/hr.dmp"
ORA-27054:NFS
file
systemwherethe
file
iscreatedorresidesisnotmountedwithcorrectoptions
Additionalinformation:3
Additionalinformation:18
1
2
3
4
5
6
7
8
9
10
ThuOct2516:55:082018
ALTERSYSTEMSETservice_names=
'SYS$SYS.KUPC$C_1_20181025165507.CAMS'
SCOPE=MEMORYSID=
'cams1'
;
ALTERSYSTEMSETservice_names=
'SYS$SYS.KUPC$C_1_20181025165507.CAMS'
,
'SYS$SYS.KUPC$S_1_20181025165507.CAMS'
SCOPE=MEMORYSID=
'cams1'
;
ThuOct2516:55:082018
DM00startedwithpid=55,OS
id
=17279,jobSYS.SYS_EXPORT_SCHEMA_01
WARNING:NFS
mount
of
file
/backup/hr
.dmponfilesystem
/backup
done
withincorrectoptions:rw,xattr,dev=9640001
WARNING:ExpectedNFS
mount
options:rsize>=32768,wsize>=32768,hard,
ThuOct2516:55:102018
ALTERSYSTEMSETservice_names=
'SYS$SYS.KUPC$S_1_20181025165507.CAMS'
SCOPE=MEMORYSID=
'cams1'
;
ALTERSYSTEMSETservice_names=
'cams'
SCOPE=MEMORYSID=
'cams1'
;
使用“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)
SYMPTOMSYou 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
CAUSEThe 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 perBug 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.
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-Fnfs-orw,bg,hard,rsize=32768,wsize=32768,vers=3100.100.100.54:/impbackup/backup
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
oracle@cwgsdb1:
/backup
$expdpdirectory=dir_dpschemas=hrdumpfile=hr.dmplogfile=hr.logparallel=2
Export:Release11.2.0.4.0-ProductiononThuOct2517:14:262018
Copyright(c)1982,2011,Oracleand
/or
itsaffiliates.Allrightsreserved.
Username:system
Password:
Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction
WiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,
DataMiningandRealApplicationTestingoptions
Starting
"SYSTEM"
.
"SYS_EXPORT_SCHEMA_01"
:system/********directory=dir_dpschemas=hrdumpfile=hr.dmplogfile=hr.logparallel=2
Estimate
in
progressusingBLOCKSmethod...
Processingobject
type
SCHEMA_EXPORT
/TABLE/TABLE_DATA
TotalestimationusingBLOCKSmethod:448KB
显然该问题是由NFS文件系统未正确挂载引起的,通过添加关键参数,重新挂载NFS系统,顺利解决Oracle执行expdp写入NFS文件系统提示ORA-39001 ORA-39000 ORA-31641 ORA-27054错误的问题。
感谢各位的阅读,以上就是“怎么解决Oracle执行expdp写入NFS文件系统提示ORA-39001错误”的内容了,经过本文的学习后,相信大家对怎么解决Oracle执行expdp写入NFS文件系统提示ORA-39001错误这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。