DB : Oracle 19.5
OS : RHEL 7
Expdp is failing due to the below error in my 19c database
Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: path traverses a symlink [29433]
Reason:-
here my export directory is using symlink and as per oracle from 18c onwards No symbolic links for Data Pump directories
lrwxrwxrwx 1 oracle oinstall 10 Aug 24 2017 exp_symlk -> /export/gold
Solution :-
Remove symlink for that directory and rerun export again
$ rm -f expimp
$ mkdir expimp
(OR)
If you don’t want to remove symlink then you have to restore back to old behavior
To restore the old behavior, the following underscore parameter must be set.
SQL> ALTER SYSTEM SET “_disable_directory_link_check” = TRUE SCOPE=SPFILE; (Recommend NOT to use)
NOTE :
To identify directory objects with symbolic links in the path name, run
$ORACLE_HOME/rdbms/admin/utldirsymlink.sql AS SYSDBA
Refer :
DataPump Export (EXPDP) Fails Due to ORA-39155 ORA-48128 (Doc ID 2654167.1)
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-overview.html#GUID-06B2DF71-2A66-498F-B659-1EF5859B1648
