12 积分	0 好友	2 主题

发消息

TNS-12518 错误总是不定时出现

1^#

发表于 2012-8-9 10:52:40 | 查看: 6369| 回复: 4

环境：

OS:Windows 2008  sp 2 16g内存  db Oracle10g 10.2.0.4

06-AUG-2012 16:56:09 * (CONNECT_DATA=(SID=magz)(SERVER=DEDICATED)(CID=(PROGRAM=D:\tools\PLSQL7.1\PlSqlDev.exe)(HOST=NBU)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=50499)) * establish * magz * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
06-AUG-2012  16:57:42 * (CONNECT_DATA=(SID=magz)(SERVER=DEDICATED)(CID=(PROGRAM=D:\tools\PLSQL7.1\PlSqlDev.exe)(HOST=NBU)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=50501)) * establish * magz * 0
06-AUG-2012 16:58:02 * service_register * magz * 0
=============================================================================================
08-AUG-2012 14:35:27 * (CONNECT_DATA=(SID=magz)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=3202)) * establish * magz * 12518
TNS-12518: TNS:listener could not hand off client connection
NL-00506: stream write failed
  NL-00232: error in setting file read or write offset
NL-00506: stream write failed
NL-00232: error in setting file read or write offset
   TNS-12560: TNS:protocol adapter error
   SNL-00038: snlftel: error finding file position

08-AUG-2012 14:35:28 * (CONNECT_DATA=(SID=magz)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=3224)) * establish * magz * 0
08-AUG-2012 14:35:28 * (CONNECT_DATA=(SID=magz)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.1)(PORT=3229)) * establish * magz * 0
08-AUG-2012 14:35:30 * service_update * magz * 0

SQL> show parameter sessions

NAME                               TYPE       VALUE
------------------------------------ ----------- ----------------------------
sessions                            integer    170

SQL> show parameter process

NAME                               TYPE       VALUE
------------------------------------ ----------- --------------------
processes                         integer    150

SQL> select count(*) from v$session;

  COUNT(*)
----------
      98

session 数一般在 90 ~120 之间，感觉不是process数不够导致的，在tomcat 日志中也没有报错，估计是tomcat自己重连就可以了，这个TNS-12518 错误需要如何定位

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-8-9 13:35:02

TNS-12518: TNS:listener could not hand off client connection
NL-00506: stream write failed
  NL-00232: error in setting file read or write offset
NL-00506: stream write failed
NL-00232: error in setting file read or write offset
   TNS-12560: TNS:protocol adapter error
   SNL-00038: snlftel: error finding file position

cpu 和内存的情况如何，这个错误不常见感觉和os 有关系，尝试重启windows 是否有安装杀毒软件

回复只看该作者道具举报