USER taking long time to connect from local ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: USER taking long time to connect from local ...

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Question 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.

    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: TNSperation 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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    trace the session, find out what is happening and stop guessing

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by vnktummala View Post
    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.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width