您好,登錄后才能下訂單哦!
小編給大家分享一下oracle中數據泵dump文件存放nfs報ORA-27054錯誤怎么辦,相信大部分人都還不怎么了解,因此分享這篇文章給大家參考一下,希望大家閱讀完這篇文章后大有收獲,下面讓我們一起去了解一下吧!
問題描述:源端 10.2.0.4 目標端:11.2.0.4 在目標端劃分1T存儲與源端做一個NFS
錯誤:指定dump導出為本地文件系統,正常。 指定dump導出為nfs文件系統,報錯。
報錯信息如下:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/devotd_dpump/expdp_metadata_vspp_sun.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
The NFS mount options seem to be incorrect. No specific setting was found to address this. The below options were tried but the same error was still encountered:
Mount options as per Note 781349.1 - ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Backup using RMAN into this problematic mount point was successful
Traditional export using exp to this problematic mount point was successful
Creation of a new datafile to this mount point was successful
Creation of a file from OS side to this problematic mount point was successful
Reboot of the NFS mount point made no difference
The only solution which worked in this case was to set the below event which disables the mount point parameter checking:
sqlplus / as sysdba
alter system set events '10298 trace name context forever, level 32';
做 10298 events 后,解決問題。
以上是“oracle中數據泵dump文件存放nfs報ORA-27054錯誤怎么辦”這篇文章的所有內容,感謝各位的閱讀!相信大家都有了一定的了解,希望分享的內容對大家有所幫助,如果還想學習更多知識,歡迎關注億速云行業資訊頻道!
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。