expdp出dmp檔案到NFS NAS報錯ora-39001 ora-39000 ora-31641 ora-27054
透過查詢metalink id :387700.1
文件上說可能的問題有以下幾種:
a) The mount table (eg; /etc/mnttab) can be read to check the mount options
b) The NFS mount is mounted with the "hard" option
c) The mount options include rsize>=32768 and wsize>=32768
d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.
文件上指出透過設定event 10298事件可以避免,不過設定event 10298需要重啟資料庫生效 。
檢查NFS的配置,發現客戶端的/etc/filesystems中未加入mount nfs檔案系統的條目
增加以下條目後,重新mount,解決。
#vi /etc/filesystems
/exp:
dev = /exp
vfs = nfs
nodename = 192.168.1.20
mount = true
options = rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600
account = false
#umount /oraexp
#mount /oraexp
建議大家以後遇到類似問題,先檢查/etc/filesystems檔案,這個問題都是由於大家都喜歡使用以下方式mount nfs導致。
mount -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600 192.168.1.20:/exp /exp
//相關metalink 文件如下:
ORA-19504 ORA-27054 Errors mounting NFS file system [ID 370513.1]
RMAN Backup Fails With RMAN-03009 ORA-19504 ORA-27054 NFS file system where the file is created or resides is not mounted with correct options [ID 1472448.1]
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options [ID 781349.1]
//另外設定10298的過程如下:
1) set the Event 10298 in the init file
event="10298 trace name context forever, level 32"
if you are using the spfile then the following can be done
SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile ;
文件上說可能的問題有以下幾種:
a) The mount table (eg; /etc/mnttab) can be read to check the mount options
b) The NFS mount is mounted with the "hard" option
c) The mount options include rsize>=32768 and wsize>=32768
d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.
文件上指出透過設定event 10298事件可以避免,不過設定event 10298需要重啟資料庫生效 。
檢查NFS的配置,發現客戶端的/etc/filesystems中未加入mount nfs檔案系統的條目
增加以下條目後,重新mount,解決。
#vi /etc/filesystems
/exp:
dev = /exp
vfs = nfs
nodename = 192.168.1.20
mount = true
options = rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600
account = false
#umount /oraexp
#mount /oraexp
建議大家以後遇到類似問題,先檢查/etc/filesystems檔案,這個問題都是由於大家都喜歡使用以下方式mount nfs導致。
mount -o rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600 192.168.1.20:/exp /exp
//相關metalink 文件如下:
ORA-19504 ORA-27054 Errors mounting NFS file system [ID 370513.1]
RMAN Backup Fails With RMAN-03009 ORA-19504 ORA-27054 NFS file system where the file is created or resides is not mounted with correct options [ID 1472448.1]
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options [ID 781349.1]
//另外設定10298的過程如下:
1) set the Event 10298 in the init file
event="10298 trace name context forever, level 32"
if you are using the spfile then the following can be done
SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile ;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25462274/viewspace-2122642/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle執行expdp寫入NFS檔案系統提示ORA-39001 ORA-39000 ORA-31641 ORA-27054錯誤OracleNFS
- EXPDP備份到NFS檔案系統 ORA-27054NFS
- oracle之 資料泵dump檔案存放nfs報ORA-27054OracleNFS
- 檢視dmp檔案是exp還是expdp匯出來的
- 如何獲取expdp出來的dmp檔案中的DDL語句
- 如何確定一個dmp檔案是exp匯出的還是expdp匯出的?
- ORACLE expdp備份到windows網路共享檔案目錄(NFS)OracleWindowsNFS
- 通過NFS方式來保留rac歸檔日誌遭遇ORA-27054錯誤NFS
- 【ASK_ORACLE】一眼判斷出Oracle的dmp檔案是用expdp匯出還是exp匯出Oracle
- oracle匯出dmp檔案的2種方法Oracle
- ORA-27054: NFS 問題處理NFS
- win10藍屏dmp檔案在哪_win10系統如何獲取藍屏錯誤dmp檔案Win10
- linux:ora-27054:nfs file system errorLinuxNFSError
- oracle匯入dmp檔案Oracle
- 查詢dmp檔案(exp方式匯出) 字符集
- 修改exp 的 匯出dmp檔案的字符集
- RMAN備份資料到NFS提示ORA-27054NFS
- plsql Oracle匯入dmp檔案SQLOracle
- 抽取exp/expdp匯出檔案頭的資訊
- win10藍色畫面dmp檔案在哪_win10系統如何獲取藍色畫面錯誤dmp檔案Win10
- ORA-27054: NFS file system where the file is created or resides is ......NFSIDE
- expdp exclude/include 命令出錯
- 實用解析dmp檔案內容
- 利用tftp和nfs下載檔案到開發板FTPNFS
- 檔案共享之nfsNFS
- 解決oracle rman報ORA-27054 NFS file system where the file is created or resides is not mounted with corOracleNFSIDE
- 增加ORACLE歸檔位置到NFSOracleNFS
- ORA-27054: NFS file system where the file is created or resides is not mountedNFSIDE
- expdp over nfs 問題解決NFS
- ORACLE mount NFS NAS 正確方法OracleNFS
- oracle 還原 .dmp 格式備份檔案Oracle
- Oracle exp dmp包檔案轉化為insert語句,extract dmp to sqlfileOracleSQL
- NFS網路檔案共享NFS
- oracle匯入dmp檔案win10怎麼操作_win10系統oracle如何匯入dmp檔案OracleWin10
- 從一種強制停庫方法到Oracle NFS檔案鎖OracleNFS
- Linux下NFS掛載NAS方式LinuxNFS
- ORA-27054 錯誤解決
- myeclipse js檔案報錯EclipseJS