| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Intermittent Oracle client errors
We have a set of clients, web servers running win2k/IIS 5, using Oracle
client 8.1.7, connecting to a 9.2.0.5 DB running on a Sun box.
all machines are in same segment , behind the firewall, using local resolution (hosts file).
no TIMEOUT parameters are defined on the client or server, using all defaults.
everything working, except for some points usually with high load, in
which the connection seem to slow down and sometime we get TNS timeout
errors on the client.
the listener.log file on the server does not show any error at all,
actually when we are experiencing the periods in which the clients are
getting these errors the DB server seems to have a light load.
any clue anyone? here is a typical error I see on a client's sqlnet.log:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbprodv)(PORT=1521))(CONNECT_DATA=(SID=FPROD)(CID=(PROGRAM=D:\CFusion\Bin\cfserver.exe)(HOST=WEBSRV02)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
8.1.7.0.0 - Production
Time: 12-OCT-2005 22:15:58
Tracing not turned on.
Tns error struct:
nr err code: 0
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: 60
nt OS err code: 0
Received on Fri Oct 14 2005 - 13:10:32 CDT
 |
 |