Production environment, due to the previous database failure, resulting in a few days of downtime, the operator asked to save a backup, 2016-09-05 with EXPDP export process problems
ora-39006:ora-39065:ora-04063:ora-06508:ora-39097:ora-01403:ora-39097:
First time: Export:release 10.2.0.5.0-64bit Production Onчǚһ, 05 9ղ, 2016 16:17:29
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to:oracle Database 10g Enterprise Edition release 10.2.0.5.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-04063:package body "SYS". Kupw$worker "has errors
Ora-06508:pl/sql:could not find program unit being called: "SYS." Kupw$worker "
Ora-39097:data Pump Job encountered unexpected error-6508
ORA-04063:
Solution Method:
View Sys.kupw$worker compilation failed, hint that table or view is missing
SELECT * from dba_dependencies where owner= ' SYS ' and Name=upper (' Kupw$worker ') and Referenced_type in (' TABLE ', ' VIEW ')
1 SYS kupw$worker PACKAGE body SYS ku$noexp_tab TABLE HARD
2 SYS kupw$worker PACKAGE body SYS ku$_view_status_view VIEW HARD
View whether the above two table views exist, and finally locate the ku$noexp_tab missing. Copy from the same version of the library. Problem solving
Second time:
Export:release 10.2.0.5.0-64bit Production Onчǚһ, 05 9ղ, 2016 16:17:29
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to:oracle Database 10g Enterprise Edition release 10.2.0.5.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
Ora-39097:data Pump Job encountered unexpected error 100
Although it is not like the other people on the Internet have encountered ORA-00600 errors, but follow the online approach, to regenerate some DataPump API to use the view problem is resolved:
The database starts normally
Sqlplus/as SYSDBA
@?/rdbms/admin/catmeta.sql
@?/rdbms/admin/catmet2.sql
@?/rdbms/admin/utlrp.sql
Please refer to the article on Metalink:
EXPDP fails with ORA-600 [Unable to LOAD XDB LIBRARY] [ID 736049.1]
This failure occurs for the production environment. Through the above two steps to solve the problem smoothly