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

    oracle_impdp_aleph_libs: invalid file operation ... at "SYS.UTL_FILE"

    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Problem Symptoms:
    The following series of messages is seen in running a Data Pump import (oracle_impdp_aleph_libs proc or the Upgrade Express "Create Customer Data" / install_utree):
    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

    This may indicate:
    1. a problem with the permissions on the dpdir files; or
    2. Old Oracle UE directories

    Do the following: 
    > cd $alephe_root
    > cd ..
    > chmod 777 */files/dpdir
    > chmod 777 */files/dpdir/*

    If that doesn't help, drop old Upgrade Express Oracle directories which may exist:
    a. > sqlplus sys/oradba as sysdba
    b. SQL> select * from all_directories;
    c. SQL> drop directory XXXNN_DIR_UE; <where "XXXNN" is the library (xxx01, xxx50, etc.) >

    Note: When oracle_impdp_aleph_libs is being run separately from UE, the plain XXXNN_DIR directories will also (or instead) need to be deleted.

    Assuming that oracle_expdp_aleph_libs was used to perform the export, the following commands can be used to do the import:

    > cd $aleph_proc
    > csh -f oracle_impdp_aleph_libs yes > & $alephe_scratch/oracle_impdp_aleph_libs.0122.js.log &

    Additional Information

    Note: If the problem occurs on an *export* (oracle_expdp_aleph_libs proc or the Upgrade Express "Create Customer Data" / create_user_data), see Article 000003484 {"Oracle Data Pump doesn't work in UE Create Customer Data step (or otherwise)"}.

    Category: System Management (500)

    • Article last edited: 2/24/2015