error TNS-12170 [message #406409] |
Wed, 03 June 2009 22:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
eswin
Messages: 3 Registered: May 2009 Location: EKM->Kerala->India
|
Junior Member |
|
|
Hi Expertz
error TNS-12170 : connection timed out
Im getting this error while trying to exp/imp database
Please help
|
|
|
Re: error TNS-12170 [message #406416 is a reply to message #406409] |
Wed, 03 June 2009 23:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
TNS-12170: TNS:Connect timeout occurred
*Cause: The server shut down because connection establishment or
communication with a client failed to complete within the allotted time
interval. This may be a result of network or 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 or system,
reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
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).
Regards
Michel
|
|
|