Re: ORA-3113 errors after switching W2K server to new network

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 08 Jan 2004 08:39:26 -0800
Message-ID: <F001.005DC280.20040108083926@fatcity.com>

Hi Paul,

I'd start with reading Anita Bardeen's paper, available on the NYOUG site:

http://www.nyoug.org/presentations.htm

ORA-3113's, 600's and 7445's Oh My!

Are these connections local, like on the same subnet, or is there a firewall or router in between that could be performing network address translation (NAT)? Could the translation table now be the source of the timeout?

We had just the opposite at a site, whereby network contention was causing ORA-3113s, and after moving the citrix server farm from fast ethernet to gigabit, the 3113s flat out stopped.

First guess is that the cabling is to blame (works fine for fast ethernet, has issues for GigE). Second I'd figure on the new NIC and its driver. Muck with the settings for the NIC - check diagnostics for it. What is the server make, who is the network card manufacturer?

Dell uses Broadcom cards. You can check the cabling with diagnostics included in the Broadcom Advanced Control Suite. I haven't used Gigabit cards internally with Compaq/HP or IBM wintel boxes, so I'm not yet familiar with their diagnostics. This is SysAdmin space, get your sysadmin to check it out (unless that is you).

Oracle on windows couldn't kill an idle session properly if a support analyst with 10 years experience tried, so this should not be occurring, as sqlnet idle_timeout doesn't work in 8.1.7.4 and 9.2.0.4.

this sounds like a good way of killing off the idle sessions. we had to code a terminator routine to get this functionality. :)

Paul

Paul Vincent <Paul.Vincent_at_uce.ac.uk> wrote:
> Hi everybody,
>
> one of our Win2K servers, running Oracle 8.1.7, has
> recently been
> switched from the University's old network to our
> shiny new network. All
> the DNS entries have been successfully switched,
> everybody can still
> connect to the databases, and all appeared well.
> Until our users started
> reporting ORA-3113 errors (end of file on
> communiation channel). In
> every case, this happens after the user's connection
> has been inactive
> for somewhat over an hour. There are no messages in
> the database alert
> log, no trace files or dump files in the bdump,
> cdump or udump
> locations, and no messages in the listener log or in
> the sqlnet log. But
> it happens with alarming frequency, and only since
> the switch to the new
> network. The network guy who switched the server to
> the new network says
> the only change was to replace the server's previous
> network card with a
> new gigabit ethernet card. In the absence of any
> kind of server-side
> error messages or trace files, I'm more than
> somewhat stumped. None of
> the possible explanations I've found in MetaLink
> seem to apply in this
> case.
>
> Has anyone any ideas? Not only possible solutions,
> but ideas for further
> inquiries, or further questions would be welcome!
>
> Best regards,
>
> Paul Vincent
> DBA
> University of Central England
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Paul Vincent
> INET: Paul.Vincent_at_uce.ac.uk
>
> 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).

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.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).

Received on Thu Jan 08 2004 - 10:39:26 CST