While taking expdp in rac database, got below error.
ORA-31617: unable to open dump file “/dumparea/TEST/asset_75.dmp” for write
ORA-19505: failed to identify file “/dumparea/TEST/asset_75.dmp”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
In a RAC database, if you are taking export with parallel option and the datapump directory is not shared between the nodes, then expdpd will fail.
Because, the remote node is unable to write the dumps to that directory.
To avoid this error, user CLUSTER=N parameter while running as expdp. This will allow the expdp job to write only on local node.