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

 

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