USER taking long time to connect from local ...

Hi,

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.

Quote:

---

Fatal NI connect error 12170.

VERSION INFORMATION:
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

---

Oracle version is 10.2.0.3 on Windowz. Any help appreciated.

Thanks,

trace the session, find out what is happening and stop guessing

Hi Dave,

Thanks for your reply.

It's not a frequesnt issue. It comes once in 3-4 months and when we restart the DB the issue will resolve.

Currently, the user is able to connect normally. Will it be helpful if i enable trace now?

Thanks,

Quote:

---

Originally Posted by vnktummala

Currently, the user is able to connect normally. Will it be helpful if i enable trace now?

---

Oracle trace is good but not good enough to show an issue from the past when there are no issues in the present.