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 10.2.0.2 to 12.2.1.3.0 [Release 10.2 to 12.2]Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |