From oracle-l-bounce@freelists.org Fri Jun 3 09:54:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j53EskXB015669 for ; Fri, 3 Jun 2005 09:54:46 -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 j53EsjNi015662 for ; Fri, 3 Jun 2005 09:54:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 36B6D1B83E7; Fri, 3 Jun 2005 08:51:39 -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 14098-08; Fri, 3 Jun 2005 08:51:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B28831BB1CF; Fri, 3 Jun 2005 08:51:38 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: Taf issue in 9i rac on redhat linux 3 Date: Fri, 3 Jun 2005 09:49:47 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Taf issue in 9i rac on redhat linux 3 Thread-Index: AcVn71YSiEBuDv2oToaE2ob6FC494gAGGFDAAA6mXxU= From: "Marquez, Chris" To: , Cc: Content-Transfer-Encoding: 8bit X-archive-position: 20640 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 Arun, I when I used TAF the failover-reconnect was immediate. I do not believe I used LOAD_BALANCE nor FAILOVER (v8, v9) during my tests. And I have no idea what the "enable = broken" parameter does. But I agree with Christian, try TAF config without these. I to think I had session confusion when using these various connection parameters and TAF. The all do different things regarding "when", "how", and "what" to connect to...I will look through my old notes? Good luck and keep us posted on what you find. Chris Marquez Oracle DBA -----Original Message----- From: oracle-l-bounce@freelists.org on behalf of Christian Antognini Sent: Fri 6/3/2005 3:07 AM To: arunrao_oradba@yahoo.co.in Cc: oracle-l@freelists.org Subject: RE: Taf issue in 9i rac on redhat linux 3 Arun >If one of the nodes freezes(like powering down the >node)the TAF clients are taking a very long time to >failover to the working node almost i can say around >10 to 15 mins I don't know if it's relevant for your problem, anyway, with LOAD_BALANCE=ON I was able to reproduce at will the following problem by one of my customers a couple of years ago (was 9.2.0.4, I think...). Let's say we have two nodes. Node A is much more loaded than node B (I know, it should not happen since LOAD_BALANCE=ON, but we work with real systems...). Now, when node B crashes (e.g. powered off...), the new connections should go to node A. But, the listener on node A is still thinking that node B is there AND is less loaded. Therefore they are forwarded to node B... Since node B is not up and running the client gets a nice error! We find only two methods to solve this problem: - don't use LOAD_BALANCE=ON - execute "lsnrctl reload" on node A Therefore, IMO, you should do some tests without LOAD_BALANCE=ON. HTH Chris -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l