Home » RDBMS Server » Networking and Gateways » error TNS-12170
error TNS-12170 [message #406409] Wed, 03 June 2009 22:58 Go to next message
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
Michel Cadot
Messages: 68342
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).

Previous Topic: ORA-12518: TNS:listener could not hand off client connection.
Next Topic: not found cmctl and namesctl
Goto Forum:

Current Time: Mon Jan 30 19:27:41 CST 2023