Re: Trolling for ideas

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).