ORA-39006: internal error

Problem description:- One of our client facing some problem related to application roles and rights,after diagnosis we found there are some issue with the database and decided to replicate client environment at our site for further finding the solution. we asked client to send export copy of the database which is running in 11.2.0.1 and imported in our environment 11.2.0.3.While finding solution we need to export an application tables but when we tried expdp we got following error.

Export: Release 11.2.0.3.0 – Production on Tue Jul 9 15:23:01 2013

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

Connected to: Oracle Database 11g Release 11.2.0.3.0 – 64bit Production
ORA-39006: internal error
ORA-39213: Metadata processing is not available

Solution:- After referring metalink docs and oracle forum I found I need to reload stylesheets using below procedure.

SQL> execute sys.dbms_metadata_util.load_stylesheets;

After reloading stylesheets we tried again to perform export but stuck with some different error. Here is below error description.

Export: Release 11.2.0.3.0 – Production on Tue Jul 9 15:25:54 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Release 11.2.0.3.0 – 64bit Production
Starting “IFSAPP”.”SYS_EXPORT_TABLE_02″: ifsapp/********@tebmajul directory=expdir dumpfile=pres_object_tab.dmp tables=pres_object_tab
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name “DW00″ prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04063: package body “SYS.KUPW$WORKER” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.KUPW$WORKER”
ORA-06512: at line 2
Job “IFSAPP”.”SYS_EXPORT_TABLE_02″ stopped due to fatal error at 15:26:27

I tried to compile package body SYS.KUPW$WORKER manually but thrown some error while compilation.

SQL> alter package KUPW$WORKER compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY KUPW$WORKER:

LINE/COL ERROR
——– —————————————————————–
15304/5 PL/SQL: SQL Statement ignored
15304/34 PL/SQL: ORA-00942: table or view does not exist

After searching from metalink I got to know the workaround for this problem.

SQL> CREATE GLOBAL TEMPORARY TABLE sys.ku$noexp_tab ON COMMIT PRESERVE ROWS
AS SELECT * FROM sys.ku_noexp_view
/

Table created.

SQL> GRANT SELECT ON sys.ku$noexp_tab TO PUBLIC
2 /

Grant succeeded.

SQL> GRANT INSERT ON sys.ku$noexp_tab TO PUBLIC
2 /

Grant succeeded.

SQL> alter package KUPW$WORKER compile BODY;

Package body altered

Conclusion:- This Problem normally seen if upgrade has face some problem because I follow the same thing for other database but didn’t find any issue after upgrade from 11.2.0.1 to 11.2.0.3.