Connections Via the Listener Fail With Either ORA-12505 or ORA-12514
Last updated on AUGUST 24, 2017
Applies to:Oracle Net Services - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Oracle Net Services - Version 22.214.171.124.0 to 126.96.36.199 [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:
- Network reconfiguration
- Listener endpoint reconfiguration
- Static registration entries reconfiguration/deletion
- System hostname changed
Listener status shows an IP address as the binding point although it has been configured with a hostname, e.g.:
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oradb1.yourdomain.com)(PORT=1521)))
STATUS of the 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
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...
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