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
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
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
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 29-JUN-2015 11:08:27
Copyright (c) 1991, 2005, Oracle.
[oracle@******* log]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 29 15:46:01 2015
Copyright (c) 1982, 2005, Oracle.
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
------------------------------------ ----------- ------------------------------
hi_shared_memory_address
max_shared_servers
shared_memory_address
shared_pool_reserved_size
shared_pool_size
shared_server_sessions
shared_servers
SQL> show parameter dispa
NAME
------------------------------------ ----------- ------------------------------
dispatchers
max_dispatchers
SQL> alter system set shared_servers=5;
System altered.
SQL>
System altered.
SQL> show parameter dispatchers
NAME
------------------------------------ ----------- ------------------------------
dispatchers
max_dispatchers