Printable View
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.
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.
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.Quote:
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
Any ideas?
Nope! The same CAD appln on other systems connects ok.Quote:
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.
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
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.Quote:
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.
Also make sure the ethernet card is set to "FULL DUPLEX".
I've done this but no gain! Thanks for the input.Quote:
Originally posted by jlakhani
Also make sure the ethernet card is set to "FULL DUPLEX".
Got something amiss in the trace file of the slow system...which is not available in the others
Troubleshooting further...Quote:
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
The problem has been identified as 'winsock error 54' from the trace file. The winsock dll of windows NT.
Thanks.
Fix?
It is out of my hands now, I've passed it on to sysadmin. They said they'll identify the dll and replace it. If this does not solve the issue, worse comes worst, they'll have to do a fresh os install.
Cheers.