TNS-12547: TNS-12560: TNS-00517: 错误分析

最新推荐文章于 2021-04-10 04:45:51 发布

James_Yao007

最新推荐文章于 2021-04-10 04:45:51 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/jamesyao008/article/details/45062559

本文记录了遇到Oracle TNS连接拒绝错误111的排查过程，通过检查Linux系统和监听状态，发现并解决了主机名解析问题。最终成功启动监听并显示所有服务实例处于READY状态。

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

记录一下：

[oracle@xtjc4 oradata]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 15-APR-2015 17:32:44

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Starting /u01/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /u01/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/11.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xtjc4.test.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xtjc4)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Conne