We’re getting a bunch of TNS timeouts logged in our server’s alert log that
appear to be caused by Toad for Oracle Base v10.6.1.3 sessions.
Fatal NI connect error 12170.
TNS for Linux: Version 22.214.171.124.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 126.96.36.199.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 188.8.131.52.0 - Production
Time: 04-OCT-2011 19:13:10
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=whatever)(PORT=whatever))
Can anyone suggest where I can either
- disable the timeout (developers on the test machine leaving sessions overnight)
- disable these errors from cluttering up the alert log?
Thanks in advance,