Linux-x86_64 Error: 2: No such file or directory during IMPDP on Exadata

I am migrating at ~5TB schema to Exadata using datapump.
Successfully created a datapump export with parallel completed ~10hrs.

Now its time to import it on Exadata.

So i fired the impdp command

 
impdp '"/ as sysdba"' directory=DATAPUMPDIR schemas=PLANPROC  dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10


but…. Linux-x86_64 Error: 2: No such file or directory.

 
ORA-31693: Table data object "PLANPROC"."PLAN_TABLE" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/backup/exabackup/forexa/planprocforgg_03.dmp" for read
ORA-19505: failed to identify file "/backup/exabackup/forexa/planprocforgg_03.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

so i search metalink for any notes and found one.

How to Prevent ORA-39000 ORA-31640 ORA-27037 Errors When Performing DataPump Export/Import [ID 784566.1]

solution is to drop and create the directory and grant some privs.
but since im using sys, no need to grant just drop and create.

 
drop directory DATAPUMPDIR;
CREATE DIRECTORY planprocforgg as '/backup/exabackup/forexa';

fired again the same command

 
impdp '"/ as sysdba"' directory=planprocforgg schemas=PLANPROC  dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10

but same error.

now i dont know what to do, facebook time… and i remember that my source is a single instance and may target is an 8node RAC.
and my backup directory is only mounted on 1st node, so i modified the impdp command and specify CLUSTER=NO

 
impdp '"/ as sysdba"' directory=planprocforgg schemas=PLANPROC  dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10 cluster=no
 

PROBLEM SOLVE

Advertisements

One thought on “Linux-x86_64 Error: 2: No such file or directory during IMPDP on Exadata

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