Hi Dennis, "Does anyone know how to turn on client-side SQL*Net tracing?"
Did anybody get back to you on this? Set these paramters in your sqlnet.ora file on the client you want to trace: TRACE_LEVEL_CLIENT = support trace_file_client=abfp_trace.txt trace_directory_client=c:\orant\net80\admin - Jerry -----Original Message----- Sent: Monday, February 10, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Does anyone know how to turn on client-side SQL*Net tracing? Jeff - Thanks for your idea. We were able to find the sqlnet.log file, which I was unable to find previously. It does have the TNS-12560 error you predicted. The network guys think they have the switch port hard-coded to 100Mb/s full duplex, but are checking further. However, in the sqlnet.log, it says PROTOCOL=BEQ. Does anyone have any idea where that is coming from? In the tnsnames.ora file we have TCP. In the documentation it looks like BEQ is used when the listener and server are on the same node. It is true that both the listener and server are on the same Alpha server, so is this message normal? Thanks to everyone for the great ideas that you have provided on this issue. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, February 06, 2003 6:24 PM To: Multiple recipients of list ORACLE-L Dennis Is there an sqlnet.log file tossed up on the VB client that has a TNS-12203 (unable to connect to destination) error? If so, make sure that the switch port the Alpha is plugged into has been hard-coded to 100Mb/s full duplex. "Friends don't let friends auto-negotiate" Known problem with Alpha/Cisco gear... Just a shot in the dark...but this solved a lot of Maximo crash issues for us. Cheers Jeff Herrick On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote: > I have a developer that wrote a VB program using ADO, connecting to > Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for > hours each night, and sometimes receives an ORA-03113 end-of-file on > communication channel. Not consistently, just sporadically, and at > varying amounts of time. I have been unable to find anything in the > server logs. We have traced > the program and the error occurs during different SQL statements. > Followed most of the tips I've located on solving ORA-03113 errors. I > am coming to the conclusion that maybe the only solution will be to > upgrade Oracle and hope that solves the problem. Unfortunately we can > only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? > Thanks. > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > 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). > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cunningham, Gerald 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).
