SOLVED

ORA-31617: Unable To Open Dump File For Write

Asked by OracleDba••11 views•oracle
1
2
3
4
5
ORA-31617: Unable To Open Dump File For Write

PROBLEM:

While taking export in RAC database, got this error.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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
OracleDba•

Post Your Solution