【故障处理】Linux下导入导出“IMP-00030: failed to create file ... for write”

【故障处理】Linux下Oracle导入(imp)导出(exp)出现“ IMP-00030: failed to create file import_sys for write ” 错误 

[oracle@rac18c-n1 upraw_oracle11g]$ imp xxxx file=raw.dmp ignore=y grants=no fromuser=UPRAW touser=UPCHINA

Import: Release 18.0.0.0.0 - Production on Tue Dec 4 15:01:38 2018

Version 18.3.0.0.0

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

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

Export file created by EXPORT:V11.02.00 via direct path

Warning: the objects were exported by UPRAW, not by you

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

export client uses AL32UTF8 character set (possible charset conversion)

IMP-00030: failed to create file import_sys for write

IMP-00000: Import terminated unsuccessfully

原因： 

oracle 账户没有对指定目录的读/写权限

解决办法： 

更换到Oracle有读写权限的相关目录

[root@rac18c-n1 ~]# chown -R oracle.dba /soft/oracle11g/oracle11g/upraw_oracle11g

[root@rac18c-n1 ~]# chmod 777 -R /soft/oracle11g/oracle11g/upraw_oracle11g

[root@rac18c-n1 ~]# 

---

---

About Me