导入/导出过程因目录权限出现的报错

刘泽宇

[oracle@redhat ~]$ expdp testuse/testuse@orcl directory=EXP_DIR dumpfile=test.dmp schemas=testuse;

Export: Release 12.1.0.2.0 - Production on Sun Sep 6 09:23:48 2020

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics 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

检查发现EXP_DIR所对应目录/tmp/dump权限不在oracle下
[oracle@redhat tmp]$ ll
total 0
drwxr-xr-x  2 root   root  6 Sep  6 08:31 dump


修改权限：chown -R oracle:dba /tmp/dump/
再次进行导入/导出即可