一：今天用資料泵匯出資料包錯,oracle rac 兩個例項都報錯，下面是rac1上的報錯，rac2上報錯只是紅色部分不一樣，變成了

ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_2 already exists，

[oracle@rac1 ceshi_bak]$ expdp system/manager123 directory=bak dumpfile=tb_storetemp_coloraa.dmp tables=ustest_zh_cn.tb_storetemp_color ;

Export: Release 11.2.0.3.0 - Production on Fri Sep 11 20:18:48 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_03 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1825
ORA-24001: cannot create QUEUE_TABLE, SYS.KUPC$DATAPUMP_QUETAB_1 already exists

在網上查了查找到以下文件
檢視一下資料庫中的無效的資料庫物件
SQL> select object_name from all_objects where owner='SYS' and status='INVALID';
OBJECT_NAME
------------------------------
KUPC$DATAPUMP_QUETAB_1
SYSNTfVzZ/2KLQNTgQ8CoAAJA1A==
SYSNTfVzZ/2KNQNTgQ8CoAAJA1A==
SYSNTfVzZ/2KPQNTgQ8CoAAJA1A==
AQ$_KUPC$DATAPUMP_QUETAB_V
AQ$_KUPC$DATAPUMP_QUETAB_E
AQ$_KUPC$DATAPUMP_QUETAB_F
AQ$KUPC$DATAPUMP_QUETAB
SBF_PUBLIC

9 rows selected.
發現無效物件中有datapump元件，

解決方法

1. 刪除 datapump queue 表，在sql下執行下面

SQL> exec dbms_aqadm.drop_queue_table(queue_table =>'SYS.KUPC$DATAPUMP_QUETAB_2', force=> TRUE);

PL/SQL procedure successfully completed.

2.執行下面儲存過程再次建立

BEGIN
dbms_aqadm.create_queue_table(queue_table => 'SYS.KUPC$DATAPUMP_QUETAB_2',
multiple_consumers => TRUE,
queue_payload_type =>'SYS.KUPC$_MESSAGE',
comment => 'DataPump Queue Table',
compatible=>'8.1.3');
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE = -24001 THEN NULL;
ELSE RAISE;
END IF;
END;

3，呼叫$ORACLE_HOME/RDBMS/ADMIN/utlrp.sql對資料庫中的invalid物件進行重新編譯

4 再次查下一個無效元件
SQL> select object_name from all_objects where owner='SYS' and status='INVALID';

OBJECT_NAME
------------------------------
SBF_PUBLIC
5 重啟一下例項，最後expdp可以正常執行了，此解決方法原始出處是在metalink 上一篇文章，

我的庫繼續報錯，此時報錯：

ORA-39006: internal error
ORA-39213: Metadata processing is not available

然後按著下面繼續操作，

二：仍然是網上的文章

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

Metalink確認是一個又來已經的已知問題，可以嘗試執行如下步驟解決：

connect / as sysdba
execute sys.dbms_metadata_util.load_stylesheets;

我的系統中，以上處理過程有效：

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> exec dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.

SQL> exit

此後匯出可以順利執行。

可是我的仍然報錯：

三：我的如果仍然報錯：

[oracle@rac1 ~]$ expdp system/manager123 directory=bak dumpfile=tb_storetemp_coloraa.dmp tables=ustest_zh_cn.tb_storetemp_color ;

Export: Release 11.2.0.3.0 - Production on Fri Sep 11 21:41:18 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, 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

再執行指令碼：

SQL>@$ORACLE_HOME/rdbms/admin/catmet2.sql

PL/SQL procedure successfully completed.

一次oracle 11g 資料泵報錯的解決過程

相關文章

一次oracle 11g 資料泵 報錯 的解決過程

相關文章

一次oracle 11g 資料泵報錯的解決過程