关于tns连接的问题
各位大虾,小弟最近遇到一个很头痛的问题,一天数据库重新启动了,但是没有关闭listener,导致一个客户端老在尝试连接,但都报TNS-12518 TNS:listener could not hand off client connection 错误,但是数据库起来后其他客户都可以连接上数据库,就是之前一直在尝试连接的客户端连接不上数据库,难道oracle有一个锁定某个客户端连接的profile或者是参数之类的吗?不是很清楚,不知哪儿大虾可以指点一下,谢谢,下面是相关的信息:
From the logfile:
11-APR-2008 02:30:28 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1633)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure

TNS-12560: TNSrotocol adapter error

TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58894)) * establish * edwd * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=reportc)(GLOBAL_NAME=reportc.cert.gai.com)(CID=(PROGRAM=)(HOST=cvgsq01)(USER=pmmgrc))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.16.20)(PORT=50579)) * establish * reportc * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58901)) * establish * edwd * 0
11-APR-2008 02:30:29 * (CONNECT_DATA=(SID=reportc)(GLOBAL_NAME=reportc.cert.gai.com)(CID=(PROGRAM=)(HOST=cvgsq01)(USER=pmmgrc))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.16.20)(PORT=50580)) * establish * reportc * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.48.195.4)(PORT=58899)) * establish * edwd * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1632)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure

TNS-12560: TNSrotocol adapter error

TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer
11-APR-2008 02:30:31 * service_update * edwd * 0
11-APR-2008 02:30:31 * (CONNECT_DATA=(SID=edwd)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.127.64.144)(PORT=1624)) * establish * edwd * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNSacket writer failure

TNS-12560: TNSrotocol adapter error

TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer