ORA-04063: package body “SYS.KUPW$WORKER” has errors
Posted by Mir Sayeed Hassan on January 12th, 2019
ORA-04063: package body “SYS.KUPW$WORKER” has errors
The above error occurs while performing the expdp of the full database in Oracle 11gR2.
Error Log:
[oracle@testdb new_dump]$ cat fulldbrec.log ;;; Export: Release 11.2.0.4.0 - Production on Sat Jan 12 15:43:42 2019 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 Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=new_dump dumpfile=fulldbrec%U.dmp logfile=fulldbrec.log full=yes exclude=statistics compression=all parallel=3 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 "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at Sat Jan 12 15:57:21 2019 elapsed 0 00:00:30
Solution:
Login to database as SYS and execute the given steps
[oracle@testdb new_dump]$ !sq sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 12 16:06:40 2019 Copyright (c) 1982, 2013, Oracle. 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
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; Grant succeeded.
SQL> grant insert on sys.ku$noexp_tab to public; Grant succeeded.
SQL> alter package KUPW$WORKER compile body; Package body altered. SQL> exit
Now execute the expdp command
[oracle@testdb new_dump]$ expdp system/manager directory=new_dump dumpfile=fulldbrec%U.dmp logfile=fulldbrec.log full=yes exclude=statistics compression=all parallel=3 Export: Release 11.2.0.4.0 - Production on Sat Jan 12 16:08:10 2019 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 Starting "SYSTEM"."SYS_EXPORT_FULL_02": system/******** directory=new_dump dumpfile=fulldbrec%U.dmp logfile=fulldbrec.log full=yes exclude=statistics compression=all parallel=3 Estimate in progress using BLOCKS method... Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Total estimation using BLOCKS method: 26.3 GB Processing object type DATABASE_EXPORT/TABLESPACE -- -- -- --
Hence completed successfully without any error