Monday, August 10, 2026

Common Oracle Database TNS Listener Errors ORA-XXX


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

Common Oracle TNS Listener Errors

Error CodeError MessageCauseSolution
ORA-12154TNS: Could not resolve the connect identifier specifiedWrong service alias, missing tnsnames.ora, bad TNS_ADMINVerify tnsnames.ora, service name, and run tnsping
ORA-12170TNS: Connect timeout occurredNetwork/firewall issue, listener unreachableCheck network connectivity, firewall, listener status
ORA-12203TNS: Unable to connect to destinationInvalid host or portVerify hostname, port, and listener
ORA-12224TNS: No listenerListener process not availableStart listener using lsnrctl start
ORA-12500TNS: Listener failed to start a dedicated server processResource shortage or OS limitsCheck processes, memory, and database alert log
ORA-12505Listener does not currently know of SID given in connect descriptorIncorrect SID specifiedVerify SID and register instance with listener
ORA-12514Listener does not currently know of service requestedService name not registeredCheck SERVICE_NAME, lsnrctl services, and registration
ORA-12516Listener could not find available handlerMaximum sessions/processes reachedIncrease processes parameter or free resources
ORA-12518Listener could not hand off client connectionDedicated server process creation failureCheck OS resources and listener logs
ORA-12519No appropriate service handler foundDatabase overloadedIncrease session/process limits
ORA-12520Listener could not find available handlerShared server issueCheck dispatcher/shared server configuration
ORA-12521Listener does not currently know of instance requestedInstance not registeredVerify LOCAL_LISTENER and service registration
ORA-12525TNS: Listener has not received client's request in time allowedSlow network/client timeoutCheck network latency and timeout settings
ORA-12528Listener: all instances are blocking new connectionsDatabase starting or restricted modeOpen database normally
ORA-12537TNS: Connection closedListener terminated session unexpectedlyCheck firewall, listener log, SQLNET parameters
ORA-12541TNS: No ListenerListener stopped or wrong portRun lsnrctl status/start; verify port/host 
ORA-12543TNS: Destination host unreachableDNS/network routing problemVerify hostname and network connectivity
ORA-12545Connect failed because target host/object does not existWrong hostname/IPCheck host name resolution
ORA-12547TNS: Lost contactServer process crashedReview listener log and alert log
ORA-12560TNS: Protocol adapter errorOracle services not running or ORACLE_HOME issueStart Oracle services and verify environment variables
ORA-12564TNS: Connection refusedListener rejected connectionVerify listener and service status
ORA-12571TNS: Packet writer failureNetwork interruptionCheck firewall, network devices, VPN
ORA-12572TNS: Packet reader failureNetwork corruptionVerify network stability
ORA-12592TNS: Bad packetInvalid network packet receivedCheck client/server version compatibility
ORA-12599TNS: Cryptographic checksum mismatchSQLNET encryption mismatchAlign sqlnet.ora encryption settings
ORA-12637Packet receive failedNetwork/SSL issueVerify SQLNET and network settings
ORA-12638Credential retrieval failedAuthentication problemCheck OS authentication and SQLNET settings

Listener-Specific TNS Errors

TNS ErrorDescriptionFix
TNS-01101Listener name not recognizedVerify listener name in listener.ora
TNS-01106Listener using listener name already existsStop duplicate listener
TNS-01150Listener failed to startCheck port conflicts and configuration
TNS-01151Missing listener nameCorrect listener configuration
TNS-01189Listener could not authenticate userVerify listener password/security
TNS-01190User not authorized to execute commandUse 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. 


No comments:

Post a Comment

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

PostgreSQL Process Architecture Diagram and Details

PostgreSQL Process Architecture Diagram                            +------------------+                            |    POSTMASTER    |     ...