The following error may occur when you export data using Data Pump
Parameter file:
userid=system/mypasswd directory=DATA_PUMP_DIR logfile=exp_sales.log dumpfile=klm.dmp exclude=statistics job_name=exp_klm schemas=KLM flashback_time=systimestamp
Execute the export:
expdp parfile=expdp.parResult:
RA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [USER] USER:"GRDA_TEST" ORA-39155: error expanding dump file name "/data1/export/klm.dmp" ORA-48128: opening of a symbolic link is disallowed ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.KUPW$WORKER", line 12630 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.KUPF$FILE", line 9793 ORA-06512: at "SYS.KUPF$FILE_INT", line 1211 ORA-06512: at "SYS.KUPF$FILE", line 9734 ORA-06512: at "SYS.KUPW$WORKER", line 11341 ----- PL/SQL Call Stack ----- object line object handle number name 0xcf98d208 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION 0xcf98d208 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR 0xcf98d208 11612 package body SYS.KUPW$WORKER.CREATE_OBJECT_ROWS 0xcf98d208 15278 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS 0xcf98d208 3917 package body SYS.KUPW$WORKER.UNLOAD_METADATA 0xcf98d208 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS 0xcf98d208 2439 package body SYS.KUPW$WORKER.MAIN 0xcf996200 2 anonymous block KUPW: Object row index into parse items is: 1 KUPW: Parse item count is: 4 KUPW: In function CHECK_FOR_REMAP_NETWORK KUPW: Nothing to remap KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info KUPW: In procedure BUILD_SUBNAME_LIST with USER:KLM.KLM KUPW: In function NEXT_PO_NUMBER KUPW: PO number assigned: 13 KUPF$FILE.WRITE_LOB KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-39155: error expanding dump file name "/data1/export/klm.dmp" ORA-06512: at "SYS.KUPF$FILE", line 9793 ORA-48128: opening of a symbolic link is disallowed ORA-06512: at "SYS.KUPF$FILE_INT", line 1211 ORA-06512: at "SYS.KUPF$FILE", line 9734 Job "SYSTEM"."EXP_KLM" stopped due to fatal error at Wed Sep 22 08:42:49 2021 elapsed 0 00:00:04Reason: bug
Solution:
Outlined in Doc ID 2654167.1 "Customer RecommendedDataPump Export (EXPDP) Fails Due to ORA-39155 ORA-48128":
ALTER SYSTEM SET "_disable_directory_link_check" =true SCOPE=SPFILE; shutdown immediate startup
No comments:
Post a Comment