Last updated on JUNE 18, 2010
Applies to:Oracle Net Services - Version: 10.2.0.1
Information in this document applies to any platform.
The problem documented here would occur only on a Microsoft Windows platform.
At the command line, Lsnrctl start yields the following stack:
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error
Another possible symptom of this issue is that the listener starts successfully but Lsnrctl commands fail with the same error stack. i.e. Lsnrctl status, services, etc.
The failure to start the TNS Listener using the Control Panel service shows a fault in "msvcr71.dll":
Faulting application TNSLSNR.EXE, version 0.0.0.0, faulting module msvcr71.dll, version 7.10.3052.4, fault address 0x00010513.
Changing the "Log On" credentials from a DOMAIN account to Local System in the Windows Control Panel service for the ORACLE_HOME TNS Listener may allow the listener to start but is not a viable solution.
Also, issuing the net start <Oracle_HomeTNSListener> at the command line works to start the listener but the lsnrctl utility cannot be used to administer the running listener.
C:\Oracle\Product\10.2.0\Db_1\bin>net start OracleOraDb10g_home1TNSListener
The OracleOraDb10g_home1TNSListener was started successfully
Obtain the label for the service from the Control Panel Services list.
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