Skip to main content
ExLibris
  • 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

    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

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

    Resolution:
    Do the following for each library which has the problem:

    > dlib xxxnn
    > df1
    > chmod 777 dpdir
    > chmod 777 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