Listener服务异常停止故障

最新推荐文章于 2023-04-13 22:49:00 发布

babymouse1212

最新推荐文章于 2023-04-13 22:49:00 发布

阅读量1.4k

点赞数

本文链接：https://blog.csdn.net/babymouse1212/article/details/71079121

版权

Sym:

用着用着监听服务停掉了，需要重新启动，查看listener.log报错信息如下：

N-2015 09:43:13 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49500)) * establish * ****** * 0
29-JUN-2015 09:43:13 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49501)) * establish * ****** * 0
29-JUN-2015 09:43:22 * establish * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
29-JUN-2015 09:43:22 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49514)) * establish * ****** * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
29-JUN-2015 09:43:23 * service_update * ****** * 0
29-JUN-2015 09:44:14 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49536)) * establish * ****** * 0
29-JUN-2015 09:44:14 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49535)) * establish * ****** * 0
29-JUN-2015 09:44:14 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49534)) * establish * ****** * 0
29-JUN-2015 09:44:14 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49539)) * establish * ****** * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNS:packet writer failure
TNS-12560: TNS:protocol adapter error
   TNS-00530: Protocol adapter error
    Linux Error: 104: Connection reset by peer
29-JUN-2015 09:44:14 * (CONNECT_DATA=(SID=******)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.*)(PORT=49540)) * establish * ****** * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2015 11:08:27

[oracle@******* log]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 29 15:46:01 2015

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter shared

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 26004684
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1
SQL> show parameter dispa

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=******                                                 XDB)
max_dispatchers                      integer
SQL> alter system set shared_servers=5;

System altered.

SQL> alter system set dispatchers='(PROTOCOL=TCP)(SERVICE=*****XDB)(DISP=3)';

System altered.

SQL> show parameter dispatchers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP)(SERVICE=******                                                 XDB)(DISP=3)
max_dispatchers                      integer