Friday, July 12, 2013

impdp failed with ORA-39002 ORA-39070 ORA-39070 ORA-06512 ORA-29283


Problem description:


$ impdp system/*****@RACDB schemas=TEST directory=DP_TEST_DIR dumpfile=TEST_%U.dmp

Import: Release 11.2.0.3.0 - Production on Fri Jul 12 14:59:24 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


Cause:

impdp is connect to RAC database, but DP_TEST_DIR is point to directory on node1, 

Solution:

connect node1 for impdp:

impdp system/*****@RACDB1 schemas=TEST directory=DP_TEST_DIR dumpfile=TEST_%U.dmp

No comments:

Post a Comment