Upgrade Express: ".. unable to open dump file for read ... Permission denied"
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
[From ELUNA SysAdmin list:]
We started our migration from 18.01 to 20.01 and, for each library we are migrating, we noticed this error in DataPumping import error log.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file
"/exlibris/aleph/upgrade_express_1901_2001/data/a18_1/pto01/files/dpdir/pto0101.dmp"
for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 13: Permission denied Additional information: 3
Import (dp) pto01 ended
I tried a manual execution of the impdb command for import and it ends in the same way.
Exporting without datapumping seems to work.
Resolution:
[From Alexandra Major:]
Did you check the OS-Permissions on the dmp-files (user-, group- and file-permissions) and of the dpdir? The error messages 'unable to open
for read' and 'permission denied' look like permission-problems.
[From site:]
I checked the permissions for the files and they were right. But i never checked the /exlibris/aleph/update_express_1901_2001
permissions and they were 700 (for aleph user). Probably impdp program execs as "oracle" and not as "aleph" user. Now it's working.
- Article last edited: 10/8/2013