expdp ORA-31637 ORA-39080
System name: AIXNode 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
其他信息见附件，大家伙帮忙分析一下，谢谢。
从报错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)APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3
Information in this document applies to any platform.
***Checked for relevance on 26-MAR-2013***
GOAL
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.
SOLUTION
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.
Note:Run the following as sysdba user:
SQL> connect / as sysdba
For Oracle version 10.1 :
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.
SQL> @$ORACLE_HOME/rdbms/admin/catdp.sql
2. dbmspump.sql will create DBMS procedures for dataPUMP
SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql
For Oracle version 10.2:
1. Catdph.sql will Re-Install DataPump types and views
SQL> @$ORACLE_HOME/rdbms/admin/catdph.sql
Note: If XDB is installed, then it is required to run "catmetx.sql" script also.
Use this code to verify if XDB is installed:
SQL> select substr(comp_name,1,30) comp_name,
substr(comp_id,1,10) comp_id,
substr(version,1,12) version,
status
from dba_registry;
Sample output if XDB installed,
Oracle XML Database XDB -version- VALID
2. prvtdtde.plb will Re-Install tde_library packages
SQL> @$ORACLE_HOME/rdbms/admin/prvtdtde.plb
3. Catdpb.sql will Re-Install DataPump packages
SQL> @$ORACLE_HOME/rdbms/admin/catdpb.sql
4. Dbmspump.sql will Re-Install DBMS DataPump objects
SQL> @$ORACLE_HOME/rdbms/admin/dbmspump.sql
5. To recompileinvalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
For Oracle version 11g:
1. Catproc.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
2. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
For runing catproc.sql, please refer to
Note 863312.1 - Best Practices for running catalog, catproc and utlrp script
Additional Resources
Community: Database Utilities
Still have questions? Use the above community to search for similar discussions or start a new discussion on this subject.
REFERENCES
NOTE:863312.1 - Best Practices for running catalog, catproc and utlrp script
页:
[1]