RE: Trolling for ideas

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.
dwilliams_at_lifetouch.com

-----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.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: jherrick_at_igs.net

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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: Gerald.Cunningham_at_usi.net

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: ListGuru_at_fatcity.com (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).