ORA-48128: opening of a symbolic link is disallowed, ORA-39155: error expanding dump file name,ORA-19505: failed to identify file, ORA-39126: Worker unexpected fatal error in Oracle 19c

Hi,

I got ” ORA-48128: opening of a symbolic link is disallowed, ORA-39155: error expanding dump file name,ORA-19505: failed to identify file, ORA-39126: Worker unexpected fatal error ” error during export in New Oracle 19c

 

Details of error are as follows. When I try to drop database in mount mode, i got the following error.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYS"."SYS_EXPORT_SCHEMA_19": "/******** AS SYSDBA" SCHEMAS=MSD_4 directory=test dumpfile=MSD_4_YENI_%U.dmp parallel=96 compression=all logfile=MSD_4_YENI.log exclude=statistics 
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/USER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [PACKAGE_BODY] 
PACKAGE_BODY:"MSD_4"."CORE_META_PKG"
ORA-39155: error expanding dump file name "/export/test/MSD_4_YENI_01.dmp"
ORA-48128: opening of a symbolic link is disallowed
ORA-19505: failed to identify file "/export/test/MSD_4_YENI_01.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

 

 

 

This error is related with the Oracle 19c version. I have upgraded the database to Oracle 19c from Oracle 18c.

 

To solve this error, run the following command to change related hidden parameters.

SQL> ALTER SYSTEM SET "_disable_directory_link_check" = TRUE SCOPE=SPFILE;
SQL> ALTER SYSTEM SET "_kolfuseslf" = TRUE SCOPE=SPFILE;

 

Then Restart database as follows.

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

 

Then try again, it will work fine.

 

Read the following post to learn more details about Datapump export import.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-4

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/