From oracle-l-bounce@freelists.org Tue Aug 9 14:49:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j79JnCwE006419 for ; Tue, 9 Aug 2005 14:49:12 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j79Jn6IP006407 for ; Tue, 9 Aug 2005 14:49:06 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C652E3E71; Tue, 9 Aug 2005 14:49:02 -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 16402-03; Tue, 9 Aug 2005 14:49:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D4A041DD6B9; Tue, 9 Aug 2005 14:49:01 -0500 (EST) Message-ID: <1123616827.42f9083b3b241@webmail.corenap.com> Date: Tue, 9 Aug 2005 14:47:07 CDT From: Bryan Thomas To: davidsharples@gmail.com Cc: "oracle-l@freelists.org" Subject: Re: RAC and tcp timeout References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 65.161.188.11 X-archive-position: 23642 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bthomas@perftuning.com Precedence: normal Reply-To: bthomas@perftuning.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 Hi David, The question is, what type of connection string are you using to connect to the instance? Are you using TAF? If so what type. You may be using the delay and retries. This could make all connections to server1 wait until they timeout until trying to connect to server2. -Bryan Quoting David Sharples : > HI, > > Redhat 2.1, 9.2.0.5, 2 Node RAC. > > 2 servers, server1 and server2 > > server1 has died so all requests for connection are going to server > two. However new connections are taking somewhere around 3 minutes to > get in. > > tnsping also takes around the same time. > > The server2 isn't overloaded (there are no connections). > > Does this sound like a tcp timeout issue where the connection is > waiting too long for a no connection type message. If so which > setting(s) could it be? > > Or could it be something else. The listener setup looks fine on > visyal inspection > > Thanks > -- > http://www.freelists.org/webpage/oracle-l > Bryan Thomas Senior Performance Consultant Performance Tuning Corporation www.perftuning.com (512)751-5516 bthomas@perftuning.com -- http://www.freelists.org/webpage/oracle-l