oracle impdp无法打开日志文件,Solaris 下 Oracle impdp 过程中出现的问题

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-29283: invalid file operation

ORA-06512: at "SYS.UTL_FILE", line 475

ORA-29283: invalid file operation

解决方法参考1：

今天在使用IMPDP完成数据导入的过程中遇到“ORA-39002、ORA-39070……”连续报错。

导致问题原因很简单，但是提示的错误信息内容比较“诡异”，为了朋友们少走弯路，简单记录一下这个问题的处理过程。

1.问题再现

sec@secDB /db_backup/dpump_dir$ impdp sec/sec directory=dpump_dir dumpfile=20100604020437_sec.dmp logfile=impdp.log

Import: Release 10.2.0.3.0 - 64bit Production on Friday, 04 June, 2010 14:39:16

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-292