Home » RDBMS Server » Networking and Gateways » ORA-12170: TNS:Connect timeout occurred (Windows XP, Oracle 10g client)
ORA-12170: TNS:Connect timeout occurred [message #406758] Fri, 05 June 2009 11:48 Go to next message
Messages: 1
Registered: June 2009
Junior Member
I'm a .NET developer trying to connect to oracle server in code. I am getting an exception:
ORA-12170: TNS:Connect timeout occurred

Using Oracle Net Manager I can see the database and do a 'test connection' and I get 'The connection test was successful.'

Using tnsping from command prompt:
tnsping dbs06_p
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = oradbs06_pdb) (Port = 15021)) (CONNECT_DATA = (SID = dbs06_p)))
OK (80 msec)

Those seem fine, so why am I getting exception in code? I tried use sqlnet.ora to change timeouts to no avail.

Any help is appreciated. I can provide more information as needed.


Re: ORA-12170: TNS:Connect timeout occurred [message #406760 is a reply to message #406758] Fri, 05 June 2009 11:55 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
12170, 00000, "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).

>(Port = 15021)
unusual - most folks use port=1521

post tail end of listener.log file from DB server system
Previous Topic: not found cmctl and namesctl
Next Topic: cman and listener
Goto Forum:

Current Time: Fri Jan 27 21:37:29 CST 2023