Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Error during oracle_expdp_current_lib / oracle_expdp_aleph_libs

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

    Description:
    We run oracle_expdp_current_lib to export library ABC01 and see following error messages:

    Export library ABC01
    rm: No match.

    Export: Release 11.1.0.7.0 - 64bit Production on Monday, 15 August, 2011 11:51:38

    Copyright (c) 2003, 2007, Oracle. All rights reserved.

    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-39002: invalid operation
    ORA-39070: Unable to open the log file.
    ORA-29283: invalid file operation
    ORA-06512: at "SYS.UTL_FILE", line 536
    ORA-29283: invalid file operation

    Resolution:
    We see that in your Oracle-DB there are DIRECTORY-objects for your ABC-libraries with directory paths from UEX (created during UEX-run).

    m201@(a20_2):...files/dpdir>sqlplus aleph_dba/aleph_dba as sysdba
    SQL*Plus: Release 11.1.0.7.0 - Production on Mon Aug 15 12:27:35 2011
    Copyright (c) 1982, 2008, Oracle. All rights reserved.

    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

    sys@ALEPH20> select * from dba_directories
    2 where DIRECTORY_NAME like 'ABC%';
    **** Hit return to continue ****

    OWNER DIRECTORY_NAME
    ------------------------------ ------------------------------
    DIRECTORY_PATH
    --------------------------------------------------------------------------------
    SYS ABC01_DIR
    /exlibris/aleph/upgrade_express_1901_2001/data/a18_2/abc01/files/dpdir

    SYS ABC50_DIR
    /exlibris/aleph/upgrade_express_1901_2001/data/a18_2/abc50/files/dpdir


    The expdp-Skript outside UEX tries to use these directories and there is an error message.

    We suggest to drop these directories:

    DROP DIRECTORY ABC01_DIR;
    DROP DIRECTORY ABC05_DIR;


    Then export is running ok.

    Additional Information

    oracle_expdp_current_lib oracle_expdp_aleph_libs


    • Article last edited: 10/8/2013
    //doorbell.io feedback widged