ORA-12518: TNS: listener could not hand off client connection
Note:
Starting in 11gR2, the listener log is not activated by default. You have to turn on listener logging: logging_listener_name=on
Oracle docs note this about ORA-12518:
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.
ORA-12518 has been known to occur in Oracle Net Services version 9.2.0.5-11.2.0.1 in which attempting new connections on the database throw either ORA-12518 or TNS-12518.ORA-12518 appears in the listener log upon new user connection.
来自orace.群员的提问摘录。
