|
|
ORA-12518: TNS: listener could not hand off client
connection tips
Oracle Error Tips by Burleson Consulting
|
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-10.2.0.1 in which attempting new connections on
the database throw either ORA-12518 or TNS-12518.
The ORA-12518 appears in
the listener log upon new user connection. Also, check out these MOSC Notes:
- ORA-12518 / TNS-12518 Troubleshooting [ID 556428.1]
- TROUBLESHOOTING GUIDE TNS-12518 TNS listener could not hand off client connection [ID 550859.1]