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 taking too long

725039Feb 27 2010 — edited Mar 1 2010

Hi All,

Our DB just started acting up today. I keep getting TNS-12547 TNS:lost contact errrors from EM, but I cannot login to OEM.

tnsping command takes forever to run

[zambia@cdrserver ~]$ tnsping zambia

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2010 13:06:40

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

Used parameter files:
/oradata01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.24.99)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = zambia)))
OK (177460 msec)
[zambia@cdrserver ~]$

DB: Oracle Database 11.1.0.6.0
OS: EL5

Any ideas what the reason for this might be?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2010

Added on Feb 27 2010

#general-database-discussions

24 comments

18,027 views