OraFAQ Forum: Networking and Gateways » ORA-12170: TNS:Connect timeout occurred

Home » RDBMS Server » Networking and Gateways » ORA-12170: TNS:Connect timeout occurred (Oracle 11.1.0.7.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12170: TNS:Connect timeout occurred [message #516437]

Mon, 18 July 2011 03:04

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi ,

I was getting the following error when trying to connect development database.

sqlplus bala/test11@ORCL.SBC.COM

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:04:18 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12170: TNS:Connect timeout occurred

Enter user-name:

But i am to connect this database through putty,toad at that time. But after sometime,
i was able to connect the database.

Can somebody tell me what could be the reason of the error ?

Thanks

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred [message #516438 is a reply to message #516437]

Mon, 18 July 2011 03:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

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).

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred [message #516661 is a reply to message #516438]

Tue, 19 July 2011 22:41

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thank you littlefoot.
But i am facing this error now and then.Sometime i am able to connect toad that time ,
i am unable to connect SQLPLUS.Sometime , i am able to connect SQLPLUS that time i am unable to connect TOAD.
This is the situation i am facing in database connectivity.

Please advice.

Thanks.

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred [message #516666 is a reply to message #516661]

Tue, 19 July 2011 22:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-12170: TNS:Connect timeout occurred(Oracle 11.1.0.7.0.7)
>SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:04:18 2011

if ORA-12170 occurs when connection request is initiated, then a likely cause is a Firewall
if ORA-12170 occurs after being successfully connected a while then a general Networking failure occurred.
For both of these Oracle is victim; not culprit & root cause is external to Oracle & not something we can assist with further.

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred [message #516696 is a reply to message #516666]

Wed, 20 July 2011 01:56

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Black,

Thank you for your answer.

So culprit must be Firewall/network....

Report message to a moderator

Previous Topic:	how to configure putty for running pl/sql through linux,i have two OS Window xp and linux in my pc(2
Next Topic:	C++ and error ORA-12154

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 22:52:07 CST 2025