Connections Via the Listener Fail With Either ORA-12505 or ORA-12514 (Doc ID 437737.1)

Last updated on OCTOBER 31, 2016

Applies to:

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


Symptoms

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"

Changes

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 10.1.0.3.0 - Production on 26-JUN-2007 14:42:30

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb1.yourdomain.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.1.0.3.0 - 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...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

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

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