USER taking long time to connect from local ...
In one of my prod database, i have received a complaint from app team that two particular users are taking long time to connect. As a first step i tried to connect from local server and found that they are taking 4-5 minutes to connect. Others users like sys, system, other application users are able to connect in a flash.
Any idea why they are taking long time to connect from local server?
I see few error messages in sqlnet.ora file but I believe they matter when the connection is slow over network.
Oracle version is 10.2.0.3 on Windowz. Any help appreciated.
Fatal NI connect error 12170.
TNS for 64-bit Windows: Version 10.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 10.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 10.2.0.3.0 - Production
Time: 17-JUN-2009 21:32:03
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0