Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tnsping very slow

BenyoSep 25 2012 — edited Sep 25 2012
Hi Guru,
In my production database connection suddenly starts taking significant time like 30-45 seconds.
The tnsping is very slow

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME= SID)))
OK (23090 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)

The ping is OK

*[oracle@localhost etc]$ ping localhost.localdomain -s 65000*
PING localhost.localdomain (127.0.0.1) 65000(65028) bytes of data.
*65008 bytes from localhost.localdomain (127.0.0.1): icmp_req=1 ttl=64 time=0.138*
ms
*65008 bytes from localhost.localdomain (127.0.0.1): icmp_req=2 ttl=64 time=0.130*
ms
*65008 bytes from localhost.localdomain (127.0.0.1): icmp_req=3 ttl=64 time=0.118*
ms

DB: Oracle 11.1
Op: Fedora Linux

Edited by: user5285425 on 2012.09.25. 1:17
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2012
Added on Sep 25 2012
#general-database-discussions
12 comments
7,836 views