Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-3113 errors after switching W2K server to new network

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

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Thu, 08 Jan 2004 08:24:27 -0800
Message-ID: <F001.005DC27C.20040108082427@fatcity.com>


Paul

Sounds suspiciously like an issue we had when se set up our latest system - something in the firewall or network set-up has a TCP time-out in it. TCP (or the network or something I'm no network expert) drops the connection after 60 minutes resulting in client and Oracle server no longer being able to talk to each other (3113 etc). We get no logs either.

Sorry I can't actually help here but this error we see is nothing to do with Oracle, Net8 etc and everything to do with the network/firewall. We have not solved it yet but luckily our software is configurable and can disconnect/reconnect every 30 minutes so does not fall fowl of the issue.

T



Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider Tel: +44.1684.312364
http://www.speechmachines.com

-----Original Message-----
Sent: 08 January 2004 15:39
To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tim Onions
  INET: tim.onions_at_speechmachines.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:24:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US