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

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

Resolution:
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 &