May22

TNS-12602: TNS: Connection Pooling limit reached 的解决

Posted in Oracle, 数据库管理, skywalker, 1,583 views

今天给一个10G的库imp的时候，发现时常出现TNS错误，listener.log里记录为：

TNS-12518: TNS:listener could not hand off client connection
TNS-12564: TNS:connection refused
TNS-12602: TNS: Connection Pooling limit reached
TNS-00524: Current operation is still in progress
Linux Error: 115: Operation now in progress

metalink上对TNS－12602做了详细的描述
它可能会发生在10.2.0.1至10.2.0.3的所有平台上
导致这一错误的原因在于：

(1) There is insufficient number of server processes that
the listener can handoff connections to for the actual rate of
connection requests
(2) There is a performance problem in the servers and/or listener
effectively decreasing the rate at which the connection requests
can be handled

解决方法：

增加初始的dispatchers数量
首先关闭Dispatcher：
SQL> alter system shutdown immediate 'D001';
添加新的Dispatcher
SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=10)';

Blogged with the Flock Browser

Tags: , ,

Related posts:

  1. SHARED转为DEDICATED及ORA-12519错误
  2. Listerner.ora写法问题导致的监听器启动失败
  3. 打包安装oracle
  4. ORA-00600: internal error code, arguments: [kjzcreaprqhq1]
  5. oralce10g shrink

Leave a comment | Trackback 这篇文章还没有评论.

我来写两句评论.