ORA-12170: TNS:Connect timeout occurred [message #406758] |
Fri, 05 June 2009 11:48 |
ksmith_bluesphere
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.
Thanks
|
|
|
Re: ORA-12170: TNS:Connect timeout occurred [message #406760 is a reply to message #406758] |
Fri, 05 June 2009 11:55 |
|
BlackSwan
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
|
|
|