TNS Connection timeout error.
944832Jul 4 2012 — edited Jul 4 2012Hi Team,
I am trying to connect to remote database. But its giving "connection timeout" error. Host_name, service name every thing is correct.
Pls suggest any idea or solution.
i checked, server connection is fine...
ping server_name.net
Reply from 15.20.30.44: bytes=52 time=371ms TTL=129
Reply from 15.20.30.44: bytes=52 time=188ms TTL=129
Reply from 15.20.30.44: bytes=52 time=159ms TTL=129
Reply from 15.20.30.44: bytes=52 time=183ms TTL=129
---------------------------------------------------------------------------
C:\>tnsping DATABASE_NAME.xyz.com
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 04-JUL-2
012 18:37:33
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
D:\app\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 = 15.20.30.44)
(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DATABASE_NAME.xyz
.COM)))
TNS-12535: TNS:operation timed out
----------------------------------------------------------------------------------------
Thanks & Regards