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

《ora-12518tns监听程序无法分发客户机连接解决办法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ORA-12518 TNS:监听程序无法分发客户机连接 解决办法(2009-11-2010:44:23)转载标签：杂谈分类：oracle数据库ORA-12518:TNS:listenercouldnothandoffclientconnection来源：(http://blog.sina.com.cn/s/blog_5904ea280100g614.html)-ORA-12518 TNS:监听程序无法分发客户机连接 解决办法_大漠孤烟_新浪博客2008-06-2308:57ORA-12518:TNS:listenercouldnothandoff

2、clientconnectionCause:Theprocessofhandingoffaclientconnectiontoanotherprocessfailed.Action:Turnonlistenertracingandre-executetheoperation.Verifythatthelisteneranddatabaseinstanceareproperlyconfiguredfordirecthandoff.Ifproblempersists,callOracleSupport.先试试connect/assysdba,看行不行

3、，如果行的话，再试试connect/@assysdba看看监听配置是否有问题。如果这一步有问题，说明监听这块有问题。1.cmd2.sqlpls/nolog3.connectsys/testassysdba没有问题1.cmd2.sqlplus/nolog3.connectsys/test@testassysdbaORA-12518:TNS:listenercouldnothandoffclientconnection说明监听有问题查到了相关资料如下：http://www.dba-oracle.com/sf_ora_12518_tns_listene

4、r_could_not_hand_off_client_connection.htmThereasonORA-12518isbeingthrowmaybebecauseofDEDICATEDconnectionsbecauseOracle10ghasavalueofPROCESSESisdefaultedat150whichcanbelowerthannecessaryinaproductionsystem.Also,inpre-9iMTS,ORA-12518maybethrowninSHAREDSERVERbecausethedispatche

5、rmayhavereachedthemaximumconnectionvalue,soitdeniesallother.TherearetwosolutionsforORA-12518dependingonwhichsymptomyoumaybeexperiencing.a.FortheDEDICATEDoccurrenceofORA-12518,youwouldneedtotryincreasingthePROCESSESparametersothatitcanhandletheneedednumberofprocesses.Youcanens

6、urethatyouhavetheneededvaluebymonitoringthelistenerlogforORA-12518.Also,notethatbecausethePROCESSESparameterisstatic,thedatabasewillneedtobebounced.b.IfyouareexperiencingORA-12518becauseofasharedserverissue,youfirstwouldneedtousethecommandbelowtoshutdownthedispatcher:SQL>alte

7、rsystemshutdownimmediate'D001';Then,addonnewdispatchers:SQL>altersystemsetDISPATCHERS='(protocol=tcp)(dispatchers=3)';通过以上资料分析得出可能出现问题的原因有两种：一是processes值设的过小，二是需要增加参数DISPATCHERS。考虑到之前经常遇到ora-00020超出最大进程数的问题在安装数据库的时候已经把processes设到800了，为保险起见再showparameterprocessesSQL>showparame

8、terprocess;NAME                                TYPE       VALUE-----