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/