impdp使用NETWORK_LINK的两个故障
1.Impdp With NETWORK_LINK Runs Very Slowly at Estimate Stage [ID 416238.1]
impdp的时候，进程卡在估计数据大小的地方
Estimate in progress using STATISTICS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
这是由于运行impdp的库设置了cursor_sharing=force
解决办法是修改回exact。
竟然110203了都还能遇到cursor_sharing的BUG
2.Errors ORA-39126 ORA-4052 ORA-12154 On DataPump Import Using NETWORK_LINK [ID 1301472.1]
进程调用KUPW$WORKER.POST_MT_INIT时，在SELECT SYS.KUPM$MCP.GET_ENDIANNESS@TMS FROM SYS.DUAL报错
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.POST_MT_INIT [SELECT SYS.KUPM$MCP.GET_ENDIANNESS@dwqa FROM SYS.DUAL]
ORA-04052: error occurred when looking up remote object SYS.KUPM$MCP@DWQA
ORA-00604: error occurred at recursive SQL level 3
ORA-12154: TNS:could not resolve the connect identifier specified
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
0x45559bc50 19208 package body SYS.KUPW$WORKER
0x45559bc50 8385 package body SYS.KUPW$WORKER
0x45559bc50 2182 package body SYS.KUPW$WORKER
0x45559bc50 1474 package body SYS.KUPW$WORKER
0x45964d818 2 anonymous block
报错的原因为创建导入SCHEMA的DBLINK失败不通无法访问
特别的RAC数据库，要保证tnsnames.ora在两个节点都迁移过来了
解决办法是迁移tnsnames.ora
另外还加了CLUSTER=N让其只在一个节点运行
PS：
记录一下impdp with network_link导数据
impdp system/system_0130 network_link=dp_link logfile=impdpPER_HRMS.log directory=dpdata schemas=PER_HRMS CLUSTER=N PARALLEL=4
impdp的时候，进程卡在估计数据大小的地方
Estimate in progress using STATISTICS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
这是由于运行impdp的库设置了cursor_sharing=force
解决办法是修改回exact。
竟然110203了都还能遇到cursor_sharing的BUG
2.Errors ORA-39126 ORA-4052 ORA-12154 On DataPump Import Using NETWORK_LINK [ID 1301472.1]
进程调用KUPW$WORKER.POST_MT_INIT时，在SELECT SYS.KUPM$MCP.GET_ENDIANNESS@TMS FROM SYS.DUAL报错
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.POST_MT_INIT [SELECT SYS.KUPM$MCP.GET_ENDIANNESS@dwqa FROM SYS.DUAL]
ORA-04052: error occurred when looking up remote object SYS.KUPM$MCP@DWQA
ORA-00604: error occurred at recursive SQL level 3
ORA-12154: TNS:could not resolve the connect identifier specified
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
0x45559bc50 19208 package body SYS.KUPW$WORKER
0x45559bc50 8385 package body SYS.KUPW$WORKER
0x45559bc50 2182 package body SYS.KUPW$WORKER
0x45559bc50 1474 package body SYS.KUPW$WORKER
0x45964d818 2 anonymous block
报错的原因为创建导入SCHEMA的DBLINK失败不通无法访问
特别的RAC数据库，要保证tnsnames.ora在两个节点都迁移过来了
解决办法是迁移tnsnames.ora
另外还加了CLUSTER=N让其只在一个节点运行
PS：
记录一下impdp with network_link导数据
impdp system/system_0130 network_link=dp_link logfile=impdpPER_HRMS.log directory=dpdata schemas=PER_HRMS CLUSTER=N PARALLEL=4
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-746537/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
方便查看11g错误日志的脚本（新）
下一篇：
提高访问MOS的速度
请登录后发表评论
登录
全部评论
