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