ORA-31617 unable to open dump file for write
Question: I am getting the ORA-31693 error during a data pump export in RAC:
ORA-31693: Table data object "xxx" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/u01/expdp/dump_test.dmp" for write
ORA-19505: failed to identify file "/u01/expdp/dump_test.dmp"
ORA-27037: unable to obtain file status
What is the cause of the ORA-31693 error?
Answer: You can use the oerr utility to look-up the ORA-31693 error:
ORA-31617: unable to open dump file "xxx" for write
Cause: Export was unable to open the export file for writing. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
The root cause of the ORA-31617 is likely in RAC is that this error occurs when parallel parameter is specified in using expdp in RAC databases and same physical directories does not exists in all nodes.
This is a bug in 11g and it is fixed in 11by setting the "cluster" parameter cluster=N :
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26838672/viewspace-2055100/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 解決問題：OSError: Unable to open file (truncated file: eof = 22118400, sblock-＞base_addr = 0, stored_eofErrorBloC
- C中的open(), write(), close(), fopen()
- How to Dump Redo Log File Information --metalinkORM
- Can't open file: (errno: 24)
- WPF open image and print as pdf file
- ftp_rawlist: Unable to create temporary file.FTP
- 完美解決xhost +報錯： unable to open display
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- "Visual Studio Code is unable to watch for file changes in this large workspace"
- open_basedir() restrictijon in effect. FIle()REST
- Linux open file與 fs-maxLinux
- ImportError: libffi.so.7: cannot open shared object file: No such file or directoryImportErrorObject
- Unable to open debugger port (127.0.0.1:29697): java.net.SocketException "socketException"127.0.0.1JavaException
- DUMP-CX_SY_OPEN_SQL_DB-DBSQL_DUPLICATE_KEY_ERRORSQLError
- [20181214]open file using O_DIRECT.txt
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- 【TUNE_ORACLE】等待事件之日誌等待“log file parallel write”Oracle事件Parallel
- 【TUNE_ORACLE】等待事件之IO等待“db file parallel write”Oracle事件Parallel
- (20200915Solved)Vscode出現Unable to open ‘hashtable_class_helper.pxi‘VSCode
- Unable to read TLD "META-INF/c.tld" from JAR fileJAR
- ORA-39358: Export dump file version 12.1.0 not compatible with target version 11Export
- python libclntsh.so.12.1: cannot open shared object filePythonObject
- 呼叫torchtext報錯OSError: libtorch_cpu.so: cannot open shared object file: No such file or directoryErrorObject
- git拉取程式碼報錯filename too long unable to create fileGit
- Visual C++ generate uuid via UuidCreate and CoCreateGuid,get time now,write string to fileC++GUI
- Latex編譯錯誤：Unable to load picture or PDF file 問題解決編譯
- libcudart.so.8.0: cannot open shared object file解決方案DartObject
- inplace-abn 報錯解決: ImportError: libcudart.so.9.0: cannot open shared object file: No such file or dirImportErrorDartObject
- 【故障處理】Linux下匯入匯出“IMP-00030: failed to create file ... for write”LinuxAI
- Nginx安裝啟動過程報錯libpcre.so.1 cannot open shared object file: No such file or directoryNginxObject
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- CentOS7提示 libsasl2.so.2: cannot open shared object fileCentOSObject
- file_get_content s()獲取https出現這個錯誤Unable to find the wrapperHTTPAPP
- Laravel5.6安裝：Warning: require(../vendor/autoload.php): failed to open stream: No such file or directoryLaravelUIPHPAI
- 7.81 DUMP
- MySQL double writeMySql
- [Javascript] Write .call()JavaScript
- MongoDB Write ConcernMongoDB