Home » RDBMS Server » Networking and Gateways » ORA-12170: TNS:Connect timeout occurred (Oracle 11.1.0.7.0.7)
ORA-12170: TNS:Connect timeout occurred [message #516437] Mon, 18 July 2011 03:04 Go to next message
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
Re: ORA-12170: TNS:Connect timeout occurred [message #516438 is a reply to message #516437] Mon, 18 July 2011 03:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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).
Re: ORA-12170: TNS:Connect timeout occurred [message #516661 is a reply to message #516438] Tue, 19 July 2011 22:41 Go to previous messageGo to next message
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.
Re: ORA-12170: TNS:Connect timeout occurred [message #516666 is a reply to message #516661] Tue, 19 July 2011 22:53 Go to previous messageGo to next message
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.
Re: ORA-12170: TNS:Connect timeout occurred [message #516696 is a reply to message #516666] Wed, 20 July 2011 01:56 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Black,

Thank you for your answer.

So culprit must be Firewall/network....
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:
  


Current Time: Fri Mar 29 05:28:27 CDT 2024