ORA-12170: TNS:Connect timeout occurred Cause: The server shut down because connection establishment with a client failed to complete within the allotted time interval.
This may be a result of network/system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.
Action: If the error occurred because of a slow network/system, reconfigure the SQLNET.INBOUND_CONNECT_TIMEOUT parameter in sqlnet.ora to a larger value.
If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access.
Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).
 Forum Messages
Hi all,
my name is raja, when I am trying to connect to my friend's data base from my laptop, its showing ORA-12170: TNS:Connect timeout occurred error. I tried to increase the value of SQLNET.INBOUND_CONNECT_TIMEOUT parameter. But I cant see this parameter in my sqlnet.ora file. Could you help me to solve this problem.
Thanks in advance. |
| : -> 02-JUN-2008 12:39:26 | Numer of checks | DbMotive | Reply |
Can you ping his laptop?
Is there a firewall in place?
Does tnsping work?
|
If SQLNET.INBOUND_CONNECT_TIMEOUT is not in your sqlnet.ora, you simply put it there.
Note:
SQLNET.INBOUND_CONNECT_TIMEOUT =0 is disabled
SQLNET.INBOUND_CONNECT_TIMEOUT = 360 (or whatever) is enabled)
Make sure you and your friend are not running Windows firewall... if you do, there are more things you will need to do (it can be a pain!).
Jeff- |
Add your message for ORA-12170
|
Home