最近前台应用日志中不断出现TNS-12519: TNS:no appropriate service handler found的错误,检查后台listener.log文件,确实不段出现该错误。
TNS-12519: TNS:no appropriate service handler found
[oracle@localhost arch]$ oerr TNS 12519
12519, 00000, "TNS:no appropriate service handler found"
// *Cause: The listener could not find any available service handlers that
// are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener, and are accepting connections.
出现如上问题的时候,通过
lsnrctl services观察到blocked
[oracle@localhost arch]$ lsnrctl services
LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 28-NOV-2005 16:26:14
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "pp" has 1 instance(s).
Instance "pp", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:47616853 refused:0 state:blocked
LOCAL SERVER
Service "ppXDB" has 1 instance(s).
Instance "pp", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:188 refused:0 current:3 max:1002 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32768))
The command completed successfully
sql>select count(*) from v$session;
-----
216
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
processes integer 500
linux内核信息:
[root@localhost root]# sysctl -a|grep sem
kernel.sem = 350 32000 100 128
刚开始为
kernel.sem = 250 32000 100 128
以为是信号量设置小了,所以修改到了350
还是报相同的错误。
目前processes 设的为500(应该足够了),比总共的session数量多很多,所以processes 应该不是问题(metalink里面建议增加processes 参数)
各位老大们帮看看
TNS-12519: TNS:no appropriate service handler found
[oracle@localhost arch]$ oerr TNS 12519
12519, 00000, "TNS:no appropriate service handler found"
// *Cause: The listener could not find any available service handlers that
// are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener, and are accepting connections.
出现如上问题的时候,通过
lsnrctl services观察到blocked
[oracle@localhost arch]$ lsnrctl services
LSNRCTL for Linux: Version 9.2.0.5.0 - Production on 28-NOV-2005 16:26:14
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "pp" has 1 instance(s).
Instance "pp", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:47616853 refused:0 state:blocked
LOCAL SERVER
Service "ppXDB" has 1 instance(s).
Instance "pp", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:188 refused:0 current:3 max:1002 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=32768))
The command completed successfully
sql>select count(*) from v$session;
-----
216
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
processes integer 500
linux内核信息:
[root@localhost root]# sysctl -a|grep sem
kernel.sem = 350 32000 100 128
刚开始为
kernel.sem = 250 32000 100 128
以为是信号量设置小了,所以修改到了350
还是报相同的错误。
目前processes 设的为500(应该足够了),比总共的session数量多很多,所以processes 应该不是问题(metalink里面建议增加processes 参数)
各位老大们帮看看
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28419/viewspace-613754/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28419/viewspace-613754/