I don't think it's accurate to say that NET8 isn't involved when you're talking directly to the listener =8-) More correctly you are eliminating the NET8 client DLL's...but you could still have the connections dropping due to transient network failures.
I have a particular problem with CISCO switches and TRU64 Alpha boxes in my environment. JDBC thick connections drop but because they are 'thick' I get a SQLNET.LOG file on the client that shows a TNS-12203 (unable to connect to destination) error. Other apps like Maximo report an ORA-3113 but also show the TNS-12203 error in their sqlnet.log files. When I do a level 16 listener trace I can see the connection being closed (read() error) but I've never been able to figure out why =8-( The only thing that moderates the problem is to make sure that the Alpha is set to 100MB/Full Duplex instead of auto-detect as well as hard-coding these values on the switch port. Ditto for the NT app servers. "friends don't let friends auto-negotiate" =8-) But I still see periodic TNS-12203's ....just less of them Try doing a level 16 trace from the listner end. Jeff Herrick On Thu, 9 Oct 2003, DENNIS WILLIAMS wrote: > Agreed. By the way, since my original posting, this error has occurred > several more times. > Yes, it is a catch-all error that sounds a lot like an ORA-3113. Since > they using the Oracle thin JDBC driver, which talks directly to the > listener, Net8 isn't involved. If the server is shut down or crashes, > apparently this error is also returned, like an ORA-3113. But the server > hasn't crashed or shut down. > [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
