oracle11g ora 12518,C/S结构案例分析 ORA-12518: TNS:listener could not hand off c

最新推荐文章于 2024-02-28 11:15:41 发布

Yutin俞廷

最新推荐文章于 2024-02-28 11:15:41 发布

阅读量454

点赞数

文章标签： oracle11g ora 12518

天萃荷净

用户现场有一套Oracle 11G数据库，专用和共享模式两套，应用为浪潮财务系统，产品结构为C/S，操作系统为Redhat

客户端连接数据库服务器报错：

ORA-12518: TNS:listener could not hand off client connection

Oracle研究中心分析原因为客户端增多，原有数据库设置不够，导致连接出现：无法分发客户端连接的异常。

查到官方相关资料如下：

http://www.dba-oracle.com/sf_ora_12518_tns_listener_could_not_hand_off_client_connection.htm

The reason ORA-12518 is being throw may be because of DEDICATED connections because Oracle 10g has a value of PROCESSES is defaulted at 150 which can be lower than necessary in a production system. Also, in pre-9i MTS, ORA-12518 may be thrown in SHARED SERVER because the dispatcher may have reached the maximum connection value, so it denies all other.

There are two solutions for ORA-12518 depending on which symptom you may be experiencing.

a.For the DEDICATED occurrence of ORA-12518, you would need to try increasing the PROCESSES parameter so that it can handle the needed number of processes. You can ensure that you have the needed value by monitoring the listener log for ORA-12518. Also, note that because the PROCESSES parameter is static, the database will need to be bounced.

b.If you are experiencing ORA-12518 because of a shared server issue, you first would need to use the command below to shutdown the dispatcher:

SQL> alter system shutdown immediate 'D001';

Then, add on new dispatchers:

SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=3)';

解决方案：

第一步：调整process和session值

1. 检查process和session是否够用。

a)使用plsql连接到oracle，查看process进程数：

select count(*) from v$process; --取得数据库目前的进程数。

select value from v$parameter where name = 'processes'; --取得进程数的上限。

b)查看session会话数：

select count(*) from v$session; --取得数据库目前的会话数。