Dead Connection Detection (DCD) not Working for Windows Platform
Last updated on OCTOBER 27, 2016
Applies to:Oracle Net Services - Version: 10.2.0.2.0 to 10.2.0.3.6 - Release: 10.2 to
Dead Connection Dectection (DCD) parameter SQLNET.EXPIRE_TIME is set to a value larger that 1 minute.
Background processes for connections where the client is gone are not getting cleaned up. Valid connections are getting timed out, due to the probe packet not being sent.
Another symptom, although less likely, is that client connections via the listener may start to fail with ORA-12518 errors:
TNS:listener could not hand off client connection
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms