- 17 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-31617: Unable To Open Dump File For Write
PROBLEM:
While taking export in RAC database, got this error.Solution :
In a RAC database, if you are taking export with parallel option and the datapump directory is not shared between the nodes, then export will fail.
Because, the remote node is unable to write the dumps to that directory.
To avoid this error, use CLUSTER=N parameter while running as expdp.
This will allow the expdp job to write only on local node.
example:
dumpfile=asset_%U.dmp logfile=asset.log directory=VEN parallel=32 cluster=N