TNSPING is hanging...
Gurus,
DB=10.2.0.4
OS = RHEL 4
We have two databases running on same machine TRAC & NRPD and two tns aliases with database names. Listener is running fine. But somehow tnsping to these aliases is not working.. When I gave "tnsping trac" its not giving output and session get hanged.
[oracle@localhost ~]$ tnsping trac
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 05-SEP-2012 14:07:41
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.114.129)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = trac)))
--------> session is hanged here....
Can anybody help me out on this to fix this issue.
Thanks,
Hari