EXPDP Gives ORA-39125: Worker Unexpected Fatal Error When Attempting To Exclude Jobs In Parfile
Last updated on FEBRUARY 28, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterHP OpenVMS Itanium
HP OpenVMS Alpha
Symptoms
When using 10.2.x expdp (datapump export) to do a full export, the export fails after adding the following parameter to the .par file.
exclude=job:"in ('OPS$COMMON','OPS$ORACLE', ...)"
The errors displayed by expdp are the following:
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD while calling DBMS_METADATA.SET_FILTER [ESTIMATE_PHASE]
ORA-31600: invalid input value EXCLUDE_NAME_EXPR for parameter NAME in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6258
----- PL/SQL Call Stack -----
object line object
handle number name
41DAC000 14927 package body SYS.KUPW$WORKER
41DAC000 6317 package body SYS.KUPW$WORKER
41DAC000 5095 package body SYS.KUPW$WORKER
41DAC000 8972 package body SYS.KUPW$WORKER
41DAC000 1882 package body SYS.KUPW$WORKER
41DAC000 6878 package body SYS.KUPW$WORKER
41DAC000 1260 package body SYS.KUPW$WORKER
25BF9C70 2 anonymous block
ORA-31600: invalid input value EXCLUDE_NAME_EXPR for parameter NAME in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6258
----- PL/SQL Call Stack -----
object line object
handle number name
41DAC000 14927 package body SYS.KUPW$WORKER
41DAC000 6317 package body SYS.KUPW$WORKER
41DAC000 5095 package body SYS.KUPW$WORKER
41DAC000 8972 package body SYS.KUPW$WORKER
41DAC000 1882 package body SYS.KUPW$WORKER
41DAC000 6878 package body SYS.KUPW$WORKER
41DAC000 1260 package body SYS.KUPW$WORKER
25BF9C70 2 anonymous block
The alert log shows these errors:
kupprdp: master process DM00 started with pid=64, OS id=6d4e
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_02', 'SYS', 'KUPC$C_1_^
kupprdp: worker process DW01 started with worker id=1, pid=66, OS id=754f
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_02', 'SYS');
Changes
You added the exclude parameter for datapump expdp.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms