12535 timeout error [message #66089] |
Thu, 08 November 2001 13:48 |
Shankar Rao
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
I was able to tnsping an Oracle 8.0 DB on an NT server which is part of our WAN till today.
I am able to ping the server but the tnsping
fails after a minute giving TNS-125345 Operation
timed out error.
Any help would be greatly appreciated
----------------------------------------------------------------------
|
|
|
Re: 12535 timeout error [message #66096 is a reply to message #66089] |
Fri, 09 November 2001 03:42 |
Kosta
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
The problem with tnsping lies in the underlining Network Protocol. In my case it is TCP IP. In order to decrease the timeout time, I had to change TCP IP registry setting : TcpMaxConnectRetransmissions from 3(default) to 1.
Now tnsping timeout is down to 9 sec if database server is down. For more info about this setting search Microsoft site.
Hope this helps.
----------------------------------------------------------------------
|
|
|