From oracle-l-bounce@freelists.org Tue Mar 30 15:15:01 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2ULF1T15590 for ; Tue, 30 Mar 2004 15:15:01 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2ULF0o15585 for ; Tue, 30 Mar 2004 15:15:00 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 491FD6347BA; Tue, 30 Mar 2004 16:11:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14892-85; Tue, 30 Mar 2004 16:11:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8DD86634630; Tue, 30 Mar 2004 16:11:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 16:10:26 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43D00634684 for ; Tue, 30 Mar 2004 16:10:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15274-21 for ; Tue, 30 Mar 2004 16:10:26 -0500 (EST) Received: from smtp.wangtrading.com (smtp.wangtrading.com [167.206.68.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A17056347BA for ; Tue, 30 Mar 2004 16:10:25 -0500 (EST) Received: from mladen.wangtrading.com (Not Verified[192.168.3.47]) by smtp.wangtrading.com with NetIQ MailMarshal (v5.5.5.8) id ; Tue, 30 Mar 2004 16:17:25 -0500 Received: from mladen (localhost.localdomain [127.0.0.1]) by mladen.wangtrading.com (8.12.8/8.12.8) with ESMTP id i2ULIXOL001774 for ; Tue, 30 Mar 2004 16:18:33 -0500 Date: Tue, 30 Mar 2004 16:18:33 -0500 From: Mladen Gogala To: oracle-l@freelists.org Subject: Re: ORA-03113 end of file on communication channel Message-ID: <20040330211833.GC1749@mladen.wangtrading.com> References: <27809242.1080678786589.JavaMail.root@huey.psp.pas.earthlink.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline In-Reply-To: <27809242.1080678786589.JavaMail.root@huey.psp.pas.earthlink.net> (from davewendelken@earthlink.net on Tue, Mar 30, 2004 at 15:33:06 -0500) X-Mailer: Balsa 2.0.16 Lines: 35 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2107 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mladen@wangtrading.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Well, as you know, "the end of communication rope" happens when the server process dies. There should be an accompanying error in the alert.log file. Usually, those errors are ORA-7445 and ORA-600, which give people much craved opportunity to use metalink. ORA-7445 means that there was an exception in the server process. The only case when it can legitimately happen, without laying the blame on Pete Sharman, is when the address space is not large enough. Typically, OS will let users to have process sizes of about 2GB, and will terminate anything that exceeds the boundary. OS parameter for that purpose defines the maximum size of page tables per segment or per process. You can suspect the VM size if the address at which the problem occurs is extremely large. If, on the other hand, the address is very small, <= 4k, then the program tried to access the page 0, which has deliberately been marked "no access", in order to catch the attempts of dereferencing the NULL pointer. If the address is close to 0, oracle tried to use NULL pointer, and that is Pete's fault. ORA-600 is his fault, too. On 03/30/2004 03:33:06 PM, david wendelken wrote: > Forgot to add this bit of info: > > Have also gotten this error in very secure environments, where the network times out access to oracle sessions on remote machines fairly quickly. In that case, it legitimately is an end of communcation channel. > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------