Message-ID: <40A4571B.80504@bea.com> Date: Thu, 13 May 2004 22:20:27 -0700 From: Joe Weinstein User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server To: postbus@sybrandb.verwijderdit.demon.nl Subject: Re: Oracle 9i RAC JDBC listener connection load balancing References: <883a0924.0405131228.40c2dab3@posting.google.com> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 216.148.48.12 X-Trace: news.beasys.com 1084512024 216.148.48.12 (13 May 2004 22:20:24 -0700) Organization: BEA SYSTEMS Inc Lines: 45 Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!atl-c02.usenetserver.com!news.usenetserver.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshosting.com!nx01.iad01.newshosting.com!uunet!dca.uu.net!ash.uu.net!news.beasys.com!not-for-mail Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:261644 Sybrand Bakker wrote: > On 13 May 2004 13:28:57 -0700, mexilent@hushmail.com (robert lojek) > wrote: > > >>We're trying to load balance thin-client JDBC connections to oracle 9i >>RAC nodes. The main objective is actually redundancy, i.e., if there's >>an abnormal termination of a connection due to RAC node failure and >>the load balancer detects this (within x seconds), send the retried >>connection to a different RAC node. >> >>Does anyone have experience with hardware loadbalancers tackling this >>kind of scenario, or know of a good resource to investigate this >>further? We're going to be doing some experimenting with Cisco >>LocalDirectors, and I'll report whatever we find, but I wanted to know >>if anyone else has experience dealing with this kind of issue & how >>you addressed it. >> >>Best, >> >>Robert Lojek > > > > Oracle Net comes with Transparent Application Failover and Load > balancing, suitable for RAC. Exactly what you need! > Please read those manuals prior to resorting to your own 'solution' > (which won't be supported by Oracle) Beware that TAF doesn't really support JDBC... In-progress XA transactions do not failover, certain queries may fail, and package state does not fail over so prepared statements may become defunct... http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=97926.1&p_showHeader=1&p_showHelp=1#TAFSEL > > > -- > Sybrand Bakker, Senior Oracle DBA