重庆思庄Oracle、Redhat认证学习论坛

标题: 导入/导出过程因目录权限出现的报错 [打印本页]

作者: 刘泽宇 时间: 2020-9-6 13:39
标题: 导入/导出过程因目录权限出现的报错
[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/
再次进行导入/导出即可

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)