Oracle Expdp報 ORA-19505, ORA-27037 No such file or directory
AIX 6.1
資料庫版本：
Oracle 11.2.0.2 RAC
現象
並行執行expdp匯出報錯如下
ORA-31617: unable to open dump file "/backup/expdp_dir/expdp _eymit1_2012110703.dmp" for write
ORA-19505: failed to identify file "/backup/expdp_dir/expdp _eymit1_2012110703.dmp"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
診斷和解決過程
1.第一反應是作業系統目錄許可權不夠，手動把這個目錄的屬組改為oracle後，重新匯出，發現報錯還是存在
2.重新檢視directory許可權，發現許可權沒有問題，基本排除是許可權的問題
3.經過查詢發現為RAC的原因，在oracle 11.2.0.1之後都存在這個問題(見metalink [ID 1467232.1])，需要在expdp,impdp後面加上cluster=N，加上cluster=N後問題得到解決
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/21605631/viewspace-748697/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle ASM File DirectoryOracleASM
- oracle 11g rac expdp匯出時報錯：ORA-31694、ORA-31617、ORA-19505、ORA-27037Oracle
- Using Create directory & UTL_FILE in OracleOracle
- RAC單個節點執行expdp提示ORA-31693 ORA-31617 ORA-19505 ORA-27037錯誤
- tar (child): bzip2: Cannot exec: No such file or directory 報錯
- python unix ：No such file or directoryPython
- 【EXPDP】不使用DIRECTORY引數完成expdp資料備份
- 資料泵匯入報錯impdp ora-31693 ora-31640 ora-19505 ora-27037
- docker容器掛載 No such file or directoryDocker
- 呼叫torchtext報錯OSError: libtorch_cpu.so: cannot open shared object file: No such file or directoryErrorObject
- ORA-19505: failed to identify file "/home/oracle/dmp/20150625.DMP"AIIDEOracle
- gitbook no such file or directory 怎麼解決Git
- Oracle ASM User Directory and Group DirectoryOracleASM
- 自定義容器啟動指令碼報錯：exec user process caused "no such file or directory"指令碼
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- yum-GPG key retrieval failed: No such file or directoryAI
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- libcap.so.1:cannot open shared object file: No such file or directoryObject
- libXext.so.6: cannot open shared object file: No such file or directoryObject
- libz.so.1: cannot open shared object file: No such file or directoryObject
- create directory in OracleOracle
- Nginx安裝啟動過程報錯libpcre.so.1 cannot open shared object file: No such file or directoryNginxObject
- Oracle expdpOracle
- 記一次ORA-27037: unable to obtain file status錯誤AI
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- fatal error: libmemcached/memcached.h: No such file or directoryErrorIBM
- Linux 格式化分割槽 報錯Could not stat /dev/sda3 --- No such file or directoryLinuxdev
- 通過dba_directories 查詢Oracle相關的各種目錄(比如expdp dump directory)Oracle
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM Alias DirectoryOracleASM
- Oracle ASM Template DirectoryOracleASM
- move oracle 10 directoryOracle
- ORACLE directory 目錄Oracle
- 高德地圖使用cocoapods No such file or directory錯誤地圖
- oracle expdp and impdpOracle
- centos7.6 容器執行報錯 /etc/rc.d/init.d/functions: No such file or directoryCentOSFunction
- 打補丁報錯 File in patch is not a known Oracle Applications fileOracleAPP