ORA-39065: unexpected master process exception in DISPATCH

In this article we will resolve error ORA-39065 . While exporting table in oracle using datapump, facing error ora-39065.

$expdp apps/apps tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_MASTER.dmp file=expdpEMP_POLICY_MASTER.log

Export: Release 11.2.0.4.0 - Production on Sat Feb 20 14:11:34 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-01403: no data found

To Validate the Problem I ran

SQL> select count(*) from metanametrans$;

  COUNT(*)

----------

         0

It should have more values than that!

Solution

@$ORACLE_HOME/rdbms/admin/catmet2.sql

@$ORACLE_HOME/rdbms/admin/utlrp.sql

Now we will check the issue....

$expdp apps/apps tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_MASTER.dmp lfile=expdpEMP_POLICY_MASTER.log

Export: Release 11.2.0.4.0 - Production on Sat Feb 20 14:36:58 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Legacy Mode Active due to the following parameters:

Legacy Mode Parameter: "file=expdpEMP_POLICY_MASTER1.log" Location: Command Line, Replaced with: "dumpfile=expdpEMP_POL    ICY_MASTER1.log"

Legacy Mode has set reuse_dumpfiles=true parameter.

Starting "APPS"."SYS_EXPORT_TABLE_01":  apps/******** tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_M    ASTER1.dmp dumpfile=expdpEMP_POLICY_MASTER1.log reuse_dumpfiles=true

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 256 KB

>>> DBMS_AW_EXP: Ignoring FPA.FPAPJP

>>> DBMS_AW_EXP: Ignoring APPS.ODPCODE

>>> DBMS_AW_EXP: Ignoring APPS.XWDEVKIT

Processing object type TABLE_EXPORT/TABLE/TABLE

>>> DBMS_AW_EXP: Ignoring FPA.FPAPJP

>>> DBMS_AW_EXP: Ignoring APPS.ODPCODE

>>> DBMS_AW_EXP: Ignoring APPS.XWDEVKIT

Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCACT_INSTANCE

Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ

. . exported "APPS"."EMP_POLICY_MASTER"                  146.5 KB    1310 rows

Master table "APPS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for APPS.SYS_EXPORT_TABLE_01 is:

  /data05/apps_dir/EMP_POLICY_MASTER1.dmp

Job "APPS"."SYS_EXPORT_TABLE_01" successfully completed at Sat Feb 20 14:37:37 2021 elapsed 0 00:00:38

Issue resolved.....................................