ORA-12518TNS监听程序无法分发客户机连接解决办法

ORA 12518ORA 12518 TNS TNS 监听程序无法分发客户机连接监听程序无法分发客户机连接 解决解决 办法办法 2009 11 20 10 44 23 转载 标签 杂谈 分类 oracle 数据库 ORA 12518 TNS listener could not hand off client connection 2008 06 23 08 57 ORA 12518 TNS listener could not hand off client connection Cause The process of handing off a client connection to another process failed Action Turn on listener tracing and re execute the operation Verify that the listener and database instance are properly configured for direct handoff If problem persists call Oracle Support 先试试 connect as sysdba 看行不行 如果行的话 再试试 connect as sysdba 看看监听配置是否有问题 如果这一步有问题 说明监听这块有问题 1 cmd 2 sqlpls nolog 3 connect sys test as sysdba 没有问题 1 cmd 2 sqlplus nolog 3 connect sys test test as sysdba ORA 12518 TNS listener could not hand off client connection 说明监听有问题 查到了相关资料如下 http www dba tion 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 通过以上资料分析得出可能出现问题的原因有两种 一是 processes 值设的过 小 二是需要增加参数 DISPATCHERS 考虑到之前经常遇到 ora 00020 超出最大进程数的问题在安装数据库的时候已 经把 processes 设到 800 了 为保险起见再 show parameter processes SQL show parameter process NAME TYPE VALUE aq tm processes integer 0 db writer processes integer 1 gcs server processes integer 0 job queue processes integer 10 log archive max processes integer 2 processes integer 1000 再查进程数 SQL select count from v session COUNT 224 所以最后得出结论应该不是 processes 的问题 应该用 b 方法来解决 1 connect sys test as sysdba 2 show parameters dispatchers NAME TYPE VALUE dispatchers string protocol tcp service oracle10 xdb max dispatchers integer 5 SQL alter system set dispatchers protocol tcp dispatchers 3 service oracle10 xdb