My Oracle Support Banner

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

Last updated on JUNE 08, 2023

Applies to:

Oracle Net Services - Version to [Release 10.2 to 12.2]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Generic Windows
Unable to start Windows Listeners and ends with a similar error :


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

lsnrctl start LISTENER

LSNRCTL for 64-bit Windows: Version - 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



lsnrctl start LISTENER
Starting tnslsnr:

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




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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.