Windows 2003: TCP Loopback Connections Fail Intermittently with ORA-12541 TNS: No Listener
Last updated on MAY 20, 2015
Applies to:Oracle Net Services - Version 10.2.0.5 to 220.127.116.11 [Release 10.2 to 11.2]
Information in this document applies to any platform.
The problem documented here is limited to the Windows 2003 SP2 platform. It is not relevant to this kind of problem on any other platform. The problem documented here would NEVER occur on a remote client. It is strictly limited to TCP loopback connections or when the client and database server/listener are on the same PC.
Oracle client connections, where the client resides on the same server as the listener, are intermittently failing with the following error:
ORA-12541 TNS: No listener
Additionally, the TNSPING command would also yield the same error intermittently and frequently:
TNS-12541 TNS: No listener
An Oracle Net client trace would reveal the following underlying TCP errors:
The Windows registry setting for TcpTimedWaitDelay defaults to 240 seconds or 4 minutes.
There would not necessarily be any changes to this environment.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms