ORA-12518错误

無限追云

各位兄弟好，请教个问题

环境：
OS:Windows 2003    db Oracle10g

是个档案查询系统，20多个人使用。这几天最近老是出 ORA-12518错误。

processes为150，session为20多。这个session数也不高呀。

我重启了数据库和监听，这时应用系统的账号也登陆不进去了。

监听的状态是正常的，conn sys/xxx@XXX  as sysdba也能正常登陆

下面是监听的部分日志：

04-11月-2011 15:50:16 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu)(CID=(PROGRAM=c:\j2sdk1.4.2_06\bin\java.exe)(HOST=366SERVER1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3711)) * establish * docu * 0
04-11月-2011 15:50:16 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu)(CID=(PROGRAM=c:\j2sdk1.4.2_06\bin\java.exe)(HOST=366SERVER1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3712)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:51:37 * service_update * docu * 0
04-11月-2011 15:51:37 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\bin\emagent.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3902)) * establish * docu * 0
04-11月-2011 15:51:37 * service_update * docu * 0
04-11月-2011 15:51:37 * service_update * docu * 0
04-11月-2011 15:51:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu)(CID=(PROGRAM=c:\j2sdk1.4.2_06\bin\java.exe)(HOST=366SERVER1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=1588)) * establish * docu * 0
04-11月-2011 15:51:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu)(CID=(PROGRAM=c:\j2sdk1.4.2_06\bin\java.exe)(HOST=366SERVER1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=1594)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:52:59 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\bin\emagent.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=1900)) * establish * docu * 0
04-11月-2011 15:52:59 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=2116)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:54:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(sid=docu)(server=dedicated)) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=2250)) * establish * docu * 0
04-11月-2011 15:54:20 * ping * 0
04-11月-2011 15:54:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=docu)(CID=(PROGRAM=c:\j2sdk1.4.2_06\bin\java.exe)(HOST=366SERVER1)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3304)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:55:41 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3309)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:55:41 * service_update * docu * 0
04-11月-2011 15:57:02 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\bin\emagent.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=3735)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:58:23 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=4574)) * establish * docu * 0
04-11月-2011 15:58:23 * service_update * docu * 0
04-11月-2011 15:58:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=docu)) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=1347)) * establish * docu * 12518
TNS-12518: TNS: 监听程序无法分发客户机连接
TNS-12560: TNS: 协议适配器错误
04-11月-2011 15:59:29 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=1874)) * establish * docu * 0
04-11月-2011 15:59:29 * service_update * docu * 0
04-11月-2011 15:59:29 * services * 12502
TNS-12502: TNS: 监听程序没有从客户机收到 CONNECT_DATA
04-11月-2011 15:59:29 * service_died * docu * 12537
04-11月-2011 15:59:29 * (CONNECT_DATA=(SID=docu)(CID=(PROGRAM=d:\oracle10\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=366SERVER1)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=20.14.20.16)(PORT=2170)) * establish * docu * 0

谢谢了

wkc168

应该是超过了SESSION才报这个错的 检测下 看下trace  

加大SESSION 跟process

kevinlin.ora

lsnrctl status listener_name
lsnrctl service listener_name

alert.log

方便的话，做个trace

[ 本帖最后由 kevinlin.ora 于 2011-11-4 18:34 编辑 ]