Windows :Unable To Start Listener and reports Failed to start service error 0, TNS-12560: TNS: Protocol adapter error and TNS-12557:TNS:protocol adapter not loadable (Doc ID 2065022.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Net Services - Version 10.2.0.2 and later
Generic Windows
Unable to start Windows Listeners and ends with a similar error :

Symptoms

Unable to start Windows Listeners and ends with a similar error :

lsnrctl start LISTENER

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 02-JUL-2016 07:47:45

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb11g_home1TNSListenerLISTENER>, error 1060.
Failed to start service, error 0.
TNS-12560: TNS:protocol adapter error

 or

 

lsnrctl start LISTENER
Starting tnslsnr:

TNS-12557:TNS:protocol adapter not loadable
TNS-12560:TNS:protocol adapter error
TNS-00527:Protocol Adapter not loadable

 

 

Changes

 The environmental Variables of Windows in Advanced System Settings always takes precedence over setting/exporting environmental variables via command prompt.

Cause

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