Connections Via the Listener Fail With Either ORA-12505 or ORA-12514

(Doc ID 437737.1)

Last updated on AUGUST 24, 2017

Applies to:

Oracle Net Services - Version to [Release 11.2]
Oracle Net Services - Version to [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 5-APR-2013***


The database is started but remote clients are unable to connect via the listener.  Attempts to connect fail with any one of the following errors:


ORA-12505 TNS:listener could not resolve SID given in connect descriptor
TNS-12505  TNS:listener could not resolve SID given in connect descriptor                  

ORA-12514  TNS:listener could not resolve SERVICE_NAME given in connect descriptor          
TNS-12514   TNS:listener could not resolve SERVICE_NAME given in connect descriptor

A check of lsnrctl services reveals that no services are registered.  The output might state:  "The listener
supports no services"


One of the following:

Listener status shows an IP address as the binding point although it has been configured with a hostname, e.g.:

LSNRCTL for Linux: Version - Production on 26-JUN-2007 14:42:30

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

Alias                     listener
Version                   TNSLSNR for Linux: Version - Production
Start Date                26-JUN-2007 13:36:52
Uptime                    0 days 1 hr. 5 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/app/OraHome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/app/OraHome_1/network/log/listener.log
Listening Endpoints Summary...

Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


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