Expdp Error / ORA-31617/ORA-19505/ORA-27037

When trying to expdp the below error appear :
expdp anar/xxxxxx directory=TABLE_BACKUP dumpfile=before.dmp logfile=before.log EXCLUDE=table:"IN('T_PST_SMSMESSAGELOG'\,'DD_SERVICE_CALL_LOG_X')" schemas='OC_UNW','OC_ABS','OC_ATM','OC_SCR','OC_SCN','OC_SCE','OC_RPT','OC_PRM','OC_POS','OC_MSN','OC_MSC','OC_MRC','OC_MON','OC_MIS','OC_EOC','OC_ENT','OC_EMV','OC_CST','OC_CRD','OC_CMP','OC_CLR','OC_BIN','OC_WBS','OC_VIS','OC_TXN','OC_TSK','OC_SHR','OC_SYS','OC_CON','OC_YKB','OC_EOD','OC_BPS' parallel=4 compression=all
ORA-31693: Table data object "OC_CON"."OPERATION_EXECUTION_LOG" failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file "/backup/before.dmp" for write
ORA-19505: failed to identify file "/backup/before.dmp"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
You need to make sure of the below :
-  Folder exdp_folder should be exists on the both nodes with same path.

even if you try to connect using tnsnames it will generate error so solution:
-Remove parallel from your expdp command to be like this
-Use Cluster Option in expdp

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: