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 22.214.171.124.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.
Do you want to learn Oracle Database for Beginners, then read the following articles.
3,541 views last month, 1 views today