ORA-12547: TNS:lost contact

最新推荐文章于 2021-11-12 14:30:21 发布

Snowballl

最新推荐文章于 2021-11-12 14:30:21 发布

阅读量697

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle解决方案实现

本文链接：https://blog.youkuaiyun.com/minwang593/article/details/17393411

oracle解决方案实现专栏收录该内容

43 篇文章

订阅专栏

本文记录了一种常见的Oracle数据库错误ORA-12547:TNS:lostcontact的现象及可能的原因。此错误通常与网络连接不稳定有关，例如重复的数据包接收等网络问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

现象：

*
ERROR at line 1:
ORA-12547: TNS:lost contact
ORA-06512: at "QIM.PRO_TMP_KANBANDATA_JN", line 6
ORA-06512: at "QIM.PRO_TMP_KANBANDATA_JN", line 23
ORA-06512: at line 2

由于网络问题引起的。如下：

64 bytes from 10.70.70.3: icmp_seq=189 ttl=61 time=22.1 ms
64 bytes from 10.70.70.3: icmp_seq=189 ttl=61 time=23.4 ms (DUP!)
64 bytes from 10.70.70.3: icmp_seq=190 ttl=61 time=22.7 ms
64 bytes from 10.70.70.3: icmp_seq=190 ttl=61 time=24.1 ms (DUP!)
64 bytes from 10.70.70.3: icmp_seq=191 ttl=61 time=23.8 ms
64 bytes from 10.70.70.3: icmp_seq=191 ttl=61 time=25.7 ms (DUP!)
64 bytes from 10.70.70.3: icmp_seq=192 ttl=61 time=22.8 ms
64 bytes from 10.70.70.3: icmp_seq=192 ttl=61 time=24.3 ms (DUP!)
64 bytes from 10.70.70.3: icmp_seq=193 ttl=61 time=22.3 ms
64 bytes from 10.70.70.3: icmp_seq=193 ttl=61 time=23.6 ms (DUP!)