Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Upgrade Express: ".. unable to obtain file status... No such file or directory"

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    We are trying to import our v18 data to v20. I run upgrade_util and choose:

    2. Install customer data
    1. Install Oracle data

    It doesn't work, and the error messages in the log are:

    Connected to: Oracle Database 11g Enterprise Edition Release - 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/a20_1/abc50/files/dpdir/abc5001.dmp" for read
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3

    A qualified DBA should perform the following changes in order to fix the problem:

    select DIRECTORY_NAME,DIRECTORY_PATH from dba_directories where DIRECTORY_NAME LIKE 'AB%DIR';

    Change from: /exlibris/aleph/upgrade_express_1901_2001/data/a20_1/abcXX/files/dpdir
    Change to: /exlibris/aleph/upgrade_express_1901_2001/data/a18_2/abcXX/files/dpdir

    The problem may have been a result of trying upgrade_util option 9 (transfer data between servers)...

    Additional Information

    ORA-39001 invalid argument value ORA-31640 unable to open dump

    • Article last edited: 10/8/2013