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

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search