My Oracle Support Banner

Listener Hang , Lsnrctl Slow Response , Tnsping Slow, Sqlplus remote connections fails (Doc ID 2305554.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Net Services - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Database Listener Hang ,

The listener status is not showing up, LSNRCTL Slow Response,Tnsping Slow ,Sqlplus connections fails with TNS-12547

 

 lsnrctl status fails : 


LSNRCTL> status 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error

 

TNSPING Delayed Response : 

 tnsping DEV2850

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 08-SEP-2017 06:17:02

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:
d:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAM
E = dev2850)))
OK (25530 msec) ======================> Huge delay 

 

tnsping fails: 

 

tnsping SBX2900

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 08-SEP-2017 06:26:48

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:
d:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAM
E = sbx2900)))
TNS-12547: TNS:lost contact

Changes

No changes

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.