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