expdp ORA-31637 ORA-39080

ora4031

System name:    AIX
Node name:      dgps_ypdata2_srv
Release:        1
Version:        6
Machine:        00C1D5E54C00

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job GISDBJOB for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-24010: QUEUE SYS.AQ$_KUPC$DATAPUMP_QUETAB_E does not exist

其他信息见附件，大家伙帮忙分析一下，谢谢。

xifenfei

从报错ORA-24010: QUEUE SYS.AQ$_KUPC$DATAPUMP_QUETAB_E does not exist 看SYS.AQ$_KUPC$DATAPUMP_QUETAB_E队列丢失

可以参考相同版本库中该queue对象，在本库尝试常见，如果能够ok最好，如果不能ok，考虑重建data pumpdata

参考
        How To Reload Datapump Utility EXPDP/IMPDP (Doc ID 430221.1)

1. APPLIES TO:
   
2. 
   
3. Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
   
4. Information in this document applies to any platform.
   
5. ***Checked for relevance on 26-MAR-2013***
   
6. GOAL
   
7. 
   
8. How to reload DATAPUMP utility? This may be required in different situations, like hanging issues, internal errors, data dictionary incompatibility, etc, all of them related to initiating phase of DataPump.
   
9. 
   
10. SOLUTION
    
11. 
    
12. In some cases DataPump utility may get corrupted and we need to recreate DataPump utility to overcome internal corruption. To do this, you need to run a set of scripts as given below.
    
13. 
    
14. Note:  Run the following as sysdba user:
    
15. 
    
16. SQL> connect / as sysdba
    
17. 
    
18. 
    
19. For Oracle version 10.1 :
    
20. 
    
21. 1. Catdp.sql orders the installation of all its components including the Metadata API which was previously installed separately. By default catproc.sql invoke this script.
    
22. SQL> @$ORACLE_HOME/rdbms/admin/catdp.sql
    
23. 
    
24. 2. dbmspump.sql will create DBMS procedures for dataPUMP
    
25. SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql
    
26. 
    
27. For Oracle version 10.2:
    
28. 
    
29. 1. Catdph.sql will Re-Install DataPump types and views
    
30. SQL> @$ORACLE_HOME/rdbms/admin/catdph.sql
    
31. 
    
32. Note: If XDB is installed, then it is required to run "catmetx.sql" script also.
    
33. Use this code to verify if XDB is installed:
    
34. SQL> select substr(comp_name,1,30) comp_name,
    
35.      substr(comp_id,1,10) comp_id,
    
36.      substr(version,1,12) version,
    
37.      status
    
38.      from dba_registry;
    
39. 
    
40. Sample output if XDB installed,
    
41. Oracle XML Database    XDB    -version-    VALID
    
42. 
    
43. 2. prvtdtde.plb will Re-Install tde_library packages
    
44. SQL> @$ORACLE_HOME/rdbms/admin/prvtdtde.plb
    
45. 
    
46. 3. Catdpb.sql will Re-Install DataPump packages
    
47. SQL> @$ORACLE_HOME/rdbms/admin/catdpb.sql
    
48. 
    
49. 4. Dbmspump.sql will Re-Install DBMS DataPump objects
    
50. SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql
    
51. 
    
52. 5. To recompile  invalid objects, if any
    
53. SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
    
54. 
    
55. For Oracle version 11g:
    
56. 
    
57. 1. Catproc.sql
    
58. 
    
59. SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
    
60. 
    
61. 2. To recompile invalid objects, if any
    
62. 
    
63. SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
    
64. For runing catproc.sql, please refer to
    
65. Note 863312.1 - Best Practices for running catalog, catproc and utlrp script
    
66. 
    
67. Additional Resources
    
68. 
    
69. Community: Database Utilities
    
70. 
    
71. Still have questions? Use the above community to search for similar discussions or start a new discussion on this subject.
    
72. 
    
73. REFERENCES
    
74. 
    
75. NOTE:863312.1 - Best Practices for running catalog, catproc and utlrp script

复制代码