ORA-12518, TNS:listener could not hand off client connection
来源：互联网 发布：汽车试驾软件 编辑：程序博客网 时间：2024/05/16 11:23
spring中用jdbc去连接oracle的时候，出现错误：
ORA-12518, TNS:listener could not hand off client connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
原因一般为：客户连接到监听器后，监听器把客户重定向到调度程序端口，由于操作系统问题，这些连接会被拒绝。
要解决这个问题，只需要在LISTENER.ORA的头部加入这一行DIRECT_HANDOFF_TTC_LISTENER = OFF即可。
在listener.ora文件加上一句 DIRECT_HANDOFF_TTC_LISTENER = OFF
然后重启监听服务
lsnrctl stop
lsnrctl start
- ORA-12518, TNS:listener could not hand off client connection
- ORA-12518: TNS:listener could not hand off client connection
- ORA-12518, TNS:listener could not hand off client connection
- ORA-12518: TNS:listener could not hand off client connection
- ORA-12518: TNS:listener could not hand off client connection .
- 【Oracle】ORA-12518, TNS:listener could not hand off client connection
- TNS-12518:TROUBLESHOOTING GUIDE TNS-12518 TNS listener could not hand off client connection
- [转自Oracle官方技术博客]SLES12 SP2上遇到ORA-12518: TNS:listener could not hand off client connection
- TNS-12518: TNS:listener could not hand off client connection & Broken pipe
- orcale数据库，使用weblogic数据源，点击几个功能后报异常ORA-12518, TNS:listener could not hand off client connection
- 启动报Cannot get connection for url jdbc xxxx listener could not hand off client co
- ORA-12520: TNS:listener could not find available handler
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently
- ora-12516 tns listener could not find available handler with matching protocol
- ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect 问题的解决！
- RAC 中 ORA-12516: TNS: listener could not find available handler with matching protocol stack
- 水晶报表
- java_23种设计模式之工厂方法模式
- S 1.3 barn1 C语言
- NSNotificationCenter的使用
- 简单计算器
- ORA-12518, TNS:listener could not hand off client connection
- ndroid平台的Action Bar
- UIlable
- C# Form.Show()方法 的一些线程内部特性
- Android界面设计基础：控件焦点4个步骤
- C#操作txt文件
- Android访问WebService
- 获取html页面传过来的值
- 北理工虚拟现实作业-OpenGL下实现3D Max模型的导入
