通過資料庫鏈匯出遇到ORA-39126錯誤

在11.2.0.2資料庫中通過NETWORK_LINK方式匯出或匯入10.2.0.3資料庫中的表，出現了這個錯誤。

 

 

詳細錯誤如下：

[oracle@Oracle112 dmp]$ impdp system/password noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107;

Import: Release 11.2.0.2.0 - Production on Wed Mar 16 04:44:36 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_IMPORT_TABLE_01":  system/******** noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-00920: invalid relational operator
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x136b50808     19208  package body SYS.KUPW$WORKER
0x136b50808      8385  package body SYS.KUPW$WORKER
0x136b50808     12748  package body SYS.KUPW$WORKER
0x136b50808      4742  package body SYS.KUPW$WORKER
0x136b50808      9110  package body SYS.KUPW$WORKER
0x136b50808      1688  package body SYS.KUPW$WORKER
0x137e37d68         2  anonymous block

Job "SYSTEM"."SYS_IMPORT_TABLE_01" stopped due to fatal error at 04:44:38

[oracle@Oracle112 dmp]$ expdp system/password directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107

Export: Release 11.2.0.2.0 - Production on Wed Mar 16 04:46:21 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:"XYYZONE"."TAB_COMM_POINTS_HISTORY":"YMAX"]
ORA-00920: invalid relational operator
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x136b50808     19208  package body SYS.KUPW$WORKER
0x136b50808      8385  package body SYS.KUPW$WORKER
0x136b50808      2935  package body SYS.KUPW$WORKER
0x136b50808      9054  package body SYS.KUPW$WORKER
0x136b50808      1688  package body SYS.KUPW$WORKER
0x1358a19a0         2  anonymous block

Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:"XYYZONE"."TAB_COMM_POINTS_HISTORY":"YMAX"]
ORA-00920: invalid relational operator
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x136b50808     19208  package body SYS.KUPW$WORKER
0x136b50808      8385  package body SYS.KUPW$WORKER
0x136b50808      2935  package body SYS.KUPW$WORKER
0x136b50808      9054  package body SYS.KUPW$WORKER
0x136b50808      1688  package body SYS.KUPW$WORKER
0x1358a19a0         2  anonymous block

Job "SYSTEM"."SYS_EXPORT_TABLE_01" stopped due to fatal error at 04:46:52

[oracle@Oracle112 dmp]$ expdp system/password directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107 version=10.2.0.3

Export: Release 11.2.0.2.0 - Production on Wed Mar 16 04:52:55 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_02":  system/******** directory=dmp dumpfile=xyyzone_table_110316.dp noLOGFILE=y tables=xyyzone.TAB_COMM_DISCOVERY_QAHISTORY,xyyzone.TAB_COMM_DISCOVERY_VOTEHISTORY,xyyzone.TAB_COMM_DISCOVERY_CONSUMER,xyyzone.TAB_COMM_DISCOVERY_SHOPPING network_link=dblink2_112_107 version=10.2.0.3
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:"XYYZONE"."TAB_COMM_POINTS_HISTORY":"YMAX"]
ORA-00920: invalid relational operator
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x136b50808     19208  package body SYS.KUPW$WORKER
0x136b50808      8385  package body SYS.KUPW$WORKER
0x136b50808      2935  package body SYS.KUPW$WORKER
0x136b50808      9054  package body SYS.KUPW$WORKER
0x136b50808      1688  package body SYS.KUPW$WORKER
0x15b980c98         2  anonymous block

Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.56 MB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:"XYYZONE"."TAB_COMM_POINTS_HISTORY":"YMAX"]
ORA-00920: invalid relational operator
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x136b50808     19208  package body SYS.KUPW$WORKER
0x136b50808      8385  package body SYS.KUPW$WORKER
0x136b50808      2935  package body SYS.KUPW$WORKER
0x136b50808      9054  package body SYS.KUPW$WORKER
0x136b50808      1688  package body SYS.KUPW$WORKER
0x15b980c98         2  anonymous block

Job "SYSTEM"."SYS_EXPORT_TABLE_02" stopped due to fatal error at 04:53:25

可以看到，無論是嘗試IMPDP直接匯入，還是嘗試利用EXPDP進行遠端的匯出，都會碰到ORA-39126和ORA-920錯誤。嘗試匯出時指定版本10.2.0.3，問題依舊。

檢查metalink，確認是Bug 10115400。當執行NETWORK_LINK方式的匯入或匯出時，如果遠端資料庫是10.2版本，且通過TABLES引數指定了多個表，就會引發這個問題。11.2的各個版本都可能出現這個問題。Oracle計劃在12.1解決這個問題。

這個錯誤的影響倒是不大，只不過就是麻煩一些，需要在源資料庫匯出對應的表，然後ftp到本地，然後通過impdp匯入。