Listener Hang , Lsnrctl Slow Response , Tnsping Slow, Sqlplus remote connections fails

(Doc ID 2305554.1)

Last updated on SEPTEMBER 26, 2017

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

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