Common Oracle Database TNS Listener Errors ORA-XXX

Client → TNS Resolution → Network → Listener → Database Service → Database Instance

Common Oracle TNS Listener Errors

Error Code	Error Message	Cause	Solution
ORA-12154	TNS: Could not resolve the connect identifier specified	Wrong service alias, missing tnsnames.ora, bad TNS_ADMIN	Verify tnsnames.ora, service name, and run tnsping
ORA-12170	TNS: Connect timeout occurred	Network/firewall issue, listener unreachable	Check network connectivity, firewall, listener status
ORA-12203	TNS: Unable to connect to destination	Invalid host or port	Verify hostname, port, and listener
ORA-12224	TNS: No listener	Listener process not available	Start listener using lsnrctl start
ORA-12500	TNS: Listener failed to start a dedicated server process	Resource shortage or OS limits	Check processes, memory, and database alert log
ORA-12505	Listener does not currently know of SID given in connect descriptor	Incorrect SID specified	Verify SID and register instance with listener
ORA-12514	Listener does not currently know of service requested	Service name not registered	Check SERVICE_NAME, lsnrctl services, and registration
ORA-12516	Listener could not find available handler	Maximum sessions/processes reached	Increase processes parameter or free resources
ORA-12518	Listener could not hand off client connection	Dedicated server process creation failure	Check OS resources and listener logs
ORA-12519	No appropriate service handler found	Database overloaded	Increase session/process limits
ORA-12520	Listener could not find available handler	Shared server issue	Check dispatcher/shared server configuration
ORA-12521	Listener does not currently know of instance requested	Instance not registered	Verify LOCAL_LISTENER and service registration
ORA-12525	TNS: Listener has not received client's request in time allowed	Slow network/client timeout	Check network latency and timeout settings
ORA-12528	Listener: all instances are blocking new connections	Database starting or restricted mode	Open database normally
ORA-12537	TNS: Connection closed	Listener terminated session unexpectedly	Check firewall, listener log, SQLNET parameters
ORA-12541	TNS: No Listener	Listener stopped or wrong port	Run lsnrctl status/start; verify port/host
ORA-12543	TNS: Destination host unreachable	DNS/network routing problem	Verify hostname and network connectivity
ORA-12545	Connect failed because target host/object does not exist	Wrong hostname/IP	Check host name resolution
ORA-12547	TNS: Lost contact	Server process crashed	Review listener log and alert log
ORA-12560	TNS: Protocol adapter error	Oracle services not running or ORACLE_HOME issue	Start Oracle services and verify environment variables
ORA-12564	TNS: Connection refused	Listener rejected connection	Verify listener and service status
ORA-12571	TNS: Packet writer failure	Network interruption	Check firewall, network devices, VPN
ORA-12572	TNS: Packet reader failure	Network corruption	Verify network stability
ORA-12592	TNS: Bad packet	Invalid network packet received	Check client/server version compatibility
ORA-12599	TNS: Cryptographic checksum mismatch	SQLNET encryption mismatch	Align sqlnet.ora encryption settings
ORA-12637	Packet receive failed	Network/SSL issue	Verify SQLNET and network settings
ORA-12638	Credential retrieval failed	Authentication problem	Check OS authentication and SQLNET settings

---

Listener-Specific TNS Errors

TNS Error	Description	Fix
TNS-01101	Listener name not recognized	Verify listener name in listener.ora
TNS-01106	Listener using listener name already exists	Stop duplicate listener
TNS-01150	Listener failed to start	Check port conflicts and configuration
TNS-01151	Missing listener name	Correct listener configuration
TNS-01189	Listener could not authenticate user	Verify listener password/security
TNS-01190	User not authorized to execute command	Use correct OS user or credentials

---

Essential Listener Troubleshooting Commands

# Check listener status

lsnrctl status

# Start listener

lsnrctl start

# Stop listener

lsnrctl stop

# Reload listener

lsnrctl reload

# Check registered services

lsnrctl services

# Test TNS alias

tnsping <service_name>

---

Most Frequently Seen DBA Issues

1. ORA-12154

tnsping ORCL

Check:

• tnsnames.ora
• sqlnet.ora
• TNS_ADMIN

2. ORA-12514

lsnrctl services

Check:

show parameter service_names;

alter system register;

3. ORA-12541

lsnrctl status

lsnrctl start

Verify:

• Host
• Port
• Listener running status

4. ORA-12516 / ORA-12519

show parameter processes;

Increase:

alter system set processes=1000 scope=spfile;

5. ORA-12528

select status from v$instance;

Database may be in:

• STARTUP
• MOUNT
• RESTRICTED mode

---

For a Database Architect/Oracle DBA, the "Top 10" listener errors you encounter in production are typically:

ORA-12154, ORA-12170, ORA-12505, ORA-12514, ORA-12516, ORA-12519, ORA-12520, ORA-12528, ORA-12541, ORA-12545.