Oracle-11g-R2

ORA-39001:ORA-39000:ORA-31640:ORA-27041:和 Linux-x86_64 錯誤:13:權限被拒絕

  • September 1, 2018

我使用此命令導出數據:

expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW

現在將其導入其他伺服器:

[root@linux gsw]# impdp gsw/password remap_tablespace=SYSTEM:GSW remap_tablespace=USERS:GSW dumpfile=GSW-31-08-2018.dmp directory=gsw

Import: Release 11.2.0.2.0 - Production on Sat Sep 1 11:17:47 2018

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

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/admin/XE/dpdump/gsw/GSW-31-08-2018.dmp" for read

ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9

我用Google搜尋但無法修復它。請指教

感謝期待

主要問題是Linux-x86_64 Error: 13: Permission denied

cd /u01/app/oracle/admin/XE/dpdump/
chmod 777 -R gsw

然後以 oracle 使用者身份登錄並再次執行相同的命令

引用自:https://dba.stackexchange.com/questions/216476