TNS-12547 一次监听意外终止的启示

最新推荐文章于 2021-04-15 18:59:45 发布

茄肥猫

最新推荐文章于 2021-04-15 18:59:45 发布

阅读量971

点赞数

分类专栏： ORACLE 文档

本文链接：https://blog.csdn.net/lively1982/article/details/16804879

版权

ORACLE 文档专栏收录该内容

224 篇文章 1 订阅

订阅专栏

今天业务部门打电话说BI用不了了，我连了一下。报错 TNS丢失

没人动，好好的TNS怎么会停了呢

看看监听

-bash-3.2$lsnrctl

lsnrctl>status

看到监听居然停了

lsnrctl>start

监听起来了

找找原因，死也要死的明白些

-bash-3.2$ cd /oracle/product/10.2.0/network/log

-bash-3.2$ ls

bidi.log bi.log listener.log sqlnet.log

-bash-3.2$ tail -n 20 sqlnet.log
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.47)(PORT=50892))

***********************************************************************
Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
Time: 18-11鏈2013 14:53:17
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
-bash-3.2$

除了TNS-12547: TNS:lost contact

没什么有价值的信息，百度一下TNS-12547：

有的说是监听的日志文件太大了引起的

-bash-3.2$ ll -h
total 2.8G
-rw-r----- 1 oracle dba 1.7K May 26 2011 bidi.log
-rw-r----- 1 oracle dba 17K May 26 2011 bi.log
-rw-r----- 1 oracle dba 2.8G Nov 18 15:36 listener.log
-rw-r----- 1 oracle dba 3.3M Nov 18 14:53 sqlnet.log

我了个去！！竟然有2.8GB

-bash-3.2$rm listener.log
-bash-3.2$touch listener.log
-bash-3.2$lsnrctl start

解决收工