slow connection to database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: slow connection to database

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    slow connection to database

    The client is microstation (CAD application) on Windows NT workstation connecting to an Oracle 8.0.3 database. All other systems connect OK, but this one system.

    I have checked...

    1. ping - no request timed out
    2. tnsping - no problem
    3. client trace - nothing amiss in these trace files

    Any other ideas to solve this issue?

    BTW, sqlplus from this problem client connects without any problem to the database.

    Thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    propabaly CAD appl itself might have probs on that NT System, which is making conn slower, as u mentioned SQLPlus has no probs in connecting to server.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Does the application use sql*net to connect if so have you tried tracing the connection to see if that gives you any pointers.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by jovery
    Does the application use sql*net to connect if so have you tried tracing the connection to see if that gives you any pointers.

    Regards
    The application uses Net8. I have compared the trace files (client trace) generated by the 'problem system' with the 'ok system', but not much of a difference between the two to pin point the problem.

    Any ideas?

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by abhaysk
    propabaly CAD appl itself might have probs on that NT System, which is making conn slower, as u mentioned SQLPlus has no probs in connecting to server.
    Nope! The same CAD appln on other systems connects ok.

  6. #6
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Maybe there is a networking issue from that NT mchien to the database server. Try performin tracert from dosprompt i.e.
    C:\>tracert 134.343.33.1

    also install this CAD application on a different machine and see what the outcome is. MAybe you need to do some Net8 SDU configuration o server and client. Look for net8 tuning on metalink.

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: slow connection to database

    Originally posted by ggnanaraj
    The client is microstation (CAD application) on Windows NT workstation connecting to an Oracle 8.0.3 database. All other systems connect OK, but this one system.

    I have checked...

    1. ping - no request timed out
    2. tnsping - no problem
    3. client trace - nothing amiss in these trace files

    Any other ideas to solve this issue?

    BTW, sqlplus from this problem client connects without any problem to the database.

    Thanks.
    Just check the location of file containing connect strings (equavalent to tnsnames.ora for sqlplus connections) and change the location to someother folder and check the connection speed.. It may help you.
    -nagarjuna

  8. #8
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Also make sure the ethernet card is set to "FULL DUPLEX".
    "High Salaries = Happiness = Project Success."

  9. #9
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by jlakhani
    Also make sure the ethernet card is set to "FULL DUPLEX".
    I've done this but no gain! Thanks for the input.

  10. #10
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Got something amiss in the trace file of the slow system...which is not available in the others

    nserror: entry
    nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0
    snsbitts_ts: entry
    snsbitts_ts: acquired the bit
    snsbitts_ts: normal exit
    snsbitcl_ts: entry
    snsbitcl_ts: normal exit
    nsrdr: error exit
    snsbitts_ts: entry
    snsbitts_ts: acquired the bit
    snsbitts_ts: normal exit
    snsbitcl_ts: entry
    snsbitcl_ts: normal exit
    snsbitts_ts: entry
    snsbitts_ts: acquired the bit
    snsbitts_ts: normal exit
    nsdo: nsctxrnk=0
    snsbitcl_ts: entry
    snsbitcl_ts: normal exit
    nsdo: error exit
    nioqrc: wanted 1 got 0, type 0
    nioqper: error from nioqrc
    nioqper: nr err code: 0
    nioqper: ns main err code: 12547
    nioqper: ns (2) err code: 12560
    nioqper: nt main err code: 517
    nioqper: nt (2) err code: 54
    nioqper: nt OS err code: 0
    nioqer: entry
    nioqer: incoming err = 12151
    nioqce: entry
    nioqce: exit
    nioqer: returning err = 3113
    nioqer: exit
    nioqrc: exit
    nioqbr: entry
    nioqbr: state = normal (0)
    nioqsm: entry
    nioqsm: Sending break packet (1)...
    nsdo: entry
    nsdo: cid=0, opcode=67, *bl=1, *what=17, uflgs=0x100, cflgs=0x3
    snsbitts_ts: entry
    snsbitts_ts: acquired the bit
    snsbitts_ts: normal exit
    nsdo: rank=64, nsctxrnk=0
    snsbitcl_ts: entry
    snsbitcl_ts: normal exit
    nsdo: nsctx: state=1, flg=0x420d, mvd=0
    snsbitts_ts: entry
    snsbitts_ts: acquired the bit
    snsbitts_ts: normal exit
    nsdo: nsctxrnk=0
    snsbitcl_ts: entry
    snsbitcl_ts: normal exit
    nsdo: error exit
    nioqsm: send-break: failed to send break...
    nioqper: error from send-marker
    nioqper: nr err code: 0
    nioqper: ns main err code: 12583
    nioqper: ns (2) err code: 0
    nioqper: nt main err code: 0
    nioqper: nt (2) err code: 0
    nioqper: nt OS err code: 0
    nioqer: entry
    nioqer: incoming err = 12152
    nioqce: entry
    nioqce: exit
    nioqer: returning err = 3113
    nioqer: exit
    nioqbr: returning 3113
    nioqbr: exit
    Troubleshooting further...
    Last edited by ggnanaraj; 04-18-2003 at 05:14 AM.

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