AWRLOAD ORA-31640

此问题的原因是dump文件权限不够导致。

ERROR at line 1:
ORA-20115: datapump import encountered error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/oracle/oradata/dump/awr201303_citi.dmp" for read
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 9
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 1713
ORA-06512: at line 3


[root@localhost share]# cd /oracle/oradata/dump/
[root@localhost dump]# ll
total 343492
-rw-r----- 1 root root 127221760 Mar 28 10:33 awr201303_citi.dmp
-rwxr-xr-x 1 root root 223285248 Mar 21 10:43 ecard_0321.dmp
-rw-r--r-- 1 oracle dba 27079 Mar 28 11:52 ecard_0321.log
-rw-r--r-- 1 oracle dba 837238 Mar 28 12:15 ecard1.lst
[root@localhost dump]# chown oracle:dba awr201303_citi.dmp
[root@localhost dump]# ll
total 343492
-rw-r----- 1 oracle dba 127221760 Mar 28 10:33 awr201303_citi.dmp
-rwxr-xr-x 1 root root 223285248 Mar 21 10:43 ecard_0321.dmp
-rw-r--r-- 1 oracle dba 27079 Mar 28 11:52 ecard_0321.log
-rw-r--r-- 1 oracle dba 837238 Mar 28 12:15 ecard1.lst